Problem with Audit Log from Allen Brownes website

[Raj]

I am trying to get the Audit Log from Allen Browne's
website to work in my database but when I run the
Complier I get User-defined type not defined when it get
to "Dim db As DAO.RATM" I replaced "Database" with the
name of my database and I am lost on what to do. I am a
neophyte and trying my best to learn Access on my own so
please understand if I am missing something that is
elementary.
Thank you in advance

 

[Dirk Goldgar]

I am trying to get the Audit Log from Allen Browne's
website to work in my database but when I run the
Complier I get User-defined type not defined when it get
to "Dim db As DAO.RATM" I replaced "Database" with the
name of my database and I am lost on what to do. I am a
neophyte and trying my best to learn Access on my own so
please understand if I am missing something that is
elementary.
Thank you in advance

You certainly would not want to replace the type-name Database with the
name of your database in such a declaration. I haven't looked at the
code, but it almost certainly said, originally,

Dim db As DAO.Database

and it should stay that way. If you got an "undefined type" message on
that statement, you should click Tools -> References..., while in the VB
Editor, to open the References dialog. Then locate Microsoft DAO 3.6
Object Library in the list of references and put a check-mark next to
it.

 

[Raj]

Dirk,
Thank you!!

-----Original Message-----


You certainly would not want to replace the type-name Database with the
name of your database in such a declaration. I haven't looked at the
code, but it almost certainly said, originally,

Dim db As DAO.Database

and it should stay that way. If you got an "undefined type" message on
that statement, you should click Tools -> References..., while in the VB
Editor, to open the References dialog. Then locate Microsoft DAO 3.6
Object Library in the list of references and put a check- mark next to
it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.