trail

Guys There are a couple of good examples in the internet on how to implement an audit trail database. But unfortunetaly are examples for bound forms/controls. I'm developing a database with unbound forms/controls. I cannot use the property OldValue on unbound controls so I cannot implement the...

Hello, pleas, how I could exclude changes of blank value? I no need log, when emty cell is changed. Thank you! Dim PreviousValues As Variant Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Store current values of all cells Application.EnableEvents = True...

Hello, im using this code for audit trail, but he is not archive old value. For example when I changed 5 to 10. In log I will have new value only. Could you help me please? Im total newb in VBA. Thank you! Private Sub Worksheet_Change(ByVal Target As Range) Dim Rw As Long Dim strAddress...

Hello, I am having an issue with my audit trail. It works perfectly, however I was told that only edited and deleted records will need to be kept in the audit trail. New records do not need to be in the audit trail. As I attempted to manipulate my code to exclude new records, I've noticed...

Dear Team, Do needful as iam having txt fine contains data in below mention format ================================================================================ TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01...