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]
