By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Automatically Select "Yes" to Update Query

P: 3
I have a macro which opens a form, and then runs a couple update queries I have. When the update queries run, it asks if you want to run it as it will update the table. Is there a way to get it to automatically do this without having to click Yes?
Dec 19 '07 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
I have a macro which opens a form, and then runs a couple update queries I have. When the update queries run, it asks if you want to run it as it will update the table. Is there a way to get it to automatically do this without having to click Yes?
If you are wishing to keep this at macro level then look at the macro action command SETWARNINGS where the argument for it should be set to false prior to running your query and then turned back on again after your queries are run by setting setwarnings to true

Jim :)
Dec 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.