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
chesteraAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
See if this gives you a jump start:

How to Create a Password Protected Form or Report
http://support.microsoft.com/?kbid=209871

mx
0
chesteraAuthor Commented:
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

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I see. Well, there are soooo many ways this can be done.  Below is an example.
Basically, you look at the Windows Logged In User name ... then based on that, determine with menu parts to enable disable.

Generically it looks something like this:

    If Environ("UserName") = "SomeName1" Or If Environ("UserName") = "SomeName1"  Then 'more ...
        CommandBars(Index:="zMbQMS").Controls(Index:="Ad&min").Enabled = True
        CommandBars(Index:="zMbQMS").Controls(Index:="Ad&min").Visible = True
    Else
        CommandBars(Index:="zMbQMS").Controls(Index:="Ad&min").Enabled = True
        CommandBars(Index:="zMbQMS").Controls(Index:="Ad&min").Visible = False
    End If

You could have a little local table which Window user names and which menu they should see.

This could would likely go in your app start up code. For example, an AutoExec macro would call a Function in a regular vba module that has code like this ...

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
0
chesteraAuthor Commented:
DatabaseMX

Many thanks for that. It shoudl get me started

Alan
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
always a pleasure Alan ... post back if you need more help.

mx
0
chesteraAuthor Commented:
DatabaseMX

Will do thank you

Alan
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.