Get user

M

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
 
S

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