DoCmd.SetWarnings Method (Access)

Published: July 16, 2012

The SetWarnings method carries out the SetWarnings action in Visual Basic.

expression .SetWarnings(WarningsOn)

expression A variable that represents a DoCmd object.

Parameters

Name

Required/Optional

Data Type

Description

WarningsOn

Required

Variant

Use True (–1) to turn on the display of system messages and False (0) to turn it off.

You can use the SetWarnings method to turn system messages on or off.

If you turn the display of system messages off in Visual Basic, you must turn it back on, or it will remain off, even if the user presses CTRL+BREAK or Visual Basic encounters a breakpoint. You may want to create a macro that turns the display of system messages on and then assign that macro to a key combination or a custom menu command. You could then use the key combination or menu command to turn the display of system messages on if it has been turned off in Visual Basic.

Sample code provided by: Community Member Icon The UtterAccess community | About the Contributors

The following example turns the display of system messages off:

DoCmd.SetWarnings False

UtterAccess is the premier Microsoft Access wiki and help forum. Click here to join.

Community Additions

ADD
Show:
© 2014 Microsoft