Delete stabndard menu bar

[wrightway]

After creating a custom menu bar, how can I delete/hide the standard menu bar
(File Edit View Insert) in Access XP using vba?

tks

 

[Peter Huang [MSFT]]

Hi

I think you may try to set the Commandbars("Menu Bar").Enable = False

Here is a KB article, you may have a try.

209974 How to create command bars by using Visual Basic code in Access 2000
http://support.microsoft.com/?id=209974

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[wrightway]

209974 was fun, thank you

I may have misled you by using the word 'menu bar' when I should have used
'toolbar".
We can hide/enable the menu bar objects (File Edit View Insert) and can
create a new custom toolbar with new menu bar. But how can we hide the
Standard tool bar in Access XP using vba?

Even manually using Tools/customise/toolbars we cannot deselect the
'Standard' menu or remove the "Type a question for help" box on the right of
the toolbar. Is this built-in toolbar sacrosanct?

thanks
Wrightway

 

[Peter Huang [MSFT]]

Hi

I still can not figure out which one do you mean.
Do you mean the one with "File Edit View..." or the one with Icons of(File
New, File Open ....)?
If you mean the former, I think we can use the Commandbars("Menu
Bar").Enabled = False
if the latter, we can use the the CommandBars("Database").Enabled = False

If I have any misunderstanding, can you post a screen shot to indicate
which one do you mean?
Thanks for you understanding!

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.