Run Make-table query

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

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
 
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
Click to expand...

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...
 
Back
Top