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

[oxicottin]

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


Thanks,
SoggyCashew.....

 

[MazeWorX]

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]

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]

MazeWorX, thanks a million for the example..... I'm going to have to look at it on Monday when I go back to work.

Thanks,
Chad

Thanks,
SoggyCashew.....

 

[oxicottin]

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

Thanks,
Chad

Thanks,
SoggyCashew.....