Db-why-not
Registered User.
- Local time
- Today, 04:09
- Joined
- Sep 17, 2019
- Messages
- 159
Hello,
I created a Audit table to track all changes made to my database. I got the audit table to track my changes , but I am trying to track which users make the changes also. I used this website to set up my audit table followed the directions.
https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/
I'm just having difficulty getting the data macros to track who makes the changes. I followed the directions and added a module
Module is call fUser
Public Function fUser()
fUser = Forms!User_Login!cbo_user
End Function
I added it to my backend database and my front end where I have all my forms and querys. It doesn't work and it stops tracking my changes when I add it to the data macro. I have a User_Login form that tracks the users.
I created a Audit table to track all changes made to my database. I got the audit table to track my changes , but I am trying to track which users make the changes also. I used this website to set up my audit table followed the directions.
https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/
I'm just having difficulty getting the data macros to track who makes the changes. I followed the directions and added a module
Module is call fUser
Public Function fUser()
fUser = Forms!User_Login!cbo_user
End Function
I added it to my backend database and my front end where I have all my forms and querys. It doesn't work and it stops tracking my changes when I add it to the data macro. I have a User_Login form that tracks the users.