How can I bypass pop-up window. 1

[worldatlas]

I have a event procedure that execute when I click the button to execute the following events:
DoCmd.OpenQuery "Step01", acViewDesign
DoCmd.OpenQuery "Step02", acViewNormal
DoCmd.OpenQuery "Step03", acViewNormal
DoCmd.OpenQuery "Step04", acViewNormal

But query step03 is a make table query, so when it is executed, it pop up a window that said, "An existing table will be deleted. Do you want to continue."
And I want to program where I can select yes and not have the pop-up window appears.

 

[PHV]

DoCmd.SetWarnings False
...
DoCmd.SetWarnings True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[worldatlas]

This setwarning = false helps bypass the pop-up window; however, I want to program to select "YES" without prompting the users with the pop-up.

 

[PHV]

Sorry, I don't understand what you want.

 

[rubbernilly]

setting the warnings flag to false means that the code will run (force the Make Table Query) and bypass the popup box.

In effect, it will have received a "yes" answer without ever showing to the user.

It should do exactly what you want, unless I misunderstand what you want.

 

[worldatlas]

Whoohoo...It works, thank you for all your help.

 

[patrichek]

PHV, you rock! thanks i used your "DoCmd.SetWarnings False"

since he didn't give you a star, i will.