Turn off on confirmation messages

  • Thread starter Thread starter Bruce
  • Start date Start date
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
 
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.
 
So, Steve, what if SetWarnings isn't in the action list? I'm new to Macros
so please be kind.

Thanks,
Sandra
 
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.
 
Back
Top