Running Delete QRY with a Macro

[David McDermott]

As a new user I am having a bit of a problem. I have several tables that I have created delete query's for and a macro to run all of the queries in succession. When I run the macro it stops at every query and asks me if i really want to delete XXX number of rows in my table. I click on yes and the next delete query asks the same thing. is there a way to disable this "safety check" built into this process?

Thanks in advance for anyones help

 

[texasalynn]

add this to the start of your macro below the sub line

Application.DisplayAlerts = False

then at the end of your macro above the End Sub add
Application.DisplayAlerts = True

 

[David McDermott]

add this to the start of your macro below the sub line

Application.DisplayAlerts = False

then at the end of your macro above the End Sub add
Application.DisplayAlerts = True

Again as a new user of Access I did not ask the question correctly - so thank you for your quick response and I apologize for imprecise language.

I am recording a macro using the macro recorder built into the tools of Access and i am not writing lines of VBA so i can't add the TRUE and FALSE to my macro. Is there some other way to accomplish this?

 

[Joe4]

I think Lynn may have thought it was an Excel question, not an Access one. But Access has an action similar to the Excel VBA "Application.DisplayAlerts".

In your macro, before your Action queries, add a "SetWarnings" Action, and set the value to "No".
Then at the very end, add another "SetWarnings" Action and set this one to "Yes".

Note that is you do not see the "SetWarnings" option listed in your Action choices, click on the "Show All Actions" in the Show/Hide ribbon (this is one of those Actions that is hidden by default in newer versions of Access).

 

[David McDermott]

I think Lynn may have thought it was an Excel question, not an Access one. But Access has an action similar to the Excel VBA "Application.DisplayAlerts".

In your macro, before your Action queries, add a "SetWarnings" Action, and set the value to "No".
Then at the very end, add another "SetWarnings" Action and set this one to "Yes".

Note that is you do not see the "SetWarnings" option listed in your Action choices, click on the "Show All Actions" in the Show/Hide ribbon (this is one of those Actions that is hidden by default in newer versions of Access).

This works!! thanks for the help. I am certain I will be asking lots more.