Turn off on confirmation messages

B

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
 
S

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.
 
S

Sandra Martin

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

Thanks,
Sandra
 
P

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.
 
Top