Macro Setting

H

H

I am setting up a macro and in it the is a "make a table" query that
would require the user to click on "yes". Is there a way that popups
don't appear and yes is the default?
 
K

KARL DEWEY

Preceed it with SetWarnings to No, then the query, and follow with
SetWarnings to Yes.
 

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

Append Queries in a Macro 6
Shape Arrays VBA 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro - one at a time, please! 4
Access how do you set a yes/no data type as required? 0
Access Automatically Send a notification email once a record is added 0
Split form keeps opening up too large 3
macro to call other macros 1

Top