I have managed implement GHudsons Audit Trail into my Db but im have a little difficulty trying to get it to work when main form is open with subfrmMovements . I have the Audit trail sitting in this subform.
Having said that I wouldnt have the faintest how to change the
the values below to reflect the correct name of the investigator ie
I need the value to be ie a Mr Young istead of the ID number.
hanges made on 27/09/2005 12:41:48 PM by Officer prrgmt;
In_Out: Changed From: In, To: Out
Status: Changed From: 6, To: 5
Investigator: Changed From: 1, To: 2 (need it to say From: Young, to :Harris)
PropertyOfficer: Changed From: 1, To: 2
If I can be shown how to change this, I can probably do the other ie Property Officer.
Any help would be very very very much appreciated. My main concern with this DB is know the exact movement of each ItemNo leaving and entering the evidence room.
I did however did make a slight alteration to the module which gets the System user name and inserts it in the Audit trail.
Having said that I wouldnt have the faintest how to change the
the values below to reflect the correct name of the investigator ie
I need the value to be ie a Mr Young istead of the ID number.
hanges made on 27/09/2005 12:41:48 PM by Officer prrgmt;
In_Out: Changed From: In, To: Out
Status: Changed From: 6, To: 5
Investigator: Changed From: 1, To: 2 (need it to say From: Young, to :Harris)
PropertyOfficer: Changed From: 1, To: 2
If I can be shown how to change this, I can probably do the other ie Property Officer.
Any help would be very very very much appreciated. My main concern with this DB is know the exact movement of each ItemNo leaving and entering the evidence room.
I did however did make a slight alteration to the module which gets the System user name and inserts it in the Audit trail.
