Make Table Query message

[ptrifile]

I have a simple Make Table Query and when I run it I get the standard "the existing table "tblname" will be deleted before you run the query do you want to continue anyway" message shows up, is there anyway to supress that warning message?

Any help is appreciated!

Thanks!

Paul

 

[gwog]

If you run the query via a macro and delte the existing table in the first step of the macro you would not get that error.

Of course to supress the confirm delete message you would have to setwarning to no I think.

 

[blindlemonray]

If you insert SendKey "Y" after the command line this will do the job for you or you could put in DoCmd.setWarnings = False before the line!