Run Make-table query

[Question Boy]

How can I run a make-table query from code and bypass any form of user
intervention including confirmation prompt(s). The query's name is
'qry_ExportData'.

Thank you,

QB

 

[pietlinden]

How can I run a make-table query from code and bypass any form of user
intervention including confirmation prompt(s).  The query's name is
'qry_ExportData'.

Thank you,

QB

either use
DbEngine(0)(0).Execute "qry_ExportData"

or turn warnings off, run your stuff, turn warnings on..
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_ExportData"
DoCmd.SetWarnings True

If you use SetWarnings, make sure you include error-trapping code to
turn the warnings back on, or they'll be off for the rest of the
application. Well, until you close/reopen or reset...