Hide / Close Menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

When I preview my report I want to close one menu and open another. I can
open another one, but how do I hide/close the one already open.

The one alread open is the default menu that I have assigned.

Thanks,

Brad
 
just specify another menu bar for the reports. (this setting is found in the
"other" tab)

If you do this right...you don't need ANY code for the menus to switch.
(and, if you have a few forms open..then it can get REALLY messy very fast
if you have to try and "code/manage" what menu bar shows. I would STRONGLY
suggest you let ms-access do all the heavy lifting here.

I have a sample download that shows how to do this here:

note how NO code is used to hide all of the access interface...and note how
menu bar change from each form to each form...and note the report example.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
 
Hi Albert,

Thanks for the reply.

I have made my "General" menu bar the default, and I want to make it go away
and show the "GeneralPrint" menu bar when I open the report. I have set the
settings in the Report settings (Default menu and tool bars), but the
"General menu bar never goes away, so I have two menu bars and a tool bar
when I open my report.
I'm pretty sure I've done all the things you have suggested.

Thanks again for your help.

Brad
 
my download example does exactly that..but two menus bars don't show....

I am sure during the development process, you are exiting your
application....and then re-entering the application (but hold down the shift
key).

You will develop some code..change a form...you then exit the application,
and of course, your cursor is still on the mdb file...so, you hit enter...

I use alt-f4 to exit...then hit enter.... (but don't hold down the shift
key)...test the application....then alt-f4 to exit...and then shift key...+
enter key to re-load the application with the shift by pass.

The above "dance" to switch from "test as user mode" and switch back to "I
am the developer" mode will happen 100's of times in a day.

The solution to your problem is to shift enter into the application, and
hide (uncheck) the custom main menu. It should NOT show when you shift enter
into your database.

My example download has a report...and does exactly as you ask....
 
Hey Albert,

OK, I've gone through your db like you said, and I don't see the difference
between what you've done with your DB and what I've done with mine.

Here is a link to my band web site. I made a new folder and page on the
server and put a link to the the DB (which is in a zip file) like your web
site. Download it if you like and take a look at it. I can't see the
difference.

http://www.pierced.ca/AccessHelp/accesshelp.html

Thanks again,

Brad
 
Brad said:
Hey Albert,

OK, I've gone through your db like you said, and I don't see the
difference
between what you've done with your DB and what I've done with mine.
Click to expand...

I quote from my prevous post

<quote>

The solution to your problem is to shift enter into the application, and
hide (uncheck) the custom main menu. It should NOT show when you shift enter
into your database.

</quote>

I just tried the above on yours..and the above solution fixes this. As I
said, none of your custom menu bars should be showing when you shift enter
into your application.....

I just shift entered into your application..and sure enough..your custom
main menu bar is showing...(did you read or try my solution at all???).

As for the reports...you likely should dump the use of a tool bar..and just
specify the menu bar....move the tool bar options to the menu bar...
(you don't have to do this..but can't see any reason to have both a menu
bar..and tool bar showing for your reports).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal
 
Thanks for the reply Albert.

I did read your message and did use the shift key and took off the main menu.

I guess I'll just go with the tool bar.

Thanks again,

Brad
 
Back
Top