Only Track Changes - Track Changes in Microsoft Access


	Back to Track Changes Comments List

Upload Images @Reply Bookmark Link Email

Only Track Changes

Dan Jackson

3 years ago

In this video, you show how to "copy" the information to the separate table prior to update. I've added an update vba as well to show what is was changed to. Great.

I'm planning on designing a simple continuous form to show these changes. My concern is, at the moment, data for ALL fields are collected at EVERY update.

To improve efficiency and reduce garbage data, how can we set it to only copy fields that have been changed
(For example, using
IIF [Table1]![Field1]=[LogTable]![Field1], "", <Field2>, <Field3> and so on

I hope my ragtag attempt at an IFF statement shows what i'm trying to do! Cheers

	Richard Rost @Reply 3 years ago
The EASIEST way to do it would just be to track the change in the AfterUpdate event for each field, and then save that data to a master log table: `Table, Field, From, To CustomerT, FirstName, Richard, Rick` If you want that much insight into what specifically was changed. It's more work to set up, but will give you the results you want.

	Dan Jackson OP @Reply 3 years ago
Sounds perfect. I think the cost of more build work vs long term benefits is worthwhile. Not only will it make tracking the particular event in an "Incident" easier, it should also reduce the amount of date output too. Can we see an extended cut of this on the horizon at all? :)

	Scott Axton @Reply 3 years ago
Did you miss the one under the Members section above? Or are you talking an extended - extended cut? LOL

	Dan Jackson OP @Reply 3 years ago
That's the one! The SUPER Extended Cut!!!

	Richard Rost @Reply 3 years ago
It would work pretty much the same way. Just change the table structure and the SQL statement a little bit. No need for another super hyper massive extended cut.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Track Changes.