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

SetWarnings NO, then turn them back on

For macros that would be SetWarnings NO and then SetWarnings YES

Thanks!! i'll give it a shot.