Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: flize
  • Order by date
  1. flize

    Conditional Formatting - Date function not consistent

    Thanks AceMan1 - that code did the trick! One minor error in the code with the line: FCS.FormatConditions.Delete It should just be: FCS.Delete since FCS was already set as FormatConditions Also, I have a couple other 'easy' question(s) for you if you don't mind (regarding a couple lines of...
  2. flize

    Conditional Formatting - Date function not consistent

    Problem: Coding conditional formats returns different (inaccurate) results then when using the built in conditional formatting functionality (via the menu). In Access on a datasheet form, when I create multiple formatting conditions for a field using the 'Conditional Formatting...' option on...
  3. flize

    Controlling datasheet properties in code

    Yes, I got it now! When you mentioned the tables properties, that threw me off. So, I just needed to reference the control's columnsize and columnwidth properties ( as well as columnhidden)...works great. Thanks again! flize
  4. flize

    Controlling datasheet properties in code

    Thanks gol4, thats a step in the right direction. But my problem is that I don't use a table or predefined query as the datasource. The datasheet's record source is based on a dynamic SQL string stored in a variable (SQLvar) that is created by various user selections. I set it dynamically in...
  5. flize

    Controlling datasheet properties in code

    When I view a datasheet as a subform from a main form, I can resize the width and reorder the columns on the grid display, then select SAVE from the File menu to save those settings. How can I update or access these settings in code? When I view the individual fields on the subform in design...
  6. flize

    Save text from input box as a text file

    Thanks from me too doorbreaker! All I wanted to do was write a string var to a text file and that small example was perfect. flize
  7. flize

    Return current Excel row to Access

    Found the answer in FAQ... From Access, I was trying to determine the row count of a column of data. If the spreadsheet had 57 rows of data, I was looking for the function that returned that value of 57. This is what I needed... worksheet.UsedRange.rows.Count
  8. flize

    Return current Excel row to Access

    Anyone got an idea on this one? It seems like its got to be a simple or straight-forward command or call, but I'm just not sure what I am missing here...
  9. flize

    Return current Excel row to Access

    I've created the necessary excel objects and am referencing a spreadsheet from a form module. I now need to determine how many rows of data are in the sheet. Assuming there are no blank rows, how can I determine how many rows of data are in column 'A' for example. I've tried a couple methods I...
  10. flize

    Form (global) level event handling

    DanJR, Excellent - a star for you! That answered my question. Thanks much.
  11. flize

    Form (global) level event handling

    PHV, the form is unbound. The text boxes get their values from code written in a subform. As the user scrolls through records on a grid on the main form (via a subform datasheet), the subform's form_current event writes current record field values back to the main form text boxes. Then, if the...
  12. flize

    Form (global) level event handling

    I have a form with a lot of editable text boxes. When the user changes (updates) the data in some of the text boxes, I want to set a global boolean variable to true. However, I don't want to create an after_update event procedure for each and every text box just to set one global variable to...
  13. flize

    How to close Excel from Access using VBA?

    All, I had the same issues with trying to control Excel 2000 from Access 97. The Microsoft Excel 9.0 Object Library ActiveX control does not close the spreadsheet file as described in several books, MSDN or the online help file examples. To get it to work, I discarded the Excel.Application...
  14. flize

    Overwrite file on save

    Thank you, Zathras!!! Your suggestion for setting Application.DisplayAlerts = False worked like a charm. I am using Access 97 and all I wanted to do was open an existing spreadsheet (in Excel 2000), write to some cells, save it and return to Access without any user intervention. To make it...

Part and Inventory Search

Back
Top