Creating a Function in Microsoft Access
To find a way to implement a Microsoft Access get network user full name update, you will have to create a function that will capture the variable. The function can then be called whenever you need to check the network user ID of the current Microsoft Access user. this Microsoft Acccess tutorial assumes a basic knowledge of Microsoft Access.
In a sample Microsoft Access database, create a table, tblOne, with text fields of "Network ID" and "TextField1." Use the Microsoft Access Form Wizard to quickly create a form that includes these fields. Your database should now look like the image below.
Now, click on the "Create" menu on the ribbon and choose the "Module" option. You will see a Visual Basic window open where you can enter code. This is where we will create the function that will capture a the network login name of the user entering data.
Enter in the following code. This code was originally written by Dev Ashish and can be found on a post at mvps.org. According to the licensing terms, you are free to use this code as part of an application as long as you leave intact the code attributing the creation of this function to him.
Type the code from Dev Ashish into your module and save it as "Module1." Close Module1.
Image Credits: Screenshots taken by Bruce Tyson.