Remove information about an error that is stored in the MacroError object. (Access 2010)


If the OnError action has been used to suppress error messages, you can use the information stored in the MacroError object in a condition or a custom error message.

By default, when an error occurs in a macro, information about the error is stored in the MacroError object, the macro stops and the error information is displayed in a standard error message.

After an error has been handled, the information in the MacroError object is out of date, so it is a good idea to clear the object (error no, description, macro name, action name, condition, and arguments) using the ClearMacroError action.



“Always assume incompetence before looking for conspiracy” ~ Niccolo Machiavelli


OnError macro action

Copyright © 1999-2024
Some rights reserved