Toggling "confirm changes" for distribution

[connorspops]

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?

 

[Damian S]

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.