VBA doesn't recognize DIM db as Database

  • Thread starter Thread starter Sheryl
  • Start date Start date
S

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?
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top