Menu Bar

[DeutchBose]

I have a database that excludes all the full menu and tool bars...Under Tools>Startup, everything under 'Menu Bar' and 'Tool Bars' are un-checked.

On Startup, a Form pops-up with several report-running command buttons. When these reports pop-up, I'd want the user to be able to export to Word or Excel. I'd like to add the 'Export' Button that shows up on the full tool bar, but nothing else...

I've been playing around with Customizing the tool bars, but seem to be making a bigger mess of things....anyone have experience with this..?

 

[Norie]

Why not instead add more options to the form?

That is add buttons to let the user preview, print, Export to Excel and Export to Word.

You could even use a dropdowns to show these choices and to show the reports.

Then have one command button that works with the choices the user has chosen.

 

[tails]

Good idea, and with the command buttons you can create a macro and just put the code behind the button. very simple process, takes about 5-10 minutes

 

[SydneyGeek]

I like Norie's idea but if you still want to use the custom toolbar option, do this:

1. Right-click the menu area, Customise. In the Toolbars tab, click New. Make sure it's a Toolbar. Call it ExportOnly.
2. From the Commands tab, select File and scroll down to the Excel and Word icons. Drag them onto the toolbar. When finished, close the Customize box. To hide ExportOnly, right-click it and deselect.
3. Now, for EACH report, go to Design view. Properties | All, scroll down till you see Toolbar. Select ExportOnly, close adn preview the report. The toolbar will pop up, and will disappear when the report is closed. Make sure to save...

Denis