Z
Z. Obert
I have a non-updatable query that I open from code like
the following:
Set Qdf = currentdb.QueryDefs("Query1")
Qdf ("[Enter Number1]") = Num1
Qdf ("[Enter Number2]") = Num2
Set Rst=qdf.openrecordset(dbopensnapshot)
This works fine in Access 97, but when I convert it to
Access 2002, I get an error message on the last line
stating "Runtime Error 3001: Invalid Arguement". I think
it may have to do with the query not being updatable, but
I can't change my table structure around to make the query
updatable.
Any Ideas?
the following:
Set Qdf = currentdb.QueryDefs("Query1")
Qdf ("[Enter Number1]") = Num1
Qdf ("[Enter Number2]") = Num2
Set Rst=qdf.openrecordset(dbopensnapshot)
This works fine in Access 97, but when I convert it to
Access 2002, I get an error message on the last line
stating "Runtime Error 3001: Invalid Arguement". I think
it may have to do with the query not being updatable, but
I can't change my table structure around to make the query
updatable.
Any Ideas?