Search results

  1. A

    "Solver" Function

    Does anyone know if there is a function in Access similar to the "Solver" function in Excel? I need to vary a calculation input until the calculation matches another number. Can anyone help me with this? Thanks!
  2. A

    Referencing Tables

    Hi everyone, In my code, I am able to set a variable equal to a form, but not a table. For example: dim z as object set z = Forms("My Form") However, I cannot set a variable equal to a table.... set z = Tables("My Table") does not work Does anyone have any advice? Thanks!
  3. A

    Help with Code

    Hi everyone, I'm wondering how to enter code that says, "Delete all the rows in a table except the last one". Does anyone know how to do this? I was thinking something along the lines of: Do Until CurrentRecord Is Last ... Loop -with the "..." representing a simple deletion macro I built...
  4. A

    "Indirect" Function

    Does anybody know if there is a function in Access like the "Indirect" function in Excel? I am linking 2 tables, and I need to pull back the column in one of these tables that is named the same as the values of a column in another table. Thanks! Andy
  5. A

    Date Formatting

    Does anyone know the expression for putting a date in the format "MMDDYY" without any /'s? In Excel, this can be accomplished with Month() & Day() & Year(). Thanks! Andy
  6. A

    Suppressing Alerts in Access

    Does anyone know how to suppress alerts in Access? I know the code in Excel is: Application.Displayalerts = False However, this does not work in Access. Thanks!
  7. A

    Suppressing Alerts in Access

    Does anyone know how to suppress alerts in Access? I know the code in Excel is: Application.Displayalerts = False But this does not work in Access. Thanks!
Back
Top Bottom