Any way to run (not open) an append query from VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an INSERT query and I need to run it from VBA. All I can find is
OpenQuery - which I don't want and RUNSQL which requires an SQL string. Is
there any way to just run my query without opening it ???
 
OpenQuery will run an action query -- that is what happens when you "open"
an action query from the database window, no?
 
Here are 2 approachs:

Set qdf = db.QueryDefs("qryMyQuery")
'qdf![Your exact parameter statement] = myParameters '(Optional)
qdf.Execute dbFailOnError
qdf.Close

or

Currentdb.Execute "qryMyQuery", dbFailOnError
 
Back
Top