Make-Table_Query; no notification after clicking a button

[TjS]

Question:
I have a make-table query which is runned when clicking on a button in a form.
Of course after clicking the button the following notifications appear:

1) You are about to run a make-table query that will modify the data in your table (yes, no help)
2) (if the table exists) The Existing Table <<tablename>> will be delted before you run the query (yes, no)
3) your are about to paste 1 row(s) into a new table (yes, no)

How can i make it possible that on forehand all three questions are "yes", so that the user does not see these questions, but the table is filled with the relevant information and can be used?

Thanks in advance for your answers/reactions/help

 

[MStef]

DoCmd.SetWarnings False
Docmd.OpenQuery...................
DoCmd.SetWarnings True

 

[Deleted member 30250]

But make sure your error trap also sets warnings back on, they'll stay off for everything until a set-warnings-true get executed.

 

[TjS]

Thanks! it works fine...