Make Table Query

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
 
D

Dale Fye

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
 
A

Alan W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
Make Table Query Popups 9
Make-table query with around 2 ml records taking too long 0
Using query to make a table 3
Daily Make Table Query 1
Make-Table query simple question 1
How to Silence messages on Make Table query? 3
Make Table query 2

Top