VBA doesn't recognize DIM db as Database

[Sheryl]

My VBA in Access doesn't recognize such statements as 'Dim
db as Database' and 'myRecordSet.FindFirst'. How do I
setup to do this?

 

[RobFMS]

Sheryl

If you open a module (new or existing), select Tools->References. Make sure
that Microsoft DAO 3.6 Object Library is selected (or a relative close
version of DAO). It sounds as though you are using Access 2000 (or higher)
and you are trying to make reference to DAO.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-