DoCmd.ClearMacroError

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

Syntax
      DoCmd.ClearMacroError

If the OnError action has been used to suppress error messages, you may want to 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.

Example

Docmd.ClearMacroError

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

Related:

OnError macro action


© Copyright SS64.com 1999-2013
Some rights reserved