Compile error - Method or data member not found

T

Tcs

When I try to compile my db, I get an error:

"Method or data member not found"

on the following line, with "DAOdbs" highlighted.

intNmbrOfRecs =
DAOdbs().TableDefs("tblAcctsRecAging_Details_temp1").RecordCount

In my global module, I have:

Global CurrentDb As Database
Global DAOdbs As DAO.Database

and in this module, I have:

Set DAOdbs = CurrentDb

What Access highlighted used to be "Currentdb", but I'm trying to update all the
modules in my db by creating the necessary entries in the global module, remove
redundant entries, and generally improve my code. Guess I slipped up, but I
don't understand the error msg. Can anyone help?

Thanks in advance,

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top