asked on

Confirm Action Queries

I would like to turn off the three checkboxes under "Tools--Options--Edit/Find Tab--Confirm" using a macro or visual basic code. These checkboxes turn off confirmation messages for Action Queries, Record Changes, and Document Deletions.

These settings are not saved with the database, instead they are computer specific. I would like to be able to turn them off when starting up an application so that each user does not have to go in and manually turn them off.

I am aware of the SetWarnings method, but it seems to turn off more than what I want it to (all modal messages).

ASKER CERTIFIED SOLUTION

paasky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

berg1375

If you set the warnings to false on start up, you can then set them back to true when you are done with the code and startup.

paasky

If you want to restore the original setting value (user may have turned warnings off), you should store the value in the table or global variable.

To get the value of this setting, here's an example:

OriginalSetting = Application.GetOption ("Confirm Action Queries")

Paasky

KMAN

These are registry settings.

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings

Confirm Action Queries
Confirm Document Deletions
Confirm Record Changes

These are DWORDs, Set to 0 for no confirmation.

paasky

and then assign the original value of setting when you quit:

Public OriginalSetting As Boolean

.....

Application.SetOption "Confirm Action Queries", OriginalSetting

Johannes030399

ASKER

Thanks. It's a little slower than I expected (hoped) it would be, but I guess there is no way around that.

KMAN

Keep in mind all other Access instances will also be affected by the changes made by your application. You might also consider doing these registry changes during an install, instead of each session.

paasky

You're welcome Johannes.

Regards,
Paasky