-
VBA help to update t_User_Logs with current user log information

I am using: Access 2016, 32 bit, and Windows 10, 64 bit.
Please see attached database User Logging Master v 6.zip
A splash screen named f_About adds the current Computer machine name as well as the current Windows User Logged in to their respective tables: t_Computers and t_Windows_Users IF they are not already listed. These functions are named: WINUserUpdate and ComputerUpdate and are called on the forms Open event.
After Logon, f_Logon has the visibility property set to "False" normally after logging in. I am setting it to "visible" so you can see what information I have sitting in fields which are also set to invisible as well.
So, you can see after logon that I have the ingredients for t_User_Logs...
My goal is for t_User_Logs to be updated with the current Computers_ID, Windows_Users_ID, Users_ID, Log on Date/Time and Log/Off Date/Time.
I am not sure which event I would use after the Logon Form has gone invisible to record all of the t_User_Logs information, and how I would add the Computers_ID and Windows_Users_ID and not their names into the t_Users_Logs.
I am very new to VBA, but was able to get the Computer Name and Windows User name to be pouplated in their respective tables, however I do not know where or how to add their respective ID's to t_User_Logs.
Thank you for any help you might be able to provide... I would say what I have tried but I really do not have a clue where to start...
Bill
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules