PC Review


Reply
Thread Tools Rate Thread

Access 2007 - Hiding the Menu Bar

 
 
Jim Franklin
Guest
Posts: n/a
 
      17th Aug 2010
Hi,

This is driving me nuts so if anyone can help it would be very much
appreciated!!

I have a .mdb application that I developed in Access 2003 which is going to
be used by a client running Access 2007 run-time. When I load the mdb in
Access 2007, whatever I do, I cannot get rid of the menu bar at the top.
Ideally I want my startup form to load, maximise and show NO toolbars
whatsoever (although in 2003 I added a custom menu bar JUBMenu1 and a custom
shortcut menu JUBPopup1, so it could just show JUBMenu1 if that is easier.)

In Access 2007, I have gone into Access Options > Current Database and
unticked all the 'Allow Full Menus', 'Allow Default Shortcut Menus' and
'Allow Built-in toolbars'. I have tried setting the Menu Bar and Shortcut
Menu bar settings to either 'default' or to JUBMenu1 and JUBPopup1. Ribbon
Name is blank.

I have also tried in my form load event to run
docmd.showtoolbars "Menu Bar", acToolBarNo

I have tried setting the menu bar and shortcut menu bar properties for my
startup form to Blank/No or the JUB menus I mentioned.

Nothing makes any difference. The Menu Bar still appears, regardless of
whether my custom menu appears or not. I can undock it and move it, but I
cannot hide it.

Please can anyone help? Thanks!

Jim


 
Reply With Quote
 
 
 
 
Damon Heron
Guest
Posts: n/a
 
      17th Aug 2010
Your configuration is almost exactly the same as mine, except I don't have
the 07 menu bar appear (except for a brief appearance on opening, along with
the status bar). It then disappears.

Is your db saved in 2003 format?
Also, I noticed that I have Allow full menus checked.
Ribbon is blank, and menubar is set to the menu I designed in 2003.

It works for me!

Damon




"Jim Franklin" <(E-Mail Removed)> wrote in message
news:jjwao.36183$GQ5.22138@hurricane...
> Hi,
>
> This is driving me nuts so if anyone can help it would be very much
> appreciated!!
>
> I have a .mdb application that I developed in Access 2003 which is going
> to
> be used by a client running Access 2007 run-time. When I load the mdb in
> Access 2007, whatever I do, I cannot get rid of the menu bar at the top.
> Ideally I want my startup form to load, maximise and show NO toolbars
> whatsoever (although in 2003 I added a custom menu bar JUBMenu1 and a
> custom
> shortcut menu JUBPopup1, so it could just show JUBMenu1 if that is
> easier.)
>
> In Access 2007, I have gone into Access Options > Current Database and
> unticked all the 'Allow Full Menus', 'Allow Default Shortcut Menus' and
> 'Allow Built-in toolbars'. I have tried setting the Menu Bar and Shortcut
> Menu bar settings to either 'default' or to JUBMenu1 and JUBPopup1. Ribbon
> Name is blank.
>
> I have also tried in my form load event to run
> docmd.showtoolbars "Menu Bar", acToolBarNo
>
> I have tried setting the menu bar and shortcut menu bar properties for my
> startup form to Blank/No or the JUB menus I mentioned.
>
> Nothing makes any difference. The Menu Bar still appears, regardless of
> whether my custom menu appears or not. I can undock it and move it, but I
> cannot hide it.
>
> Please can anyone help? Thanks!
>
> Jim
>
>

 
Reply With Quote
 
Jack D. Leach
Guest
Posts: n/a
 
      24th Aug 2010
"Jim Franklin" <(E-Mail Removed)> wrote in
news:jjwao.36183$GQ5.22138@hurricane:

> Hi,
>
> This is driving me nuts so if anyone can help it would be very much
> appreciated!!
>
> I have a .mdb application that I developed in Access 2003 which is
> going to be used by a client running Access 2007 run-time. When I load
> the mdb in Access 2007, whatever I do, I cannot get rid of the menu
> bar at the top. Ideally I want my startup form to load, maximise and
> show NO toolbars whatsoever (although in 2003 I added a custom menu
> bar JUBMenu1 and a custom shortcut menu JUBPopup1, so it could just
> show JUBMenu1 if that is easier.)
>
> In Access 2007, I have gone into Access Options > Current Database and
> unticked all the 'Allow Full Menus', 'Allow Default Shortcut Menus'
> and 'Allow Built-in toolbars'. I have tried setting the Menu Bar and
> Shortcut Menu bar settings to either 'default' or to JUBMenu1 and
> JUBPopup1. Ribbon Name is blank.
>
> I have also tried in my form load event to run
> docmd.showtoolbars "Menu Bar", acToolBarNo
>
> I have tried setting the menu bar and shortcut menu bar properties for
> my startup form to Blank/No or the JUB menus I mentioned.
>
> Nothing makes any difference. The Menu Bar still appears, regardless
> of whether my custom menu appears or not. I can undock it and move it,
> but I cannot hide it.
>
> Please can anyone help? Thanks!
>
> Jim
>
>


With a reference to Microsoft Office 11.0 Object Library, use the
following line of code:

Application.Commandbars("Menu Bar").Visible = False

hth

--
Jack D. Leach
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding the Menu Bar in Access 2007 Jim Franklin Microsoft Access 0 15th Aug 2010 11:59 AM
Hiding navigation pane in Access 2007 wmdmurphy Microsoft Access Reports 0 16th Apr 2008 08:47 PM
Problem hiding the access menu bar =?Utf-8?B?SmltIEJ1cmtlIGluIE5vdmk=?= Microsoft Access VBA Modules 2 23rd Oct 2007 07:28 PM
Recover Access menu after hiding =?Utf-8?B?TGkgUWl1?= Microsoft Access Security 1 27th Oct 2006 08:22 AM
Hiding the Access menu from view?? =?Utf-8?B?UmljaGFyZCBD?= Microsoft Access Forms 1 12th Oct 2004 12:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:52 PM.