Warning Messages

B

Bill

I want to create a "Make-table query" using the same table
name each time I run the query (because i have a report
linked to this table) but keep getting the message
"The existing table "XXXX" will be deleted before you run
the query. do you want to continue Yes No "
How can I stop this message appearing. I have deselected
the three options in Tools > Options > Edit/Find confirm
section but the message still appears.

Currently using Access '97
 
J

JL

Try to delete the table before running the make table
query or instead of using the make table query just do
append query.
 

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

turning off action query confirmation dialogs? 1
query to show where no data in a stated column 0
Make Table Query Popups 9
How to Silence messages on Make Table query? 3
Turn off warning message 4
WORD VBA Search and switch to advanced ... 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Getting Radio Buttons to work, that are inserted via AutoText 0

Top