Hello,
I was trying to create a chunk of code like follows:
sql = "SELECT * INTO AppendAllFields FROM [some table];"
Set qry = db.CreateQueryDef(qryName, sql)
DoCmd.OpenQuery (qryName)
where qryname is alr. defined.
When I wronf it, it kept giving me the error on the DoCmd line saying that runtime error 3001, invalid argument....
Anyone could help?
Thanks!
I was trying to create a chunk of code like follows:
sql = "SELECT * INTO AppendAllFields FROM [some table];"
Set qry = db.CreateQueryDef(qryName, sql)
DoCmd.OpenQuery (qryName)
where qryname is alr. defined.
When I wronf it, it kept giving me the error on the DoCmd line saying that runtime error 3001, invalid argument....
Anyone could help?
Thanks!
Last edited: