Stringing queries together in a macro 1

[TerryEA]

Hi all

There is probably a better way of doing this but...

I have a macro running 4 append queries, one after the other. Of course Access display alert balloons to warn that data will be changed, and because there are 4 queries it does this 4 times - it's a pain for the user. Is there a way to suppress the alerts or a better way of running the queries?

Terry

 

[PHV]

Have a look at SetWarnings

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TerryEA]

Great, thanks PHV. Easy when you know how, isn't it.