Option Explicit
Public MDB as Database, RS as Recordset
When I type this in I get an error
type not defined....
What reference am I missing? I've used it
before but I don't even recall using a reference
Printable View
Option Explicit
Public MDB as Database, RS as Recordset
When I type this in I get an error
type not defined....
What reference am I missing? I've used it
before but I don't even recall using a reference
I had the same problem. It has something to do with using ADO controls but I cannot explain why the error occurs.
Someone told me to declare the recordset like this and it worked:
Dim DAO.RS as Recordset
OK..found it...
Need to reference DAO 3.51 under references.
Tried your solution
Public DAO.RS as Recordset
and it didn't work for me
Thanks,
Hello HeSaidJoe,
Please goto [Project] - [References]
Choose for [Microsoft DAO 2.5/3.5 compability]
Use next source:
Option Explicit
Private RS As Recordset
Private DB As Database
This works!
Nice regards,
Michelle.