Hum, what I have been doing is that I don't use any code to show/hide the
menu bars.
The best solution is simply to have a MAIN menu bar that your specify in the
application. (you mention that you have this also).
Quote:
My problems start when I open up my reports from a modal popup form. I
open them maximized with a custom toolbar.
When I close my report I ensure I have my custom menubar again by
using
DoCmd.ShowToolbar "MainMenu", acToolbarYes on the OnClose event. |
Why do you have to do the above? You can specify what menu bar for the
report "form". In fact, you can, and no doubt specify lots of menu bars for
forms that open. When a form opens, then the forms menu bar shows,a and the
main one hides. In addition, you of course have a menu bar specified in the
report also. No doubt, all your reports have a nice docmd.Maximize for the
users to see as much as the report as possible. Your customer report menu
bar also no doubt has things like email, and whatever you like. Here is a
screen shot of my report menu bar:
http://www.attcanada.net/~kallal.msn/test/bu1.gif
Quote:
For an instance both of the toolbars are present which causes my
MainForm which always remains open to reposition down the width of a
toolbar. |
Hum, as mentioned, if you set the menu bar for the report, and also set the
menu bar for the form, then you might avoid your problem. I never did need
to "hide" the menu bar as you are doing, but perhaps you have a different
approach/design to launching reports. I and my users prefer a nice prompt
form for each report. The users select tings like date, location and
whatever. They then launch the report. At his point they view, preview,
print, and do whatever. If they are not happy, they then close the report to
return back to the nice prompt form. Often, they need to just change the
date range, or whatever. Thus, returning to BACK to a nice prompt form is
very user friendly. Often, my prompt forms will also have SEVERAL REPORTS
that can be launch from the same form. This is really nice, since after
selecting things like date ranges, and stuff like location, then they DO NOT
HAVE to RE-SELECT the date range for each report they run. (they select the
date range,and then run the 4 or 5 different reports they need..this is
really user friendly).
Here is some screen shots that show what I mean:
http://www.attcanada.net/~kallal.msn.../ridesrpt.html
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
kallal (AT) msn (DOT) com
http://www.attcanada.net/~kallal.msn