Speeding up Macros

[salisbut]

I currently have a daily macros set up which has 4 append queries and 2 delete queries. They all run fine, but I am curious to know if I can get rid of the warning messages that appear when I append or delte. Currently it asks if I want to run the action query then asks if I want to append/delete so many records. I want to know if I can get rid of this and just have the macros run without asking these questions. Thanks

[pbaldy]

In a macro, look at the SetWarnings action. Make sure to set them back after.

[salisbut]

Thanks! That worked like a charm!

[pbaldy]

Happy to help!