Free E-Books

The RunMacro action moves the execution to the macro??™s Cleanup macro name. The
Cleanup section of the macro removes the temporary variables.
There??™s no Resume functionality in macro error handling. If you want to run additional
code after the error-handling actions, you must use the RunMacro action to run
another macro or place the actions in the error-handling section of the macro.
The RunMacro action also appears after the MsgBox action in the main section of the macro.
Because you??™re using macro names, the macro stops after it reaches the ErrorHandler macro
name. In order to force the cleanup of the temporary variables, use the RunMacro action to run
the Cleanup macro name. Otherwise, you??™d have to put the RemoveTempVar actions in the
main section and in the ErrorHandler section of the macro.
The MacroError object
The MacroError object??”new to Access 2007??”contains information about the last macro error
that occurred. It retains this information until a new error occurs or you clear it with the
ClearMacroError action.


Pages:
2135 2136 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159