Audit Trail and Find and Replace issue
- Thread starter ChrisB37
- Start date
I see that it is recording the new entry into the form, but if you were to change the data in the cell, there is no note of it in the table.
I think I have a problem in the code that records the changes.
Somewhere below this point in the code.
'Set date and current user if the form (current record) has been modified.
MyForm!AuditTrail = MyForm!tbAuditTrail 7 vbCrLf &vbLf & "Changes made on " & Now &"by" & sUser& ";"
I think I have a problem in the code that records the changes.
Somewhere below this point in the code.
'Set date and current user if the form (current record) has been modified.
MyForm!AuditTrail = MyForm!tbAuditTrail 7 vbCrLf &vbLf & "Changes made on " & Now &"by" & sUser& ";"
RuralGuy
AWF VIP
- Local time
- Today, 08:52
- Joined
- Jul 2, 2005
- Messages
- 13,825
The field is not actually changed until you move off of the record unless you specifically save the record. Try making a change and moving to the next record and then back to the first record. I believe you will see the the edit was in fact recorded in the table.
Some how I am still not getting it.
Do you see the changes listed in the Audit Trail column of the table. I cannot. Aren't they supposed to be listed there as well from the AuditTrail Module?
I modified the database from 125 to 135 in the data column, this I see in the table. I am looking for the description in the audit trail column stating I changed the value in the Las rep 1 field from 125 to 135 on 7/19/2006.
Isn't this what the audit trail is supposed to do?
Do you see the changes listed in the Audit Trail column of the table. I cannot. Aren't they supposed to be listed there as well from the AuditTrail Module?
I modified the database from 125 to 135 in the data column, this I see in the table. I am looking for the description in the audit trail column stating I changed the value in the Las rep 1 field from 125 to 135 on 7/19/2006.
Isn't this what the audit trail is supposed to do?
I am so sorry.
Yes, now I see. I was confused with the table issue. I thought the changes were being recorded and could be viewed horizontally by making the column wider. Now I see the changes are actually there, but I need to make the row taller to see them. What a dork.
Thank you so much RuralGuy for helping me sort out this issue and being so patient with my stupidity.
I appreciate everything greatly.
Thanks again.
Yes, now I see. I was confused with the table issue. I thought the changes were being recorded and could be viewed horizontally by making the column wider. Now I see the changes are actually there, but I need to make the row taller to see them. What a dork.
Thank you so much RuralGuy for helping me sort out this issue and being so patient with my stupidity.
I appreciate everything greatly.
Thanks again.
Similar threads
