[AccessD] Audit trail of Deleted record

Thanks David - this looks like it will work!

This list rocks!
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Beckles
Sent: Tuesday, May 02, 2006 1:09 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Audit trail of Deleted record

Hi, Kevin,
Take a look at these pages from Allen Browne:
http://www.everythingaccess.com/tutorials.asp?ID=Creating-an-Audit-Trail

and
 
http://allenbrowne.com/AppAudit.html

I think that you will find that they cover your problem fairly
thoroughly.

Hope that this helps,
David


------------Original Message----------------------
> Date: Mon, 1 May 2006 12:26:45 -0500
> From: "Kevin Bachmeier" <kevinb at bepc.com>
> Subject: [AccessD] Audit trail of Deleted record.
> To: <accessd at databaseadvisors.com>
> Message-ID: <5C210A2F04B76B4AB2A18E6FEB81713404D727C7 at HDQ06.bepc.net>
> Content-Type: text/plain;	charset="us-ascii"
>
> I am trying to find a means of auditing the deletion of records from a

> table (write a record in another table with the appropriate details of

> who, when, and key fields of the record being deleted).
>
> My attempt at using the BeforeDelConfirm event fails as the values of 
> the form's fields of this bound form are already null (deleted).
>
> I was able to find some discussion of auditing changes to records in 
> the archive, but am not able to find anything on deleted records.
>
> Anyone with some experience or suggestions on obtaining the values of 
> a record once the user has selected the record and pressed Del, or 
> selected Record Delete?
>
> Thank you in advance.
> Kevin
>   

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com