Disabling notifications

  • Thread starter Thread starter Conan Kelly
  • Start date Start date
C

Conan Kelly

Hello all,

help files say that "DoCmd.SetWarnings" will enable/disable "System
Messages".

What are all the messages that are considered "System Messages"?

In Access>Tools>Options...>Edit/Find tab>Confirm group, there are 3 items:
Record Changes, Document deletions, & Action queries.

Are all 3 of these considered System Messages? Are there any more?

Can I programatically set each one of these 3 individually? If so, what is
the code, please?

Thanks for any help anyone can provide,

Conan Kelly
 
It might be helpful to know what you are seeking to do.

In general, you want to leave SetWarnings turned on. Use the Exeucte method
to run your action queries (instead of RunSQL or OpenQuery.) More info:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

You also want to leave the confirmation options checked for most scenarios.
Otherwise objects are deleted from the Database window without confirmation.
Rather than turn the option off, it's much better to use Shift+Delete to
delete objects without confirmation.

Similarly, deleting records without confirmation is generally not a good
idea. A side-effect of doing that is that your form's BeforeDelConfirm and
AfterDelConfirm don't fire, so any checking or custom messages are also
suppressed if you do that.

If you do want to set the options programmatically, this list gives you the
option names to use:
http://msdn2.microsoft.com/en-us/library/Aa140014(office.10).aspx
 
Back
Top