Shortcut menu in Access 2007 Forms

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?
Henry_HarrisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GRayLCommented:
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
Chuck WoodCommented:
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
Jeffrey CoachmanMIS LiasonCommented:
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
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Henry_HarrisAuthor Commented:
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
Chuck WoodCommented:
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
Henry_HarrisAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.