C
cw via AccessMonster.com
I'm using Allen Browne's Audit code in my database.
All changes made to my database are logged into the audCP table by CPID (this
is the record ID).
See Allen's link if needed: http://allenbrowne.com/AppAudit.html
(by the way, his code works perfectly.)
How do I query the Audit table & View or Print just the FIELDS that have
changed?
Here's a sample audit record:
----------------------------------------
audID ID audType audDate audUser Acct CustomerName VRZPr CWPair
CRV Type
1631 142 EditFrom 11/29/05 jalex 3725 BAD Port 398
svf0-9-48 480 2
1632 142 EditTo 11/29/05 jalex 3725 John Doe
398 svf0-10-48 480 4
----------------------------------------
I'm not sure what expression to use in my Query/Report to get the audited
records:
a) The original unchanged record (EditFrom)
b) The updated one (EditTo)
c) A way to Highlight the Field that was changed?
This audit table is very exhaustive & after awhile it gets hard to see
exactly what changed, so it would be great to have a query or report to show
the changed details more easily.
Thanks,
cw
All changes made to my database are logged into the audCP table by CPID (this
is the record ID).
See Allen's link if needed: http://allenbrowne.com/AppAudit.html
(by the way, his code works perfectly.)
How do I query the Audit table & View or Print just the FIELDS that have
changed?
Here's a sample audit record:
----------------------------------------
audID ID audType audDate audUser Acct CustomerName VRZPr CWPair
CRV Type
1631 142 EditFrom 11/29/05 jalex 3725 BAD Port 398
svf0-9-48 480 2
1632 142 EditTo 11/29/05 jalex 3725 John Doe
398 svf0-10-48 480 4
----------------------------------------
I'm not sure what expression to use in my Query/Report to get the audited
records:
a) The original unchanged record (EditFrom)
b) The updated one (EditTo)
c) A way to Highlight the Field that was changed?
This audit table is very exhaustive & after awhile it gets hard to see
exactly what changed, so it would be great to have a query or report to show
the changed details more easily.
Thanks,
cw