Get user

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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
 
Hello "Muriukis".

Muriukis said:
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
Click to expand...

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.
 
Back
Top