Turn off on confirmation messages

[Bruce]

How do I turn the Confirmation Messages off and on in a Macro? I want to turn
off the confirmation messages, run the queries, and then turn them back on
once the programs have run.

Bruce

 

[Steve Schapel]

Bruce,

Put a SetWarnings/No action in your macro prior to your first OpenQuery
action.

There is no need to "turn them back on", as this is automatically done
when the macro finishes.

 

[Bruce]

Thank you Steve, sometimes it is right there in front of you.

 

[Sandra Martin]

So, Steve, what if SetWarnings isn't in the action list? I'm new to Macros
so please be kind.

Thanks,
Sandra

 

[Pete D.]

Sounds like you have 2007, at the top of the macro window select the button
show all actions. It should now appear in the choices.