Adding Date & Current User fields to track changes

[educate889]

I have a client that needs to track all changes/modifications to records in their database. He wants to have record of the date and user who modified the record, but I want to keep it hidden from end user. Please help, I am stuck!

I use a FE / BE and utilize MS security.

Does anyone have any ideas of a way to do this.


Thanks in advance for your postings.

 

[MichaelRed]

faq700-184

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[educate889]

Thanks MR but I think the code is a bit over my head. . .

Could you tell me what parts I need and how to attach it to a form . . . all I want to do is fill two fields, "USER", "UPD_DATE"

Thanks for your time . . .

 

[MichaelRed]

Adding the fields to an existing will not "track" the changes, merely record the last change. You need to capture the full details of the change, like the proverbial reporter, Who, What, When, Why, and Where (although "Why" is difficult and thus omitted).

You place the code in an external module, and call it from the BeforeUpdate event with the form as the calling argument. Of course you also need the table(s) to hold the results. The fields for the Table(s) are shown in the faq.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places