Get user

[Guest]

am designing a point of sale in access which has a login form. There are 3
users
admin, user1 and user2.How do i get their names to show in the point of sale
form when they login.I have a txtbox called user in the point of sale form. I
dont want to use the access workgroup wizard. Any help

 

[Scott McDaniel]

am designing a point of sale in access which has a login form. There are 3
users
admin, user1 and user2.How do i get their names to show in the point of sale
form when they login.I have a txtbox called user in the point of sale form. I
dont want to use the access workgroup wizard. Any help

Have you setup some form of security, or a login scheme on the database? If so, you'd need to capture the name when the
user logs in, and use that (perhaps write it to a table, or use a global variable - bad idea, IMO).

If not, then perhaps you could use the Window's Username? You can grab it like this:

Me.SomeTextbox = Environ("UserName")


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Wolfgang Kais]

Hello "Muriukis".

am designing a point of sale in access which has a login form.
There are 3 users admin, user1 and user2. How do i get their names
to show in the point of sale form when they login.I have a txtbox
called user in the point of sale form. I dont want to use the
access workgroup wizard. Any help

You don't have to use the wizard. You also can secure your database
at your own.
After doing so, use the CurrentUser() function to display the name
of the currently logged on user.