[Last Call] Learn how to a build a cloud-first strategyRegister Now


MSAccess Menu

Posted on 2007-10-02
Medium Priority
Last Modified: 2013-11-28
I have created a form in MSAccess 2003 I would like to add a menu and submenu ( Not switchboard menu). I also want when the form is opene by a user the initial menu that MSAccess already don't show up, only the menu I created should show up.

Any help on how to do that?

Question by:jskfan
  • 3
  • 2
LVL 34

Expert Comment

ID: 20003367
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 total points
ID: 20005341
You can also set your customer MenuBar to be the default when Access launches. After building your menubar, click Tools - Startup, and then select your Menubar. You might also want to allow/disallow other menu items (for example, you probably don't want users to be able to Change toolbars/menus, or show the Builtin Toolbars).

You can change Menus as needed for a particular form by setting the MenuBar property of that form (in Design view, click the Other tab in the Properties dialog, then select your Menu Bar). Same with Reports.

Author Comment

ID: 20008768
but how am I going to move the existing buttons on the form to the new tool bar I created.
the existing buttons have events associated to them.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 34

Expert Comment

ID: 20010959
You have two options when it comes to creating menus. One) you can create macros to run from your menus that achieve the same functionality as your buttons, or you can call a function or public sub to do what your button does. Creating macros allows you to click and drag onto your menus, using the function method requires you to create a menu element then configure it after the fact.
Hope this helps.

Author Comment

ID: 20011441

When You add buttons to your toolbar, first you need to label these buttons and also create an event when you click on it. Is there a way to do that. ?
LVL 34

Accepted Solution

jefftwilley earned 1600 total points
ID: 20011481
you create the event by creating a macro. Then when you right click your menu and go to customize, you can drag the macro directly onto your new menu bar. These become the "event" that fires when the option on the menu is selected. There are a lot of tutorials out on Access related sites, as well as www.msdn.com if you want to try to find that. You can also search here on EE for words like Custom Menu, or Adding sub menus to custom menu. It seems you understand the concept, you just need a step by step.
here's a good starting point

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question