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

M

mscertified

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 ???
 
K

Ken Snell [MVP]

OpenQuery will run an action query -- that is what happens when you "open"
an action query from the database window, no?
 
G

George Nicholson

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
 
Top