Make-Table query simple question

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello all

I have created a make-table query that works just fine. My problem is I
do not want to see the pop-up message asking:
"The existing table 'name of table' will be deleted before you run the
query.
Do you want to continue? Yes No"

I did read the "Show Help" and it said to go to Tools>Options>Edit/Find
tab, under Confirm, clear the Action queries check box. I did clear the
check box and the message will not go away. How do I get rid of this
pop up message? I want the query to run every time.

Any ideas...???
 
You can create a form with a button that turns off warnings, runs the query,
and then turns warnings back on:

DoCmd.SetWarnings False
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True

Or you can simply attach this to the form's OnOpen event and add a DoCmd.
Close. That way you open the form rather than the query and it behaves as
you want.
 
Back
Top