Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Login with Enable/Disable controls based on group user belongs to.

oxicottin (Programmer) (OP)
9 Feb 12 23:28
Hello, I have been searching for an example to incorperate into my existing DB which would allow the user to login using a form and depending on which group the user belongs to (Admin or Basic user)who is logging in certain controls on forms will be disabled. Admin of cource would have full access and the basic user would have a button on the main form disabled and 2 buttons on its subform disabled. How can I do this? Thanks


MazeWorX (IS/IT--Management)
10 Feb 12 2:41
One method would be to have the user login and write the current user name to a table. then using the controls tag property and the onload event of the form loop through the controls and enable or disable based on the current user and there permissions. if you only have 2 user levels this solution should work fine. There are other more complicated ways.


HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

MazeWorX (IS/IT--Management)
10 Feb 12 3:32
See attached a simple demo of what i was talking about (Acc 2003)

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

oxicottin (Programmer) (OP)
10 Feb 12 9:06
MazeWorX, thanks a million for the example..... I'm going to have to look at it on Monday when I go back to work. :(



oxicottin (Programmer) (OP)
13 Feb 12 12:46
MazeWorX, I looked at the example and thanks so much its what I needed. Please dont delete on file on MediaFire.... Someone else might need it :)



Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close