Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can use the RemoveAllTempVars macro action in Access desktop databases to remove any temporary variables that you created by using the SetTempVar macro action.

Setting

The RemoveAllTempVars macro action does not have any arguments.

Remarks

  • 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 or project. It is a good practice to remove temporary variables when you are finished using them.

  • Access automatically removes all temporary variables when you close the database or project.

  • To remove a single temporary variable, use the RemoveTempVar action and set its argument to the name of the temporary variable you want to remove.

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

Example

The following macro demonstrates how to create a temporary variable, use it in a condition and a message box, and then remove the temporary variable by using the RemoveAllTempVars action.

Condition

Action

Arguments

SetTempVar

Name: MyVar

Expression: InputBox("Enter a non-zero number.")

[TempVars]![MyVar]<>0

MsgBox

Message: ="You entered " & [TempVars]![MyVar] & "."

Beep: Yes

Type: Information

RemoveAllTempVars

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×