Macro running multiple queries

P

Pat

I have a macro that runs several queries but I don not
want to receive the message that so many items will be
appended and then having to hit ok - Is there a way to
hide these messages and not have to say ok?

Thanks.

Pat
 
T

TPratt

At the start of the macro turn "setwarnings" to "off".

I recommend turning back to "on" at the end of macro though.
 
Top