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...
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...
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
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...
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...
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
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.