audit Log

[anandram]

Could someone advise how they got this working again? Perhaps the Thread creater can help? I have done everything as suggested, however no data being logged

I created the temp audit table, true audit table, the module etc, but nothing is being logged re changes..



I presume i am also to change the lines in the module to that of my tables also? I am unsure what to change lngKeyValue to??

[RuralGuy]

Are you attempting to use Allen Browne's method? http://allenbrowne.com/AppAudit.html

[anandram]

Hi, yes i am.

I done everything as mentioned. However nothing is being logged?

I presume i should also be chaning the module code although not mentioned in the tutorial?

I have :

Main table
Main table form

Temp audit table

true audit table

module

When i go to edit the form, nothing in the true audit table appears?

Just to note, for BOTH temp and true audit tables i copied table structure only as opposed to structure and data. Should i have copied data also for the true audit table only?

[RuralGuy]

You completed all 8 steps listed at the end of the reference under [Enter the Form Events]?

[anandram]

yep, the beforeevent,afterupdate etc? Yes done those and replaced with my table names, all names spelt right etc. Access options set also. Do you know if i am supposed to be editing the module to include my table names or should it be left as it is?

[RuralGuy]

In those first steps 2-5, the particular table/field information is passed to the functions in arguments. Do you want to post your db so we can look at it? Remove any sensitive data of course.

[anandram]

I attached an example i was trying out...hope this helps.

[RuralGuy]

I added back error reporting to the module. See what you think.

[RuralGuy]

Are you zeroing in on your issues yet?

[anandram]

Hi RuralGuy,

Sorry havent had a chance to look at this yet, as soon as i do i will post back with an update. Thanks for your help once again.

[RuralGuy]

No problem. We all have more than one thing to do.

[anandram]

Hey again,

So i tried changing a value on the form (test name), went to exit and i got:

Error no: 3075
Description: Syntax error(missing operator) in query expression '(Test main.ID=1)'

I hit ok and it appears again (the error), i hit ok and it disappears?

Any ideas?

BTW- i am still unsure whether i was supposed to edit the module? I replaced the table names it had in the module with my own table names, although the tutorial doesn't say to do so...?

[RuralGuy]

You need to make *all* of your names unique. You have tables named the same as forms and controls named the same as fields. Access can not determine what object you want to reference. You should also not embed spaces in names as they can be problematic. I use CamelFontNames myself.