SetTempVar Macro Action

The SetTempVar action has the following arguments.

• You can have up to 255 temporary variables defined at one time. If you do not remove a temporary variable, it will remain in memory until you close the database. It is a good practice to remove temporary variables when you are finished using them. To remove a single temporary variable, use the RemoveTempVar action and set its argument to the name of the temporary variable that you want to remove. If you have more than one temporary variable and you want to remove them all at once, use the RemoveAllTempVars action.

• Temporary variables are global. Once a temporary variable has been created, you can refer to it in an event procedure, a Visual Basic for Applications (VBA) module, a query, or an expression. For example, if you created a temporary variable named MyVar, you could use the variable as the control source for a text box by using the following syntax:

  Copy

  =[TempVars]![MyVar]
  

  Note
  In macros, queries and event procedures, you do not need to precede the expression with an equal sign.

  You can also refer to temporary variables in any add-ins or referenced databases.

• To run the SetTempVar action in a VBA module, use the Add method of the TempVars object.

The following macro demonstrates how to create a temporary variable by using the SetTempVar action, then using the temporary variable in a condition and a message box, and then removing the temporary variable.