Solved

Disable some short-cut menu options Access 2007

Posted on 2011-09-15
1
428 Views
Last Modified: 2012-05-12
I have an access database that I converted to an accde file to prevent users from accessing the code and I disabled the window that allows users to view objects.

Everything works good except that now a when a user right-clicks on a form they have the following options
Datasheet view
Pivottable view
pivotchart view
cut
paste
properties
close

I did not disable shortcut menu because I need cut and paste to be the only two available options in the shortcut menu on all forms.  The other options have the potential to mess up things.

Can anyone help in getting this done?

shortcut.bmp
0
Comment
Question by:RDLFC
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 36541920
You'd have to build your own rightclick menus and use those instead of the default menus. This isn't too terribly easy in 2007/2010, and most of the time you're better off doing this in 2003 and then converting afterwards.

If you must build them in 2007/2010, you can use VBA to do so. Here's a good writeup from Garry Robinson about doing this:

http://www.vb123.com.au/toolbox/09_access/rightclick.htm

Toward the bottom of that article you'll see a tutorial on creating rightclick menus in 2007.

0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now