Toggling "confirm changes" for distribution

G

Guest

I'm distributing a program using Developer extensions which is packaging the
Access Runtime with it. I need to turn off the record changes and action
query confirmation pop-ups. How do I do that in the distributed versions?
 
G

Guest

Hi connorspops,

You code around it when you develop your application... instead of:

docmd.runsql strSQL, true

you would use:

docmd.setwarnings false
docmd.runsql strSQL, true
docmd.setwarnings true

Hope that helps.

Damian.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error at Runtime (Function not available in querie expressions) 6
Query Confirmations still opening 2
Confirm action query runtime option 1
The ABC's of Application Distribution 6
access runtime 5
Distribution issues - can't get rid of action query warnings 3
Why is it so hard to get an Adobe Distribution license (for .msi installers) 4
Access 2007 runtime - how to switch off confirm action queries 3

Top