How to create a menu.

How to create a menu.

Post by T3JsYW5kb » Thu, 05 Apr 2007 09:06:00


Hi, I wonder if I can create in Access 2003 this kind of windows menu (File
Edit View) with a drop down list, but with the names of the different modules
(Production, Accounting, Human Resources) and a drop down with the different
options per module.

Thanks
 
 
 

How to create a menu.

Post by Rick Brand » Thu, 05 Apr 2007 09:12:16


Sure. Just add the "New Menu" item to a menu or toolbar and give it the name of
a module and then provide under that any functions you want to run. If you
meant that you want something to automatically generate such a menu then I don't
know of any way to do that.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

 
 
 

How to create a menu.

Post by T3JsYW5kb » Thu, 05 Apr 2007 11:20:01

Hi Rick I already created a new Menu bar, I called it Computer 1 but I
haven't been able to include any option in the drop down list, I wonder If
you have any Idea how can I do this.

Thanks
 
 
 

How to create a menu.

Post by Rick Brand » Thu, 05 Apr 2007 21:53:45


What sort of "drop down list"? You can add a sub-menu and than simply drag
more items onto that or you can try to use what looks like a ComboBox. The
latter can only be populated from code. I don't have a code sample handy
but if you Google these groups you should find an example.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
 
 
 

How to create a menu.

Post by George Nic » Fri, 06 Apr 2007 01:48:01

The following specifies Excel in the title, but it really applies across all
Office products prior to Office 2007's "ribbon".

http://www.yqcomputer.com/
How to customize menus and menu bars in Excel

Contains VBA code samples for pretty much anything you might want to do with
menus.

HTH,