Make Table Query

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I have a macro that runs a make table query. Every time I
have to click yes to delete the existing table. Is there
any way to make it run without asking me this every time?

Thanks!!
 
In the macro, setwarnings to No. That should get rid of
the question.
Click to expand...

Just be sure to put a line Setwarnings yes after the query runs, or it
will turn off ALL warning messages for the rest of the Access session!
 
I have a macro that runs a make table query. Every time I
have to click yes to delete the existing table. Is there
any way to make it run without asking me this every time?

Thanks!!
Click to expand...

See Les' answer (and my addendum) for the direct answer to your
question; but...

MakeTable queries are VERY RARELY needed. If you're creating a table
just so you can generate a report, consider instead basing the report
on a Select query containing the same data. This avoids all the
overhead of creating a new table, cleaning up after the deleted table,
and so on.
 
Sara,

If a select query won't do what you need it to do...

Try using the make table query once to create your table...then change it to
an Append query...by default it will append the same table you just created

In your macro...
Run a delete query first, this will delete the data in your table
Then run the append query...

Chris
 
Back
Top