Hide menus in A2003 and A2007 using VBA

[oxicottin]

Hello, I wanted to know if there was a way to hide the menu in A2007 just like the way I used VBA to hide the menu in A2003. I want to be able to open the .mdb in 2003 and the menu will be hidden and if I open it up in 2007 I want it hidden as well. How could I acomploish this using VBA? Thanks!

This is what I use to hide menu in 2003 what would I add to the code?

Private Sub Form_Load()
'**************************************************
'* Disables/Enables the menu bar in 2003 and 2007 *
'**************************************************
  Application.CommandBars("Menu bar").Enabled = False '*****Disables Menu Bar******
 'Application.CommandBars("Menu bar").Enabled = True  '*****Enables Menu Bar*******
  
End Sub

I tried to add and it gave an error:

 'DoCmd.ShowToolbar " The Ribbon ", acToolbarNo  '******A2007 hide the Ribbon*****
 'DoCmd.ShowToolbar " The Ribbon ", acToolbarYes  '*****A2007 show the Ribbon*****

 

[vbaInet]

It still boils down to you learning the Access 2007 UI. Remember, myself and two other VIPs advised you of this in one of your other posts?

Have a look at this:
http://msdn.microsoft.com/en-us/library/bb258192.aspx

These links explain how to customize the ribbon (and by customizing it could mean hiding too):
http://msdn.microsoft.com/en-us/library/bb187398.aspx
http://www.accessribbon.de/en/

 

[oxicottin]

vbaInet, This is a temp fix I did remove the pop ups ect. and I have been rooting around on my bosses A07 and its really not that bad. I probably will mess with it in my spare time when I get some...

 

[vbaInet]

The first link is the answer to your question. Not much to learn, just follow what it says. 15 minutes of your time.

 

[oxicottin]

vbaInet, since I set the properties of my reports ect to "popup- no" and took out the DoCmd.maximize on the reports open, how can i make the window fill the space without covering the menu bar and task bar like in the picture, I dont want to cover the windows min,max and close buttons? Oh and I routed around in A2007 a little more and read some more about how to do stuff and instead of using code I just went into thier copy and hid or minimized the ribbon which I like. Im starting to like that version....

Thanks!
Chad

 

[vbaInet]

That's only available in Report View, which as you know doesn't include the navigation buttons. There's no in between.

Your boss can use the zoom menu to increase the size of the report. Again, that would require you to include the Ribbon

I'm glad you're beginning to learn the new features of 2007.

 

[oxicottin]

I asked my admin to install a copy on my PC but you know, thats going to take forever.... Well im learning...

Thanks,
Chad

 

[vbaInet]

I think you should go and get it and install yourself if they are wasting time

Good luck in your quest for knowledge.