S
Susan L
I have set up an audit table using Allen Browne's instructions/functions,
etc, which works perfectly. (I want to retain the structure of the record,
rather than recording changes by field, as is done in other examples of
audit/history tables.)
However, I need to send a report monthly to two other people who also
maintain contacts databases based on my data and want them to be able to
immediately identify the changes. Therefore, I would like for the functions
to only enter the changed values when a record has been edited. But I don't
know how to do this. My efforts with ctrlC.Value, after declaring ctrlC =
Control didn't work. (No surprise to me, since I'm new to Access and VB!)
Does anyone have suggestions/references to resources of how to write code to
do what I want? Appreciate your help.
etc, which works perfectly. (I want to retain the structure of the record,
rather than recording changes by field, as is done in other examples of
audit/history tables.)
However, I need to send a report monthly to two other people who also
maintain contacts databases based on my data and want them to be able to
immediately identify the changes. Therefore, I would like for the functions
to only enter the changed values when a record has been edited. But I don't
know how to do this. My efforts with ctrlC.Value, after declaring ctrlC =
Control didn't work. (No surprise to me, since I'm new to Access and VB!)
Does anyone have suggestions/references to resources of how to write code to
do what I want? Appreciate your help.