By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,665 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,665 IT Pros & Developers. It's quick & easy.

Auditing, highlight changes made between rows

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Not Me <No***********@here.com> wrote in message news:<ce*********@ucsnew1.ncl.ac.uk>...
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


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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.