DAO.recordset and reference (1 Viewer)

J

joe_walker

Guest

• Apr 18, 2004

• #1

I'm having problems with edit method and referencing to DAO. I work in Access 2002, and have turned on MS DAO 3.6 Object library. I can find it in object browser, but it doesnt show up in form.

Thanks

 

T

Tim K.

Registered User.

Local time

Today, 03:00

Joined

Aug 1, 2002

Messages

242

• Apr 18, 2004

• #2

It seems to me that you also have set ADO in the References. If this this the case, you have to add DAO as a prefix to all DAO objects. Something like this.

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
...

 

J

joe_walker

Guest

• Apr 18, 2004

• #3

yes, how dumb of me.

Thanks a lot!