chestera
asked on
Access App login
Hi EE
I need to produce a Login for an access app. I have never done this before so would appreciate some help to get started
chestera
I need to produce a Login for an access app. I have never done this before so would appreciate some help to get started
chestera
ASKER
DatabaseMX
Not sure if it's a password I need possible my question a bit vague. I have a custom menu. part of the menu contains Manufacturing and Stores. When a user from the store section acesses the app I want them to ony to access Manufacturing and stores and the rest is disabled. I have the Menu sorted but not sure how to develope a login procedure that is if it's possible
Alan
Not sure if it's a password I need possible my question a bit vague. I have a custom menu. part of the menu contains Manufacturing and Stores. When a user from the store section acesses the app I want them to ony to access Manufacturing and stores and the rest is disabled. I have the Menu sorted but not sure how to develope a login procedure that is if it's possible
Alan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
minor type in first line of code...
If Environ("UserName") = "SomeName1" Or If Environ("UserName") = "SomeName2" Then
add as many OR conditions as practical, or use the table approach.
mx
If Environ("UserName") = "SomeName1" Or If Environ("UserName") = "SomeName2" Then
add as many OR conditions as practical, or use the table approach.
mx
ASKER
DatabaseMX
Many thanks for that. It shoudl get me started
Alan
Many thanks for that. It shoudl get me started
Alan
always a pleasure Alan ... post back if you need more help.
mx
mx
ASKER
DatabaseMX
Will do thank you
Alan
Will do thank you
Alan
How to Create a Password Protected Form or Report
http://support.microsoft.com/?kbid=209871
mx