WARNING MESSAGES ON UPDATE QUERIES

[John Gilchrist]

I'm working on a Access 2003 application which includes update queries.

Initially, I would get two warning messages each time the update query
executed ("you are about to update 3 records ....")

Now, these warning messages are no longer displayed. Why??

I tried using the Docmd.SetWarnings method to turn these warning messages on
and off, but this seemed to have no effect. (I had not used SetWarnings
until I noticed this problem).

Eventually, I would like to run without the warnings, but I want to see
these warning messages during the trouble-shooting phase.

What happened & how do I get them back??

Thanks,
John

 

[Sirocco]

Run a macro with the single command
Docmd.SetWarnings = True
Sometimes the warnings get turned off. This will turn them back on.

 

[Ken Snell]

From database window,
Tools | Options | Edit/Find tab.

Be sure that the Action Queries checkbox is checked at top right under
"Confirm" heading.