Microsoft Access - Get User Name

Use User Name/Group to Limit Functionality
It can be useful to know who is using your application. Sometimes we want to log activity. Other times we want to restrict access to certain controls or to certain areas of an application. You can do this based on user name or a user group. At the heart of using a user group however, is knowing who the user is.
In this video we will:
1. Look at two VBA methods to retrieve a User Name from your system
2. Look at a simple way to implement user groups
3. Control access to controls via user name or user groups
The VBA in this video can be found here:
accessjitsu.com...
All of my videos organized by topic and other blog topics:
accessjitsu.com/

[@tysonprice]

Thank you so much i was able to use this to secure a database I have been working on using the CAC card system.

[@MrShmuel]

The "For Each ctl" Code for some reason did not work for me. is there something I have to enable in Access for it to work? This is in Access 2016.

[@manstr99]

Hi, how to fetch username from users table and not from windows OS. tia

[@IFFrael]

Let me be the first to say thanks: Thanks!

[@nak141]

Username doesn't work on wind 10, office 2016, 64 bit. Kindy adv one for 2016. Thanks

[@robb2056]

Works on my PC

[@nak141]

Robert Burkley is ur version 64bit?

[@kennethaparicio2734]

it worked for me & I have win10 64bit, office 2016