J G
asked on
Access Report that will show table changes
Could you show me how this could be accomplished. I will integrate it into my db.
I have a form that users will maintain table data on.
I want there to be a report that will list/print all table records that were recently modified or added. The idea would be for users to then take this report and use it to data enter or import into another database.
Ideally, the report would list the entire record (all fields) , but would be sorted by the fields that were changed, as well as highlight the fields in bold. Also it would sort new records that were added.
I.E. sample field names - PLU, description, Size, Price etc) (| = field delimiter)
Report would show:
PLU changes:
None
Description changes:
94013| Apples OG |1Ea| 4.25
Size changes:
None
Price Changes:
94225| Avocadoes |1ea| 4.25
New Items:
94444 |Grapes Perlb| 5.99
I have a form that users will maintain table data on.
I want there to be a report that will list/print all table records that were recently modified or added. The idea would be for users to then take this report and use it to data enter or import into another database.
Ideally, the report would list the entire record (all fields) , but would be sorted by the fields that were changed, as well as highlight the fields in bold. Also it would sort new records that were added.
I.E. sample field names - PLU, description, Size, Price etc) (| = field delimiter)
Report would show:
PLU changes:
None
Description changes:
94013| Apples OG |1Ea| 4.25
Size changes:
None
Price Changes:
94225| Avocadoes |1ea| 4.25
New Items:
94444 |Grapes Perlb| 5.99
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to add a bit, logging changes is a little more involved then just tracking changes in fields. You can read the following, which also has a complete solution for logging (and there are several out there like this):
http://allenbrowne.com/appaudit.html
But as you'll notice, Allen starts right off saying the new data macros are the best way to log, which is what Joe suggested.
Jim.
http://allenbrowne.com/appaudit.html
But as you'll notice, Allen starts right off saying the new data macros are the best way to log, which is what Joe suggested.
Jim.
@tike55, did you tried my suggestion?
ASKER
I did not because of the issues with the .OldValue property that Pat outlined.
thanks for your help though.
thanks for your help though.
Open in new window