Stop Pop Up's 1

[dk99]

Is there anyway I can automatically change the confirmaytion popup settings in access to stop them appearing all the time.

I know how to do this manually but I would have to do this to each machine that uses the database and I was wondering if there is an alternative method?

 

[rjoubert]

If you are referring to the confirmation pop ups when running action queries, you'll need to create a macro to run these queries...before you actually run the query, add a step in the macro to set the SetWarnings property to No. After the query step or steps are added, as a last step, set the SetWarnings property back to Yes.

If you are running these queries through code, you can add a line of code before you run the query to do the same thing...

DoCmd.SetWarnings False

Then, after the query is executed, turn the warnings back on...

DoCmd.SetWarnings True

 

[dk99]

So simple and yet I could not figure it out. Works a treat now. Thanks.

 

[IrishJim]

Another similar thing I do is capture some of the user's settings when I open my program, set them the way I want, then set them back when the program closes gracefully. I define a few global variables:

Global Save_Confirm_RecordChanges As Boolean
Global Save_Confirm_DocumentDeletions As Boolean
Global Save_Confirm_ActionQueries As Boolean

Then I save the user's current settings, and set them my way:

Save_Confirm_RecordChanges = Application.GetOption("Confirm Record Changes")
Save_Confirm_DocumentDeletions = Application.GetOption("Confirm Document Deletions")
Save_Confirm_ActionQueries = Application.GetOption("Confirm Action Queries")
Application.SetOption "Confirm Record Changes", False
Application.SetOption "Confirm Document Deletions", False
Application.SetOption "Confirm Action Queries", False

Then at the end of the program, I set them all back the way they were:

Application.SetOption "Confirm Record Changes", Save_Confirm_RecordChanges
Application.SetOption "Confirm Document Deletions", Save_Confirm_DocumentDeletions
Application.SetOption "Confirm Action Queries", Save_Confirm_ActionQueries

I do a similar thing in my Excel VBA modules, because I've found people even more touchy about their Excel settings.
IrishJim