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

action queries confirmation

P: n/a
I just installed MS Access 2007. Is there any way to turn off the
confirmation of action queries in 2007 ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200712/1

Dec 23 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sun, 23 Dec 2007 17:46:12 GMT, "destinman via AccessMonster.com"
<u18648@uwewrote:

Check out:
DoCmd.SetWarnings

-Tom.

>I just installed MS Access 2007. Is there any way to turn off the
confirmation of action queries in 2007 ?
Dec 23 '07 #2

P: n/a
On Dec 23, 7:02*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sun, 23 Dec 2007 17:46:12 GMT, "destinman via AccessMonster.com"

<u18648@uwewrote:

Check out:
DoCmd.SetWarnings

-Tom.
I just installed MS Access 2007. *Is there any way to turn off the
confirmation of action queries in 2007 ?- Hide quoted text -

- Show quoted text -
Offioce Button Access Options Advanced Untick "Confirm Action
Queries"
Dec 23 '07 #3

P: n/a
"destinman via AccessMonster.com" <u18648@uwewrote:
>I just installed MS Access 2007. Is there any way to turn off the
confirmation of action queries in 2007 ?
Inside macros or code?

If VBA code I prefer, if DAO, to use Currentdb.Execute strSQL,dbfailonerror command
instead of docmd.runsql. For ADO use CurrentProject.Connection.Execute strCommand,
lngRecordsAffected, adCmdText

If you're going to use docmd.setwarnings make very sure you put the True statement in
any error handling code as well. Otherwise weird things may happen later on
especially while you are working on the app. For example you will no longer get the
"Do you wish to save your changes" message if you close an object. This may mean
that unwanted changes, deletions or additions will be saved to your MDB.

Also performance can be significantly different between the two methods. One posting
stated currentdb.execute took two seconds while docmd.runsql took eight seconds. As
always YMMV.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Dec 24 '07 #4

P: n/a
For more info on Tony's suggestion, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:ts********************************@4ax.com...
"destinman via AccessMonster.com" <u18648@uwewrote:
>>I just installed MS Access 2007. Is there any way to turn off the
confirmation of action queries in 2007 ?

Inside macros or code?

If VBA code I prefer, if DAO, to use Currentdb.Execute
strSQL,dbfailonerror command
instead of docmd.runsql. For ADO use CurrentProject.Connection.Execute
strCommand,
lngRecordsAffected, adCmdText

If you're going to use docmd.setwarnings make very sure you put the True
statement in
any error handling code as well. Otherwise weird things may happen later
on
especially while you are working on the app. For example you will no
longer get the
"Do you wish to save your changes" message if you close an object. This
may mean
that unwanted changes, deletions or additions will be saved to your MDB.

Also performance can be significantly different between the two methods.
One posting
stated currentdb.execute took two seconds while docmd.runsql took eight
seconds. As
always YMMV.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Dec 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.