Create Table Auto Answer

[James]

I have a query that updates an exisiting table.
When i run the query it prompts "You are about to run a make table query
that will modify data in your table" To which you have to answer Yes or No


It then prompts "The existing table will be deleted before you run the
query"
Yes, No

Is there anyway to have access automatically answer those questions when
running the query through a button on a form?

Thanks

 

[Allan Murphy]

James
Before you run the query put in this line

DoCmd.SetWarnings False

after the last line

DoCmd.SetWarnings True

Allan

 

[mray29]

If you run it in code, use DoCmd.SetWarnings (False) to turn off the
warnings. Be sure and turn them back on again after you're done. You can also
do this in a macro.