Dim variable_name as DataBase?

[Matthew Snook]

Here is some suggested code straight out of a help file:

Dim dbs As Database, rst As RecordSet


In trying to solve another problem, I have attempted to define variables as a database several times now, and the option is not available. Am I missing something?

When I type "Dim as" and hit the spacebar, the autocomplete feature lists all the alternatives, and "database" is not one of them. If I ignore this small setback and simply copy the code from another source, an error acrues to my "undefined user data type." Is this feature only available at certain times?

Matt

 

[bjackson]

if you are using access 2000 or greater then
you have to make sure the references are correct

you need to make sure that D.A.O.3.6 is ticked
in the references

then you should
Dim Dbs as DAO.database
Dim Rst as DAO.recordset


to check the references in any code module
select tools, references, then find your selection
in the list and tick it.I also move dao3.6 up the
list as far as it will go