Oblio
08-04-2017, 06:38 AM
:dunno
I am using: Access 2016, 32 bit, and Windows 10, 64 bit.
Please see attached database 19980
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
I am using: Access 2016, 32 bit, and Windows 10, 64 bit.
Please see attached database 19980
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