Crosstab

[Vel.]

I recently researched how to make dynamic crosstab reports, and settled on a
solution by Duane Hookum. However, the solution was written in Access97
format, and I seem to be running across a small snag. When I try to compile
the database I get an error:

"Method or data member not found", and the line

..Edit

is flagged. I can give more information if necessary, but figured I'd keep
it minimal if there is a quick issue regarding to the change from Access97 to
Access2000.

 

[Duane Hookom]

You need to open any module window and select Tools->References. Find the MS
DAO object library and check it. Then compile your code to check for errors.
If you aren't familiar with compiling, check this article
http://www.access.hookom.net/Articles.htm.

I don't recall if I was explicit with my Dim's like
Dim rs as DAO.Recordset
Dim db as DAO.Database

 

[Vel.]

Thanks,

It was because the declaration didn't include the 'DAO' it was just general

Dim rs as Recordset
Dim db as Database

 

[Duane Hookom]

The original was created pre-ADO ;-)