How to create a menu.

[Guest]

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

 

[Rick Brandt]

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

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.

 

[Guest]

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

 

[Rick Brandt]

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.

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.

 

[George Nicholson]

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

http://support.microsoft.com/kb/830502/en-us
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,