[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Shortcut menu in Access 2007 Forms

Posted on 2009-07-10
6
Medium Priority
?
1,047 Views
Last Modified: 2013-11-28
Is there any way of enabling the shortcut menu for fields within a Form, for Sorting and Searching, whilst disabling the shortcut menu from the Title Bar of the Form for Saving, Closing and Design View?
0
Comment
Question by:Henry_Harris
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 44

Expert Comment

by:GRayL
ID: 24823991
You have to build your own tool bar to be used in place of the normal forms tool bar when that form is called.  Read all you can find on the form property Toolbar - especially Help in both the Database and VB Editor windows.
0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24825428
Here is an article on creating shortcut menus in Access that might help:
http://blogs.msdn.com/access/archive/2009/05/21/how-to-create-a-shortcut-menu-for-a-form-form-control-or-report.aspx 
-chuck wood
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 200 total points
ID: 24827089
Henry_Harris,

"ShortCut Menu" typical refers to the "Right click menu".

If this is what you are referring to, then you can only assign specific Shortcut menus to the individual Forms, not controls on a form.

<whilst disabling the shortcut menu from the Title Bar of the Form for Saving, Closing and Design View?>
Again, I think you have your terms confused.
There is no "ShortCut" menu in the title bar.
What is in the Title Bar are known as "Drop Down Menus"

What you are asking for is certainly do-able.
You have to create a Custom *Toolbar*, (Using the "Built in Menus" Option in the "Commands" tab of the Customize Dialg box) and simply not include what you don't want.
Then you have to change the properties of this toolbar to make it a Menubar.
Then set that Menubar as the Default in the Access StartUp Options.

See this links for detailed info on creating Toolbars/Menubars:
http://learning.londonmet.ac.uk/CCTM/im212/week7/menus.htm

;-)

JeffCoachman
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Henry_Harris
ID: 24829524
Thanks for your replies.

Yes I do mean the right-click menus. It would be nice to prevent the Save, Close and Views menu from the title bar of the Form whilst still allowing the Sort and Search menu from any individual field. I think that it can be achieved but the other way round by manipulating the Shortcut Menu Bar property.
0
 
LVL 16

Assisted Solution

by:Chuck Wood
Chuck Wood earned 300 total points
ID: 24838943
Did you read the article on How to: Create a Shortcut Menu for a Form, Form Control, or Report?
http://blogs.msdn.com/access/archive/2009/05/21/how-to-create-a-shortcut-menu-for-a-form-form-control-or-report.aspx 
-chuck wood
0
 

Accepted Solution

by:
Henry_Harris earned 0 total points
ID: 24841709
Thnaks for the last reply. Yes I have looked at the article and it is a way to go. I also clicked the comment was helpful button. I hope this worked
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

656 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