Thread: Creating a Menu
View Single Post
  #8  
Old February 4th, 2010, 03:13 PM posted to microsoft.public.access.commandbarsui,microsoft.public.access.forms,microsoft.public.access.formscoding
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Creating a Menu

I have several functions when I want to turn them of and on:

Function ShowMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarYes
End Function

Function HideMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarNo
End Function

Function ShowToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarYes
End Function

Function HideToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarNo
End Function
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Jack Leach" dymondjack at hot mail dot com wrote in message
news
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.