Hello all
I'm creating a recordset in access2000 and I'm having a problem starting it. The code I'm using is
Dim dbmydb As Database
Dim rsmyRS As Recordset
Set dbmydb = CurrentDb
Set rsmyRS = dbmydb.OpenRecordset("QRY Email select")
I tried to sort the problem by writing the code in access97 then converting to access2000 on open. This worked fine in both the original acc97 and the converted acc200 file. When I copied the code to the original acc2000 file it crashes on the first line (dim dbmydb as database). I can't even find "Database" in the dropdown list that appears.
(Suppose is what happens when you buy an access97 book and use it to program access2000).
Thanks inadvance.
MikiH
I'm creating a recordset in access2000 and I'm having a problem starting it. The code I'm using is
Dim dbmydb As Database
Dim rsmyRS As Recordset
Set dbmydb = CurrentDb
Set rsmyRS = dbmydb.OpenRecordset("QRY Email select")
I tried to sort the problem by writing the code in access97 then converting to access2000 on open. This worked fine in both the original acc97 and the converted acc200 file. When I copied the code to the original acc2000 file it crashes on the first line (dim dbmydb as database). I can't even find "Database" in the dropdown list that appears.
(Suppose is what happens when you buy an access97 book and use it to program access2000).
Thanks inadvance.
MikiH