Menu Bar

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

I have seen code on how to create a custom menu. I have
also "played with" creating a custom menu by use of the
builtin Tools, Customize commands on the Access menu.

My question would be, which would be more preferable from
an application standpoint? Efficiency of the program vs.
Functionality vs. Ease to Create?
 
I find it FAR FAR easier to simply use the mouse to drag and drop.

When you get the hang of this, you can create some rather serious menus of
rather large complexity in a VERY short time. Trying to code the same thing
in VBA code is way too much work.

As far as functionality, the only difference is that you do need code for
when you create check box, list box, or combo box menu items.

For general menu trees that go a few levels deep, you can just use the
mouse, and drag and drop. I never needed to use code to create my menus. So,
unless you have some exceptions, I see no need to use code to create the
menus.

I certainly do have the menu bars call my own custom code, but that is a
very different issue from using code to create the menu bars.

I do certainly think that using menu bars can be a great help in user
friendliness. You can read my comments and see some screen shots of
ms-access menu bars at:

http://www.attcanada.net/~kallal.msn/Articles/UseAbility/UserFriendly.htm
 
Can you set up drop down menus directly into your own database that would be specifc to tasks within your structure? How do you hide the menus of the program (Access) etc.
 
Yes, you can create and setup your own menu system, and hide the ms-access
system.

In fact, I recommend that you do this. All of the settings for hiding and
setting up ms-access to run with the ms-access interface hidden can be found
in the tools->start-up options. You don't need code set this up, but only
change the settings in tools start-up, and of course make your own menu
bars..

If you are looking for a simple working example of a application with the
access interface hidden using the tools->start-up options, then try
downloading the 3rd example at the following web page.

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
 
Back
Top