Confirm Action Query

[Nick]

When I start up my database I would like to stop the
Confirmation of action queries. I know how to do this
using options but others users use the database in
runtime. I use an autoexec macro to run some action
queries on start-up but I don't know how to deactivate the
query confirmation.

Any help is appreciated.
Nick

 

[Ken Snell [MVP]]

Insert the SetWarnings macro action (Argument value is No) into your
AutoExec macro as a step prior to running the first action query. That will
suppress the warning message boxes.

 

[Nick]

Thanks very much Ken, worked a treat.

Nick

-----Original Message-----
Insert the SetWarnings macro action (Argument value is No) into your
AutoExec macro as a step prior to running the first action query. That will
suppress the warning message boxes.
--

Ken Snell
<MS ACCESS MVP>




.