Action Query Confirmation Bug

[jabrony76]

Hi all -

I have a multi-user database that keeps a temporary table of the current users that have logged in. The way I accomplished this is through a log-in form and an action query that runs off a hidden form on close event to delete that log-on information.

Problem is, on my computer I can un-check "Confirm Action Queries" so this is a seamless process but all the users are getting confirmation of this action query.

Short of going to everyones computer and un-checking this option, is there any way to run this query without confirmation?

Thanks!!
Andy

 

[RobCPA]

You can add the following line of code:

docmd.setwarnings false


Or, if you're more familiar with macros, the command is SetWarnings. You may want to set the warnings back on after the queries have completed.