Thread: Creating a Menu
View Single Post
  #6  
Old February 3rd, 2010, 04:09 PM posted to microsoft.public.access.commandbarsui,microsoft.public.access.forms,microsoft.public.access.formscoding
Jack Leach
external usenet poster
 
Posts: 33
Default Creating a Menu

In the Startup properties of the database (Tools menu) you should find the
required check boxes to turn these off.

For future reference (versions 2003 or earlier), should you want to turn
these back on, you can programmatically set the Visibility property of the
Menu Bar (Access's main bar). You will need a reference to Microsoft Office
Object Library V##

in the immediate window:
CommandBars("Menu Bar").Visible = True

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"PosseJohn" wrote:

Thank you, now I understand.

How do I remove the built-in menus that are appearing, would like to not
confuse the user as to where to go to perform manipulations.


"Arvin Meyer [MVP]" wrote in message
...
Do not create a menu bar. Use a form instead. Any operation which can be
done from a menu, can also be done from a button on a form. The form is
also more easily scaled and used as a template for multiple databases,
since it is easier to alter it once done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PosseJohn" wrote in message
...
I'm not sure what you mean by "using a form" for creating a menu bar...


"Arvin Meyer [MVP]" wrote in message
...
IMO, the best menus are Access forms. You can make a command bar menu,
but it may not be compatible with later versions. The Ribbon is not
compatible with Access 2003. By using a form, you are relatively assured
that you application will work in later and earlier versions, with
perhaps the built-in conversion utility.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PosseJohn" wrote in message
...
I'm using both ACC2003 and ACC2007.

I would like to create a Menu for my application and for a form (both
with submenus), as well as shortcut menus for the application and form.

Any good examples or references would be appreciated.

Thank you in advance.