Creating Menu - Toolbar

[George]

I created a Global Menubar for my database - that works great. The only time
I need to deviate from that is when I open my one report I need the Print
Button to appear in the Menubar. I created a Toolbar but I am having two
problems, One it appears all the time with the Global Menubar rather then
just when the report opens and second it's only the Print function I need the
Run Command version of print so I can select the prnter etc. When I created
the toolbar I inserted it in the Toolbar properites of the report - but it
still stays open all the time, what am I doing wrong ?

Thanks

 

[Rob Parker]

Hi George,

For problem one, change the custom toolbar you've made into a menu bar: in
the Toolbars tab of the Customise dialog, select your toolbar, then click
the Properties button and change its Type to Menu Bar. Then select your
custom menu (which you've just created) in the Menu Bar field, rather than
the Toolbar field, of your report in Design mode (on the Other tab of the
report's property sheet). This will cause your menu bar to replace the
Global menubar when the report is open. If you don't want it to replace the
Global menubar, but to appear in addition to it, then leave as a toolbar,
referring to it in the Toolbar field. In either case, if it appears at all
times, simply right-click in any empty space on any menu/toolbar (not in
Customise mode) and clear the checkbox from that menu/toolbar; it will then
appear only when the report is open.

For the second problem, the solution I use is a bit trickier. The item you
get from the Comands section of the File category on the Commands tab in the
customise dialog does, as you've discovered, not give the print dialog. The
way I get that command onto a custom menubar is: with the Customise dialog
open, navigate to the Print... command on the standard menubar (you may need
to make this visible if you've replaced it with your custom global menu
bar), then hold down the Control key and drag this command to your custom
report menu. If you don't hold the control key down, you'll move it rather
than copy it, and it won't be available on the standard menu bar
unless/until you reset it. And that should fix it!

HTH,

Rob

 

[George]

That works... Thanks Rob for your time.

George

Hi George,

For problem one, change the custom toolbar you've made into a menu bar: in
the Toolbars tab of the Customise dialog, select your toolbar, then click
the Properties button and change its Type to Menu Bar. Then select your
custom menu (which you've just created) in the Menu Bar field, rather than
the Toolbar field, of your report in Design mode (on the Other tab of the
report's property sheet). This will cause your menu bar to replace the
Global menubar when the report is open. If you don't want it to replace the
Global menubar, but to appear in addition to it, then leave as a toolbar,
referring to it in the Toolbar field. In either case, if it appears at all
times, simply right-click in any empty space on any menu/toolbar (not in
Customise mode) and clear the checkbox from that menu/toolbar; it will then
appear only when the report is open.

For the second problem, the solution I use is a bit trickier. The item you
get from the Comands section of the File category on the Commands tab in the
customise dialog does, as you've discovered, not give the print dialog. The
way I get that command onto a custom menubar is: with the Customise dialog
open, navigate to the Print... command on the standard menubar (you may need
to make this visible if you've replaced it with your custom global menu
bar), then hold down the Control key and drag this command to your custom
report menu. If you don't hold the control key down, you'll move it rather
than copy it, and it won't be available on the standard menu bar
unless/until you reset it. And that should fix it!

HTH,

Rob

 

[George]

That works... Thanks Rob for your time.

George

Hi George,

For problem one, change the custom toolbar you've made into a menu bar: in
the Toolbars tab of the Customise dialog, select your toolbar, then click
the Properties button and change its Type to Menu Bar. Then select your
custom menu (which you've just created) in the Menu Bar field, rather than
the Toolbar field, of your report in Design mode (on the Other tab of the
report's property sheet). This will cause your menu bar to replace the
Global menubar when the report is open. If you don't want it to replace the
Global menubar, but to appear in addition to it, then leave as a toolbar,
referring to it in the Toolbar field. In either case, if it appears at all
times, simply right-click in any empty space on any menu/toolbar (not in
Customise mode) and clear the checkbox from that menu/toolbar; it will then
appear only when the report is open.

For the second problem, the solution I use is a bit trickier. The item you
get from the Comands section of the File category on the Commands tab in the
customise dialog does, as you've discovered, not give the print dialog. The
way I get that command onto a custom menubar is: with the Customise dialog
open, navigate to the Print... command on the standard menubar (you may need
to make this visible if you've replaced it with your custom global menu
bar), then hold down the Control key and drag this command to your custom
report menu. If you don't hold the control key down, you'll move it rather
than copy it, and it won't be available on the standard menu bar
unless/until you reset it. And that should fix it!

HTH,

Rob