Removal of query messages whilst using macros?

[Guest]

I am using delete, update and apprend queries within a macro. I would like to
deactivate the waring pop up windows.
Is there some way to do this or will I have to rewrite the macro in code to
solve my problem?
Thank you for your time.

 

[Guest]

If you want to remove the messages for all queries, without using the set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to know that it will never prompt with the message event when
you are using the queries directly
==================================
if you don't want to use this method, then after you run the update query
you need to set the warnings back to true

Docmd.SetWarnings False
Docmd.RunMacro "MacroName"
Docmd.SetWarnings True

 

[Guest]

Before first query use Set Wannings -- Off
After last Set Warnnings -- On