Ribbon, Nav, Menu or Tool Bars

[Kenln]

We are upgrading our Access apps from Office 2003 to 2007, yep we're behind the curve.

We tend to hide the standard menus and tool bars. This give us more control of the app and the user experience.

For reports we created a menu bar that displays when has print preview a report.

Now... in this new world of ribbons I can't even find where or how to edit this menu, I know it imported and seems to work but beyond that I'm lost...

I know how to hide the Nave Pane and Ribbon, thank goodness. But I still need the way to print a print preview screen.

Options:
Keep the imported Menu and hope I don't have to edit it. Naw...
Custom Nav that only display my buttons and disapears completely
Custom Ribbon that only display my buttons and disapears completely
Other ideas and options????

I would greatly appreciate any advice and direction.

Thank you,

 

[vbaInet]

To find your old custom menu bars and toolbars you need to look in the Add-Ins tab.

See this thread (i.e. post #2) on the suggested ways of amending your pre 2007 menus:

http://www.access-programmers.co.uk/forums/showthread.php?t=204294&highlight=access+2007

 

[Kenln]

As part of the example you gave me I copied and pasted.

Part of the Function is:
Dim cmb As CommandBar

But when I compile I get:
"User-defined type not defined"


Am I missing a reference?

 

[vbaInet]

Probably the Microsoft Office 12.0 Object Library or Microsoft Access 12.0 Object Library