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

running a SQL Update without confirmation prompt from Access

P: 19
using Access 2007. I would like to call a sql update query with a macro, but I want it to update without prompting or otherwise notifying the user. Anyone got any ideas on this?
Jul 26 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,341
In VBA code you use
DoCmd.SetWarnings False
SQL Stuff Here
DoCmd.SetWarnings True

I assume there's a similar thing for macros.
Jul 26 '07 #2

P: 19
In VBA code you use
DoCmd.SetWarnings False
SQL Stuff Here
DoCmd.SetWarnings True

I assume there's a similar thing for macros.
huh, that's what the does....can't wait to try it!
Jul 26 '07 #3

P: 19
That did it.....I'm using it to solve a record lock issue by updating a field each time a record is opened. very clean, simple fix.

Thanks.
Jul 26 '07 #4

Rabbit
Expert Mod 10K+
P: 12,341
Not a problem. Good luck.
Jul 26 '07 #5

Post your reply

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