Macro runs a Make-table query - How to answer "Yes" every time 1

[kdowney]

I have a number of macros that run make-table queries and then display a report basedon those tables.

After the first step, which opens a query, Access prompts me that the existing table will be over-written, do I want to proceed.

How to I incorporate a step to answer "YES" to this question every time the macro is run?

Thanks for all help!

 

[Kozia]

Use DoCmd.SetWarnings False in your code. before you run an update query. Remember to set it on again at the end.