How can I create a custom menu bar?

Build your own custom menubar and set that to open when your report opens.

To create a new menubar:

1) Click Tools - Customize
2) On the Toolbars tab, click New. Name your new Toolbar.
3) Now add controls and items to the bar. YOu can use the builtin commands by clicking the Commands tab and locating those commands, then drag-drop them to your menubar.

Now open your report in Design view and select your new Toolbar in the properties page. It's in the Other tab, under the Toolbar selection.

Thank you.  That works well, but it doesn't completely meet my needs.  There are two issues:

1) When the database loads it disables all built-in menus.  Therefore, selecting the custom menu in the properties page of the report isn't enough.  I believe that I will have to enable it when the report loads, otherwise it doesn't open.  (When built-in menus are enabled then the custom menu opens when the report opens.)  Would you please tell me how to do this.  

2) I would like the user to be able to do only three things 1) print the whole report, 2) select specific pages of the report to print, and 3) close the report.  The first and third of these is easy.  But how can I enable the user to print specific pages of the report without giving them the entire File menu?

Thank you again for your help!

<I believe that I will have to enable it when the report loads>

If you set the Report's Toobar property to your new toobar, you'll see that toolbar. Did you try this to see?

<But how can I enable the user to print specific pages of the report without giving them the entire File menu?>

The Print menuitem allows users to select the Pages they wish to print. This is the simplest option, it would seem. Does that not suit your needs?

Hi.  

Yes, I tried.  The custom report menu does not open when all command bars have been disabled.  Fyi, this is the code I run when the database opens:
 Dim j As Integer
    For j = 1 To CommandBars.Count
        CommandBars(j).Enabled = False
    Next

I don't have (don't know how to find) a print menu that is independent from the File menu.  There is a print command button, but that prints the entire report without letting the user chose specific pages.  Where can I find the print menu?

Thanks!

Your first suggestion works.  Thank you.

In the version of Access that I am using, 2003, page setup doesn't allow the user to pick which pages they want to print.  Perhaps a later version does.    Your point is well taken, however, that the user should select the records that they want to see before the report opens.  I always just like the option of being able to print a specific page in case there was a problem with the print, some little piece of information was changed requiring a reprint, etc.  But this isn't too important.  

Thanks again for all of your help.