Audit trail writing everything!

[KateB]

Hi,

I downloaded a sample audit trail db from Roger Carlson's website which is
brilliant and does everything I want. Except! I only want it to record
changes to existing records, whereas at the moment it records entries to new
records too. It doesn't do it on the sample db, therefore I must have missed
something out. The only thing I didn't copy over was the On Delete event
procedure, as if a record is completely deleted it will show by the fact the
autonumber is missing - or is this also tied in to not recording every
field's original entry?

Sorry this is a bit vague - if I need to provide more info please let me
know. BTW, I only 'dabble' in Access so idiot-guide response would be
helpful!

Many thanks

 

[Douglas J. Steele]

I'm not familiar with Roger's application, but Allen Browne has one at
http://www.allenbrowne.com/AppAudit.html

Maybe between the explanation Allen gives and what Roger has, you'll be able
to figure out what you're missing.

Guessing, I'd think that in the form's BeforeUpdate event, you'd need to
check whether Me.NewRecord is true, and not execute the code if it is.

 

[KateB]

Thanks Doug, I really can't see any reason why it does it, and its also
horrendously slow, so I'm going to try Allen Browne's version instead and see
if that's better. Many thanks for the advice!

Kate