MS Access VBA - Run Executable Query Based Upon VBA Recordset
Posted on 2007-11-14
I have the following:
strSQL = "Select a ton of stuff"
Set rstTonOfStuff = db.OpenRecordset(strSQL)
db.Execute "Insert Into table (field, field...) Select " & rstTonOfStuff!Field & " , " & rstTonOfStuff!Field & " , " & rstTonOfStuff!Field & " & _
" From " & rstTonOfStuff & ""
I'm trying to use a VBA recordset as a basis for a secondary VBA query. Please disregard any syntax errors with the above; it's a representation of what I'd like to get working.
Is it possible to use a VBA recordset as the bases for a secondary VBA query?