Make Table Query

  • Thread starter Thread starter Alan W
  • Start date Start date
A

Alan W

I have a Make Table Query which copies a table in my
databae but when it runs it comes up with the message:
"The existing table 'xxx' will be deleted before you run
the query - Do you want to continue anyway?"
Since the database is to be automated is there any way of
preventing this message from coming up or someway to
default the response to 'yes'?

Thanks

Alan
 
Alan,

Absolutely.

Docmd.setwarnings False
....
your code here
....
Docmd.setwarnings true

Make sure you set the warnings back on after you turn them off.

HTH
Dale
 
Hi, thanks for that.

But where do you insert the code as I create the queries
in design view so the only code I can find are the two
lines of SQL used to make the query?

Thanks

Alan
 
Back
Top