Answer Dialogboxes from queries

  • Thread starter Thread starter Daniel Schaedler
  • Start date Start date
D

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
 
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)
 
Back
Top