how to click "Yes" in a macro.....

[LeverColson]

I have a number of queries set up in a macro, however some ask for approval before finishing, i.e. append xx records. How can i have that automatically approve and continue to the next query?

Many thanks!
Scott

 

[jeremypaule]

SetWarnings NO, then turn them back on

 

[boblarson]

For macros that would be SetWarnings NO and then SetWarnings YES

 

[LeverColson]

Thanks!! i'll give it a shot.