Using VBA, how can I make sure that within the options, client settings, in the confirm group, both record changes and action queries are un-checked? Thank you in advance!!
Access Options, Client settings
Competent Performer
Windows 7 64bit 
Access 2010 32bit
Using VBA, how can I make sure that within the options, client settings, in the confirm group, both record changes and action queries are un-checked? Thank you in advance!!
Who is John Galt?
Windows XP Access 2007
I don't know if it's still valid, but it used to be the GetOption and SetOption methods. Personally I don't like to mess with user settings. If you're running action queries:
http://www.baldyweb.com/SQLWarnings.htm
Competent Performer
Windows 7 64bit Access 2010 32bit
Looks like I'll stop using docmd.runsql and use currentdb.execute. I made those changes, and everything works great. Thanks!!
Who is John Galt?
Windows XP Access 2007
Access 2003 Report - Printer Settings
Posting Permissions
Reply With Quote