Highlighting Updated Records

[hobbit2612 via AccessMonster.com]

Hi I wonder whether someone may be able to help me please with a problem I
have with a db I'm working on.

I have a subform with approx 15 fields on it where on any given day can have
their data amended, added or deleted.

What I would like to do is to capture which records have been amended in a
report within a given month. I know how to show which records have been
updated by adding another field to the table which has a date stamp but my
problem is as follows:

I would like to actually show the individual fields which have been updated,
rather than the whole record. Now I have an idea in that I may have to create
a 'FieldUpdated' field for each peice of data that can be changed, can
someone tell me please is this best way to do it?

The second issue I have is around how I extract the monthly data. Normally
when I write a query that requires date specific information I would use
something like 'Between [Enter Date] and [Enter Date2]' as a parameter to
capture the records, but if there are multiple records, I wouldn't mind being
able to find another of doing this. Not only will it take some time to type
the date parameter for the fields, I suspect from the tests I've done that if
any field is blank i.e. has not been updated, the whole query would return
blank.

Can someone tell me please is there a way to have the records amalgamated so
that I only have to type in the date parameter once and where it will show
the records even if some fields are blank.

Many thanks

Chris

 

[John Spencer]

Not simple to do what you want. Take a look at

Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

That may be more than you want, but you should be able to simplify it to just
record the changes and the change date and not worry about identifying the
user that changed the data.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[hobbit2612 via AccessMonster.com]

Hi John,

Many thanks for replying so quickly, I'll take a look at the link.

Kind regards

Chris

Not simple to do what you want. Take a look at

Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

That may be more than you want, but you should be able to simplify it to just
record the changes and the change date and not worry about identifying the
user that changed the data.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Hi I wonder whether someone may be able to help me please with a problem I
have with a db I'm working on.

[quoted text clipped - 28 lines]

Chris