Disable system dialogs

  • Thread starter Thread starter Nigel
  • Start date Start date
N

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
 
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.
 
Nigel said:
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
Click to expand...
 
Back
Top