Search results

  1. J

    Combining multiple single sheet workbooks into one large workbook

    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...
  2. J

    cancel form_close

    Can you use this to prevent someone from Closing the entire instance of Access?
  3. J

    Referencing control by value in field

    Thank you very much sir. Have a great holiday season. Dave
  4. J

    Referencing control by value in field

    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...
  5. J

    Solving a formula

    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...
  6. J

    Variable representing Max Value

    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...
Back
Top Bottom