Dim dbs As Database

[andzejek]

I want to create recordset from local table with code:

Dim dbs As Database, rstCustomers As Recordset

Set dbs = CurrentDb
Set rstCustomers = dbs.OpenRecordset("Customers")

but as I type "dim dbs as...", in popup menu there is no "Database" option to chose from! If I will type it and try to run, error message is popping up: Compile error: User-defined type not defined.

Thank you for any help.

 

[Remou]

You need a reference to the Microsoft DAO 3.x Object Library. You will need to change that recordset to:

Dim rstCustomers As DAO.Recordset

 

[andzejek]

This same error message!

 

[Remou]

Have you checked your references?

 

[andzejek]

well, I'm not sure how....

 

[PHV]

When in VBE menu Tools -> References ..

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[andzejek]

There we go....