You can use the SetWarnings action to turn system messages on or off.
The SetWarnings action uses the following argument.
Action argument |
Description |
Warnings On |
Specifies whether system messages are displayed. Click Yes to turn on system messages or No not to turn on system messages. The default is No. |
You can use this action to prevent modal warnings and message boxes from stopping the macro. However, error messages are always displayed. Also, Microsoft Access displays any dialog boxes that require input other than just choosing a button (such as OK, Cancel, Yes, or No) — for example, any dialog box that requires you to enter text or select one of several options.
This action has the same effect as pressing ENTER whenever a warning or message box is displayed. Typically, an OK or Yes is chosen in response to the warning or message.
When the macro finishes, Microsoft Access automatically turns the display of the system messages back on.
Often, you’ll use this action with the Echo action, which hides the results of a macro until it is finished. You can use the SetWarnings action to hide the warnings and message boxes as well.
Caution Although the SetWarnings action can simplify interactions with macros, you must be careful about turning system messages off. In some situations, you won’t want to continue a macro if a certain warning message is displayed. Unless you’re confident of the outcome of all macro actions, you should avoid using this action.
To run the SetWarnings action in Visual Basic, use the SetWarnings method of the DoCmd object.
Echo Action, SetWarnings Method.