• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1341
  • Last Modified:

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).  
0
Johannes030399
Asked:
Johannes030399
1 Solution
 
paaskyCommented:
Hello Johannes,

You could try these functions:

This function is called from the startup form or Autoexec macro

Public Function Initialize() as Boolean
   Application.SetOption "Confirm Action Queries", False    
.....
End Function


And this function to quit application:

Public Function Quit_Application()
   if msgbox ("Do you want to quit",vbYesNo,"Quit?") = vbNo then exit sub
   Application.SetOption "Confirm Action Queries", True    
.....
End Function

Hope this helps,
Paasky
0
 
berg1375Commented:
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.

0
 
paaskyCommented:
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
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
KMANCommented:
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.
0
 
paaskyCommented:
and then assign the original value of setting when you quit:

Public OriginalSetting As Boolean

.....

Application.SetOption "Confirm Action Queries", OriginalSetting  
0
 
Johannes030399Author Commented:
Thanks.  It's a little slower than I expected (hoped) it would be, but I guess there is no way around that.
0
 
KMANCommented:
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.
0
 
paaskyCommented:
You're welcome Johannes.

Regards,
Paasky
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now