Answering Yes/No to dialog boxes 3

[izzyq]

When running macros that cause dialog boxes to come that require you to answer yes or no to move on, is there a way to get a piece of code in there that will automatically answer yes?

In my case, I'm running an openquery macro on a "make table" query. It will (1) tell me that I will be modifying data and if would like to continue. (2)It will then tell me that the current table will be deleted. (3)It then tells that it will paste "x" number of rows to the new table. I would like, if possible, to answer "yes" to all of these questions.

Help Me Obi Wan Kenobi, You're My Only Hope.

 

[THoey]

Did you try a SetWarnings OFF before your steps? Just make sure you set it back to ON when you are done... Terry

 

[thevillageinn]

I use this for the same effect that Terry mentions...

DoCmd.SetWarnings False

and to turn them back on after you have run your queries exported the file or whatever you are doing...

 DoCmd.SetWarnings True

-Dan

 

[izzyq]

Thanks Terry and Dan, both of these worked wonderfully Help Me Obi Wan Kenobi, You're My Only Hope.

 

[smartyme]

Another meethod is to goto Tools>Option. From the Option s dialog box, select the Edit/Find tab, select which confirm check box that says "Actions Queries"

Hope this help in the feture.