Macros

[Guest]

How do I remove the pop-up messages when running a macro with several queries
which are make table ones?

Many Thanks

 

[James]

Hi

Before the macro runs the queries insert the 'setwarnings' action to
no and remember to switch it back on again as necessary.

James

 

[John W. Vinson]

How do I remove the pop-up messages when running a macro with several queries
which are make table ones?

Many Thanks

Put a line in the macro to set SetWarnings to False before running the
queries; be SURE to set SetWarnings back to True after the queries (or it will
turn off all Access warning messages for the rest of the session).

One question: MakeTable queries are, in my experience, VERY rarely needed. If
you're importing data you can import into existing tables; if you're exporting
data you can export from a Select Query; if you want to see a Form or Report
you can base it on a Query. What is the purpose of these repetitive
make-tables?

John W. Vinson [MVP]