Macro Click Yes/OK

[jereece]

I have a macro that runs 6 queries. After each query, I get a prompt to ask me if I want to delete the existing data. Is there a way I can include in my macro an action to accept the prompt (i.e. click yes or ok)?

Thanks,
Jim

 

[boblarson]

Include a step at the beginning of your macro:
SetWarnings
and the value is NO (if using VBA it would be FALSE but in a macro it's NO).

And then at the very end of your macro that runs the queries, use the
SetWarnings
step and this time the value is YES (TRUE in VBA).

Hope that helps!

 

[Roach]

SetWarnings

This may work....the first action to set up in the macro is "SetWarnings". Then on the bottom of the screen it will say "Warnings On" and change that to "No".

Hope that works for you.

Peace,
Roach

 

[jereece]

This worked great! Thanks.

Jim