Modules

[learning_codes]

Hi,

I'm getting an error message when I create a line of code on Module
TAB.

Dim dbs as DAO.Database

Set dbs = CurrentDB()

The error message that I get:
ERROR 3265: Item not found in this collection

**********************************************************

2nd Tried

I remove Dim dbs as DAO.Database

only line: Set dbs = CurrentDB()

I still get error message not like "Error 3265...."

I don't know if I miss something. I would appreciate if you provide
some help with me.

Thanks

 

[Danny J. Lesandrini]

Is it Access 2002 (XP)?

Are you sure there's a reference to Microsoft DAO Library?

 

[learning_codes]

Is it Access 2002  (XP)?

Are you sure there's a reference to Microsoft DAO Library?

--
Danny J. Lesandrini
(e-mail address removed)














- Show quoted text -

At first, I had Access 97 and use converter to Access XP. I guess
I have to create Access XP brand new database without converting from
Access 97 database. is that correct

 

[Danny J. Lesandrini]

I only asked about Access XP because when you create a new database, it adds
the ADO library by default but not the DAO library. Just add the DAO library
and see if that fixes things