Crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Thanks,

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

Dim rs as Recordset
Dim db as Database
 
Back
Top