Disable system dialogs

[Nigel]

In Excel there is an option DisplayEvents = True /False to
turn off dialogues that Excel generates from within VBA.

Is there an equivalent function in Access?

I am updating some tables and get Access messages about
record changes etc., I need to disable these when required
from the programme.

TIA

 

[Douglas J. Steele]

DoCmd.SetWarnings False to stop them, DoCmd.SetWarnings True to turn them
back on.

Alternatively, you can use the Execute method (applies to the DAO Database
and QueryDef objects), which not only doesn't display the warnings, but can
also generate a trappable error if the query doesn't work.

 

[danna]

In Excel there is an option DisplayEvents = True /False to
turn off dialogues that Excel generates from within VBA.

Is there an equivalent function in Access?

I am updating some tables and get Access messages about
record changes etc., I need to disable these when required
from the programme.

TIA