Help! How do I get rid of the confirmation messages

[carriolan]

Hi
Hope someone can help me. I have a ms access program which I want to
distribute, but users of the program a plagued with confirmation
messages, so I have to talk them through manually switching the
confirmation messages off: Menu: Tools | Options | edit/Find | then
uncheck all the boxes in the confirm area: 'Record Changes',
'Document deletions' and 'Action queries'.

Is there anyway I can automatically switch these off in start up or
use VBA to turn them off?

Regards
Carriolan

 

[Dave Patrick]

To change application settings;

Application.SetOption "Confirm Record Changes", False
Application.SetOption "Confirm Document Deletions", False
Application.SetOption "Confirm Action Queries", False


Or you could do this below.

DoCmd.SetWarnings False
'do something
DoCmd.SetWarnings True

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

| Hi
| Hope someone can help me. I have a ms access program which I want to
| distribute, but users of the program a plagued with confirmation
| messages, so I have to talk them through manually switching the
| confirmation messages off: Menu: Tools | Options | edit/Find | then
| uncheck all the boxes in the confirm area: 'Record Changes',
| 'Document deletions' and 'Action queries'.
|
| Is there anyway I can automatically switch these off in start up or
| use VBA to turn them off?
|
| Regards
| Carriolan

 

[carriolan]

Hi Dave
Thanks works like a dream, though your alternative (DoCmd.SetWarnings
False) widely recommended on the web, I am unable to get working at
all.

Regards
Carriolan

 

[Dave Patrick]

You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

| Hi Dave
| Thanks works like a dream, though your alternative (DoCmd.SetWarnings
| False) widely recommended on the web, I am unable to get working at
| all.
|
| Regards
| Carriolan