Solved

Shortcut menu in Access 2007 Forms

Posted on 2009-07-10
6
1,037 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
6 Comments
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
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
Comment Utility
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 50 total points
Comment Utility
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
Backup Your Microsoft Windows Server®

Backup 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.

 

Author Comment

by:Henry_Harris
Comment Utility
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 75 total points
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

772 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

12 Experts available now in Live!

Get 1:1 Help Now