Answer Dialogboxes from queries

[Daniel Schaedler]

Hi

I would like to execute a series of delete- and update- queries. I created a
macro to call them one after another...everything fine so far. But
unfortunately I have to answer several dialogboxes ("You are about to run a
query...."). Is there a possibility to suppress this dialogboxes, or to
answer them automatically?

the question sounds simple, but I couldn't find an answer yet :-(

regards
daniel

 

[Douglas J. Steele]

Put in a SetWarnings No before you run the queries, and a Set Warning Yes
afterwards.

In reality, though, you might be better off using a VBA module, and using
the Execute method to run each query. That allows you to catch errors, so
that if query 2 doesn't run successfully, you won't run any of the
subsequent queries (unless you want to)