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
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Conan Kelly" <(E-Mail Removed)> wrote in message
news:4JLYi.7203$(E-Mail Removed)...
> 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
Similar Threads
