Make table queries - NO pop-ups

[abrown]

Simple Question-

I have a macro that runs a make table query and 2 append queries. How do you elimnate the pop-ups that "confirm if you want to create and/or add a table" ? I ultimately want the macro to run on its own.

Thanks

 

[dk]

For macros choose SetWarnings from the Action dropdown and set it to No. Make sure you set it back at the end.

To do the same thing within a VBA procedure use:-

DoCmd.SetWarnings False and DoCmd.SetWarnings True afterwards to set it back.

HTH

 

[abrown]

Thanks- this is just what I was looking for!