Switchboard and user access management

[eraslan.cem]

hello to all;

I have a switchboard which have four tabs regarding to the different
user types . Assume that i have four types of users, so that four tabs,
which are , Admins, Input, Control & Inquire. What i'm planning to do
is a smart switchboard which is sensitive to these user types and open
these tabs just to the related users.

User OO is a member of input and i put the code under to the click
event of the Control tab.

' If CurrentUser = "OO" Then
' MsgBox ("You don't have aceess to this site.")
' ActiveForm.Close
' Else
' End If

But the code didn't activated when the user click on the tab but click
on an empty space somewhere on the tab. (Also there is something wrong
with the third line --

Is it a better way to give these permission to the related users (May
be tabbing is not a good alternative) ...

Also there are a lot of users who will use this form so setting access
level user-by-user will be a bit confusing. Is there a way to define
the user "OO" as a member of Input group and then setting access level
will be easier. Couldn't find a solution for both.

Any suggestions welcomed...

Good Day to all....

Cem Eraslan

 

[jahoobob via AccessMonster.com]

Since each user should open a unique frontend it would be much simpler to
develop four separate Switchboards and distribute the appropriate frontend to
the users. Developing four different Switchboards would take about the same
amount of time as a switchboard with four tabs. From what I remember about
Swirchboards (I don't use them anymore), I don't think that can be done. To
create a tabbed "Switchboard" you would have do roll-your-own using a form.

 

[eraslan.cem]

thx for your answer ...

the idea behind was a neater look and make things easier but caused
more trouble than expected ...

still i have problems with the user groups in coding but thats a
different story anyway

thanx a lot