Access: Confirm Record Changes and Action queries keeps resetting

#1 (**permalink**) 28-Jul-2006, 08:32 AM

For some reason the "Confirm" for "Record changes" and "Action queries"
options keep resetting. I indeed want the confirmation, yet intermittently I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12876-access-confirm-record-changes-action-queries.html
go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12876
again. Anybody know why this keeps happening, or do you know how to prevent
it from resetting?

*

#2 (**permalink**) 28-Jul-2006, 08:33 AM

Pawaso ha scritto:

> For some reason the "Confirm" for "Record changes" and "Action queries"
> options keep resetting. I indeed want the confirmation, yet intermittently I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12876
> go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
> again. Anybody know why this keeps happening, or do you know how to prevent
> it from resetting?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12876

Are you using RunSQL method...?

Docmd.SetWarning False
Docmd.RunSQL "YOUR ACTION QUERIES..."
Docmd.SetWarning True

If you use the Execute Method member of Database Object you don't need
anything else:

CurrentDb.Execute "YOUR ACTION QUERIES..."

To uncheck definitivly the "Confirmation" box on Application Database
is not a good
idea..., much better disable only on request....

@Alex