I have 20+ individual workbooks that all contain one worksheet a piece.
I need to copy the data and formatting from those individual workbooks into 20+ seperate tabs in a single workbook.
Both the file names and the resulting tabs can be static in naming convention.
I tried to use access to...
Happy Holidays to everyone,
I'm trying to reference a control so I can change the position of it. I need to step through a table and grab the control name from a field in the table/form.
For example TableA has 3 fields [Fieldname], [Left], [Top]
On a different form I'll have OLE objects that...
I would like to store a formula at the record level
i.e. (W/1.5)*L*H
I have three unbound fields that I will declare the values of the three variables.
I need the user to be able to store the formula in simple algebraic terms like above. When a button on the record is clicked, I need to...
I have tried searching to no avail. I'd like to dim a public variable that would represent the max value of a specific field in a table. To skin the cat another way, the field is an autonumber so representing the value for that field in the last record of the table would also suffice.
Any...