Disable Make-Table Overwrite Prompt

G

Guest

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

Macro Several 'Make-Table' Queries without Warning Messages 2
Make Table Query 4
ACCESS MACRO TO PROMPT USER TO RENAME A TABLE? 1
Overwrite prompt 1
Unisng SendKeys For Make Table Query 1
Can existing table data be overwritten when importing from Excel? 1
Using query to make a table 3
Link or Import Data from Excel to Access 2

Top