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

Access 97 - Turn of Access Warnings

P: n/a
PMB
Thank you in advance for any and all assistance.

I'm running Queries for updating my forms and I want to turn off the
Internal Warnings that access gives.

How do I do that?

Michael
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Not exactly clear what you are doing, but you could try one of these:

1. Turn SetWarnings off.

2. Change the settings under Tools | Options | Edit/Find | Confirm.

3. dbEngine(0)(0).Execute "MyQuery"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"PMB" <pm*****@megavision.com> wrote in message
news:KJ**************@news.uswest.net...
Thank you in advance for any and all assistance.

I'm running Queries for updating my forms and I want to turn off the
Internal Warnings that access gives.

How do I do that?

Michael

Nov 12 '05 #2

P: n/a
In code...
Docmd.setwarnings true or false

"PMB" <pm*****@megavision.com> wrote in message
news:KJ**************@news.uswest.net...
Thank you in advance for any and all assistance.

I'm running Queries for updating my forms and I want to turn off the
Internal Warnings that access gives.

How do I do that?

Michael

Nov 12 '05 #3

P: n/a
"PMB" <pm*****@megavision.com> wrote in message news:<KJ**************@news.uswest.net>...
Thank you in advance for any and all assistance.

I'm running Queries for updating my forms and I want to turn off the
Internal Warnings that access gives.

How do I do that?

Michael


DoCmd.SetWarnings False
DoCmd.OpenQuery "qupdWhatever"
DoCmd.SetWarnings True

On Error
DoCmd.SetWarnings True
Nov 12 '05 #4

P: n/a
"PMB" <pm*****@megavision.com> wrote:
I'm running Queries for updating my forms and I want to turn off the
Internal Warnings that access gives.


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 wierd 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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.