Action queries

[Coy Howe]

In tools options you can shut off the Confirm Action Queries. I am
wondering is there a way to do this with access runtime. So when a
program is distrubuted the action query confirmation box does not
appear?
Thank you,

Coy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

Try:
Application.SetOption("Confirm Action Queries"), False

This is a different setting from SetWarnings, and you may not know about
engine-level errors that occur when you action queries run. It may be better
to Execute the query, e.g.:
dbEngine(0)(0).Execute strSQL, dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Coy Howe" <cf*@olypen.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

In tools options you can shut off the Confirm Action Queries. I am
wondering is there a way to do this with access runtime. So when a
program is distrubuted the action query confirmation box does not
appear?

[Brenda]

Thank you for responding, but I have no idea where to put
Application.SetOption("Confirm Action Queries"), False
Please give me any additional help you can offer.

Thank you,

Brenda
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Brenda]

Thank you for responding, but I have no idea where to put
Application.SetOption("Confirm Action Queries"), False
Please give me any additional help you can offer.

Thank you,

Brenda
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

Place it in the Open event procedure of your startup form, i.e. the form
defined under:
Tools | Startup

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brenda" <br****@mycollegeinfo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Thank you for responding, but I have no idea where to put
Application.SetOption("Confirm Action Queries"), False
Please give me any additional help you can offer.