I can't suppress the create table query message box. help!

[Guest]

I changed the tool, options, action queries box to unchecked, and yet when I
do a create table query as part of code, I get the message asking if it's
okay to delete the original table. I have to select yes every time.

 

[Al Camp]

TPL,
Application.Echo False
'Your Code
Application.Echo True

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.

 

[John Vinson]

I changed the tool, options, action queries box to unchecked, and yet when I
do a create table query as part of code, I get the message asking if it's
okay to delete the original table. I have to select yes every time.

Put a call to DoCmd.SetWarnings False prior to running the delete
query; be sure to DoCmd.SetWarnings True after it, or you'll turn off
all warning messages for the rest of the Access session!

John W. Vinson[MVP]

 

[Guest]

Thank you SO much. That worked great!

Put a call to DoCmd.SetWarnings False prior to running the delete
query; be sure to DoCmd.SetWarnings True after it, or you'll turn off
all warning messages for the rest of the Access session!

John W. Vinson[MVP]