Turn off warning message

[Rob S. 17407]

I am running update queries. Each time I run a querie, Access informs me
that the querie will modify the table and asks if this is OK. After running
the query, it then tells me that I will be modifying XX records and asks if
that's OK.

Since I am hoping to run a long query that would require me to respond to
hundreds of such prompts, is there some way that I can turn off these
prompts/warning messages so that I can leave my desk while the macro
continues to run?

Thanks.

 

[Gigamite]

is there some way that I can turn off these
prompts/warning messages so that I can leave my desk while the macro
continues to run?

From the menu, Tools | Options | Edit/Find. Uncheck "Record Changes"
and "Action Queries" in the "Confirm" section of the window. Click on
the "OK" button to save your changes.

 

[Dale_Fye via AccessMonster.com]

How are you running the query? If in code, use the Execute method.

Currentdb.querydefs("yourQueryName").Execute dbFailonerror

Or, you could just turn warnings off (as indicated in the other post). The
problem with this is that if you forget to turn warnings back on, you won't
get any warnings. This would not be a good thing!

Like the warning you get when you are about to delete 250 records, that you
really didn't want to delete!

HTH
Dale

 

[Ron2006]

If you are running the queries via vba code (docmd.openquery or the
equivilant.) then before the first query add the following:

docmd.setwarnings false

Then add another line after all the queries have been run that sets it
back on.

docmd.setwarnings true

Ron

 

[Keith Wilby]

If you are running the queries via vba code (docmd.openquery or the
equivilant.) then before the first query add the following:

docmd.setwarnings false

Then add another line after all the queries have been run that sets it
back on.

docmd.setwarnings true

As has been noted elsewhere, this can be problematic if an error occurs and
an error handling routine is invoked. The error handler must also handle
"setwarnings".

Keith.
www.keithwilby.co.uk