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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"KateB" <(E-Mail Removed)> wrote in message
news:0D9D00C6-A183-4057-A515-(E-Mail Removed)...
> 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

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

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "KateB" <(E-Mail Removed)> wrote in message
> news:0D9D00C6-A183-4057-A515-(E-Mail Removed)...
> > 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
>
>
>