Audit trail code from Allen Browne

[johannaellamay]

Hi! I'm trying to construct a database that can keep historical data on employee details like previous departments, job position, etc. Sort of like an audit trail, but I want users to also see the data in a report or something. I've researched about this and even made a prototype using macros. Now I've tried using Allen Brownes and I still couldn't figure why I have an error.

I got it from here: http://allenbrowne.com/appaudit.html

I copied the four functions according to instruction. But when I tried to Debug the code, Access highlights

Call LogError and tells me

Sob or Function not defined.

Why? Please help me. I'm this close to finishing my work.

 

[pr2-eugin]

So you copied codes from - http://allenbrowne.com/AppAuditCode.html and http://allenbrowne.com/ser-23a.html into a Standard module (not behind any form module)

 

[johannaellamay]

So you copied codes from - http://allenbrowne.com/AppAuditCode.html and http://allenbrowne.com/ser-23a.html into a Standard module (not behind any form module)

No, and yes.

No. I only copied here: http://allenbrowne.com/AppAuditCode.html
I have no idea about LogError() or how I can incorporate it in the code. Maybe I didn't declare it or something that's why I keep getting errors. But I don't know how to fix it. Sorry, I'm really new.

Yes, I made it in a standard/separate module, not behind any forms.

 

[gblack]

I used that log error function just recently...

Just click that link and copy that log error function (below) cut it and paste it under your main function, so it can be referenced, then you should be good to go.

HTH,
-Gary

 

[johannaellamay]

I used that log error function just recently...

Just click that link and copy that log error function (below) cut it and paste it under your main function, so it can be referenced, then you should be good to go.

HTH,
-Gary

Hi,

I understand what you're saying. It's just that, I can't find the code for the log error function. Where is "below"?

 

[pbaldy]

It's referred to in your link:

http://allenbrowne.com/ser-23a.html

 

[johannaellamay]

It's referred to in your link:

http://allenbrowne.com/ser-23a.html

Oooh yeah! I get it. Thank you so much! Will let you know how it works out.

 

[pbaldy]

Happy to help!