How do I limit access to switchboard items based on current user?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an example of a dBase where the developer "turned off" certain menu
options on the switchboard based on what user was logged in, however, I can't
figure out how to replicate it. The design I am working on is an employee
workload system. I want to create a separate group of reporting from the
swtichboard that only the group managers can access. Any assistance will be
appreciated.
 
I'm wondering if he didn't use the Visible True/False Properties in the
Private Sub FillOptions ()
of the Switchboard's Code Module:

While (Not (rst.EOF))
Me("Option" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
rst.MoveNext
Wend

And then based it on userID

If ID = Admin then
Visible = True

Hope to know if this helps.

Thanks,
Michael
 
Back
Top