When I do Dim variable as Databse, the Databse is not an option for defining a variable. What do I have to add to be able to use Database to define a variable??
Printable View
When I do Dim variable as Databse, the Databse is not an option for defining a variable. What do I have to add to be able to use Database to define a variable??
Project -> References -> check Microsoft DAO 3.51 Object Library
You need to set a reference to the Microsoft DAO 3.51 or 3.6 Object Library.
Set rsTest = gblDatabase.OpenRecordset("Students", dbOpenDynaset)
I get type mismatch error??