This is something I haven't run into before.
I started writing a Sub:
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("tblReports")
rst.MoveLast
rst.MoveFirst
rst.Close
I then tried to compile it but I got the message at the rst.MoveLast line: "Compile error: Method or data member not found"
I then checked the references and didn't find "Microsoft DAO 3.6 Object Library" in there so I tried to add it. I then got the message:
"Name conflicts with existing module, project, or object library"
I opened the object browser and found the DAO library was in there.
What gives? The DAO library is in the object browser but not in the references list and I get an error telling me that the DAO library isn't loaded because it can't find the MoveLast method.
Has anybody run into this? Thanks for the help.