Recent content by ade7985

hello, Is there a way to audit one field in a table? For example, one table has 4 fields and i only want to track one field instead 4 field. Your help is appreciated. Thank you.

Hi, I tried your audit sample and i get error on 'Call AuditTrail (Me.Form, [Record]). I can't figure out where is causing error

Sir, I tried your sample audit trail and it work perfect but only problem i have is when my form are on top of tab control it does not work. I have five form and i use tab control to use page by page. what are setting for tab control able to do audit. Thanks

Hello ghudson, AuditTrail work perfectly on single form. How do you configure using tab control part? I have it place my form on top of tab control on forms. it won't not update audit when i tested on tab control. Thank you,

Thank you, Yup, I just wake this forum alive again.. but thank you again, I didnt expect reply so soon. this is good stuff audit trail and this is my first access db working on. I might have some more questions. Thank you V/R, Alejo

----------------------------------- hello Lyn I followed your code after make some changes i get an error: 'Dim MyForm As Form Dim ctl As Control Dim sUser As String 'Set MyForm = Screen.ActiveForm ' sUser = "User: " & UsersID 'You need to identify your users if you are...