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 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.

Examples

Docmd.ClearMacroError

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

Related

OnError macro action


 
Copyright © 1999-2024 SS64.com
Some rights reserved