Disable Make-Table Overwrite Prompt

S

Sean H

I attached a macro a button that opens a make-table query, and then appends
that made table to an existing table. The table that is made gets
overwritten every time the user presses the button, which is fine, but I get
that pesky table-overwrite prompt, asking if I'd like to continue or not.
I'd like to make it so the user would never know these querys are taking
place, and the default answer is "Yes" continue every time. I tried using
"sendkeys {LEFT}" and "sendkeys {ENTER}" but it didn't work. Any
suggestions? Thanks!
 
S

Steve Schapel

Sean,

Insert a SetWarnings/No action in your macro, before the first OpenQuery
action.
 

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

Export a Table and rename the file 1
Macro Several 'Make-Table' Queries without Warning Messages 2
Make query macro with automatic YES 2
Daily Make Table Query 2
How to make clone for bookmark and add more form when clicked? 3
in Access 2007-TransferDatabase action will not work. 0
Using query to make a table 5
Infinite loop cancelling BeforeSave 10

Top