• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1188
  • Last Modified:

Disable menu items on switchboard

how can i disable certain menu items on the switchboard based on user credentials (username). i would like to limit access to certain functions from certain users
0
ocmwila
Asked:
ocmwila
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
ocmwila,

Might be to complicated for a beginner.
Might be better if you built you own menus and used somethoing like this:

If UserName="ocmwilla" then
    me.btnOpenForm.enabled=False
else
     me.btnOpenForm.enabled=True
end if

Are you using Access' security username or are you speaking of the Newtork Username?

JeffCoachman
0
 
ocmwilaAuthor Commented:
thanx jeff
there are several menus(switchboard) and i need to disable some menu items on several of them and so i am willing to do even the complicated.
0
 
Jeffrey CoachmanMIS LiasonCommented:
ocmwila,

OK, I will presume that you are talking about a network UserName, not an Access Username, created by the User level security wizard

The issue here is that the Access switchboard is not as it appears.

Every switchboard menu you see is actually THE SAME MENU!
:)

The options are changed depending of which "switchboard" you are supposed to be in.
The switchboard has fairly complex VBA code behind it, that controls the options.
It also has a "Switchboard Items" table that dictates the menus and options.
You have to make sure that none of these conflict with one another.

A better approach might be to use the User Level Security Wizard.
It is a simple and straightforward utility that creates users and groups in Access.
Some "User Group" examples are:
-Read Only
-Update users (users who only change data)
-Insert (Add) users (Users who only Add records)
-Full Permissions
...ect
You can read more on the wizard here:
http://databases.about.com/od/tutorials/ss/usersecurity.htm
http://office.microsoft.com/en-us/ork2000/HA011381171033.aspx

Once this is done, a ReadOnly user cannot edit any records.
Similarly, an Update user cannot Delete any records.

If you try to do this based on the network login you might spend too much time deciding "who can do what, in what form".
Ex.
Joan can edit customers, but she can't create orders.
Bob can delete Orders, and Customers but he can't add products.
...ect

I'm basing this on you status as "Beginner".
Most Experts will advise you not to even use the Access switchboard, because of it's many limitations.

If you are willing to "Even do the Complicated" , then my recommendation is to create your own menus an simply use code like I listed above to enable/disable certain options.
(But change “UserName” to “CurrentUser”)
If CurrentUser="ocmwilla" then
    me.btnOpenForm.enabled=False
else
     me.btnOpenForm.enabled=True
end if

Hope this helps
:)

JeffCoachman
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now