Auditing, highlight changes made between rows

[Not Me]

Hey,

In our database, we have implemented auditing simply by holding a copy
of each row of the specific table at any time that data is updated. This
gives us a long list of full records, often with only one change
between them.

Not sure if there's a better way to do this, but we'd like to somehow
highlight whichever record was changed by comparing each row with the
next (in date order).

For example

Audit ID Date Forenames Initials Surname
1 1 26/7/04 Timothy TW Smith
2 1 29/7/04 Timothy William TW Smith


In this case we'd like the Forenames field to be highlighted on the
second row, as this is the only field that has changed.

Has this been done before? Any ideas how to proceed?

Cheers,
Chris

[James Fortune]

Re: Auditing, highlight changes made between rows

Not Me <Noone.is.home@ here.com> wrote in message news:<ceb5vr$d7 $1@ucsnew1.ncl. ac.uk>...[color=blue]
> Hey,
>
> In our database, we have implemented auditing simply by holding a copy
> of each row of the specific table at any time that data is updated. This
> gives us a long list of full records, often with only one change
> between them.
>
> Not sure if there's a better way to do this, but we'd like to somehow
> highlight whichever record was changed by comparing each row with the
> next (in date order).
>
> For example
>
> Audit ID Date Forenames Initials Surname
> 1 1 26/7/04 Timothy TW Smith
> 2 1 29/7/04 Timothy William TW Smith
>
>
> In this case we'd like the Forenames field to be highlighted on the
> second row, as this is the only field that has changed.
>
> Has this been done before? Any ideas how to proceed?
>
> Cheers,
> Chris[/color]

This is just a shot in the dark but you could add an Integer or Text
field to your audit table to indicate which field changed. Run a
query or VBA code to stick the number/name in the new field whenever
no value exists, then use that number/name to determine which field to
highlight. I've never tried to highlight a particular field on a
subform in datasheet view so maybe others can help you there. If more
than one field can change from record to record then create a new
table with the record identifier and a new line for each field that
changed. Then use the OnCurrent event of your subform to look up all
the fields that changed.

James A. Fortune

Even now, type foundries have many typefaces just waiting for a big
customer to say "I'll have 10,000 licenses please" to justify the
man-years of TrueType engineering. --- Laurence Penney