Solved

Disable menu items on switchboard

Posted on 2007-11-28
5
1,141 Views
Last Modified: 2013-11-29
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
Comment
Question by:ocmwila
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20371594
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
 

Author Comment

by:ocmwila
ID: 20372327
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 20374225
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
 
LVL 1

Expert Comment

by:Computer101
ID: 21186188
Forced accept.

Computer101
EE Admin
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question