Disabling "Are you Sure"?

[Alex F. Buiel II]

I have a user who is running queries to update Access databases. She keeps
getting the popup box that asks: " Are you sure you want to delete these
records? ". She claims this is slowing her down considerably. Is there a
way to bypass, or disable this popup message?

Thanks,

 

[Steve Schapel]

Alex,

If she is using a macro to run the action queries, she can use a
SetWarnings/No action in the macro prior to the action(s) that run the
queries.

If she is using a VBA procedure to run the action queries, she can use...
DoCmd.SetWarning False
.... in the code prior to the methods that run the queries, and...
DoCmd.SetWarning True
.... in the code after the queries are run.
Alternatively, she can use the CurrentDb.Execute method in the place of
the DoCmd.OpenQuery or DoCmd.RunSQL methods in her code.

 

[George Nicholson]

From the Access interface: Tools>Options>Edit/Find: uncheck "Confirm Action
queries"

Keep in mind that it will stay unchecked on her machine until she changes it
again (unless there is code in the app that changes it.)

HTH,

 

[Steve Schapel]

George,

Pardon me for butting in. Whereas this is technically correct, I would
not recommend this approach, it is not a good idea in my opinion to
globally disable the action wquery confirmations.

 

[Alex F. Buiel II]

This is not something I encourage and I totally agree that it's a dangerous
option. But at this point I have to let them learn the hard way.

Thanks for the feedback.

AB


--
Alex F. Buiel II
(e-mail address removed)
| Agreed, and I believe I vaguely hinted as such, but you are right, I could
| have worded it more strongly.
|
| --
| George Nicholson
|
| Remove 'Junk' from return address.
|
|
| | > George,
| >
| > Pardon me for butting in. Whereas this is technically correct, I would
| > not recommend this approach, it is not a good idea in my opinion to
| > globally disable the action wquery confirmations.
| >
| > --
| > Steve Schapel, Microsoft Access MVP
| >
| >
| > George Nicholson wrote:
| >> From the Access interface: Tools>Options>Edit/Find: uncheck "Confirm
| >> Action queries"
| >>
| >> Keep in mind that it will stay unchecked on her machine until she
changes
| >> it again (unless there is code in the app that changes it.)
| >>
| >> HTH,
|
|

 

[George Nicholson]

Agreed, and I believe I vaguely hinted as such, but you are right, I could
have worded it more strongly.

 

[Steve Schapel]

Agreed, and I believe I vaguely hinted as such, but you are right, I could
have worded it more strongly.

Well, George, my point was really that you could have avoided mentioning
it at all

 

[Steve Schapel]

Alex,

I am not sure whether you missed the core point of the interchange
between George and me. It is not really dangerous to turn the warnings
on/off on a case by case basis, as I suggested in my original reply,
after it has been confirmed that the query is performing correctly. It
is the blanket switching off this feature across the board that I would
avoid.

 

[George Nicholson]

Ah, didn't realize we had all agreed to keep it a secret Steve.

Seriously, users who can't find this setting (or the Help entry) and figure
it out themselves are the ones most likely to get into to trouble. My bad.

wonderful is hindsight