I have a form which is actually the first form that pops up when the database is opened. I have only 2 users that will input data, and everyone else will have view and print only Permissions(just the forms). Everyone with the view and print only permissions doesn't really need a password. The 2 input-users do, so they can go in with full permissions. I have a user name box on the form that already retrieves the Network user name, and I have a password box that I have no idea what to do with. How can I give the 2 input-user a password, and everyone else no password. I would like the password box only to show when an input-user opens the database, and invisible when any other user opens the database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grabbing user name from Network
- Thread starter Mtlca401
- Start date
I'm not sure I'd do it that way, but....
In the form design set the textbox password.visble property to false
Permitted user opens database, his network logon is captured and a variable is set to that value.
When the form opens an If series will set visible.true if the user logon is a set value.
if username="permitted1" then
txtpassword.visible=true
else password.visible=false
endif
HTH
telephoto
In the form design set the textbox password.visble property to false
Permitted user opens database, his network logon is captured and a variable is set to that value.
When the form opens an If series will set visible.true if the user logon is a set value.
if username="permitted1" then
txtpassword.visible=true
else password.visible=false
endif
HTH
telephoto
- Status
Similar threads
