By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,494 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 IT Pros & Developers. It's quick & easy.

Access 2000 Macro Menus

P: n/a
In Access 95/97 I used to be able to create pull down menus (File,Edit
...) from a macro. It seems there used to be some wizard for that.
However in Access 2000 it seems you have to build your menus by
customizing a toolbar. With this method you have to create a separate
macro for every single menu and sub menu. The old method would allow
me to include several menus (File/ print/ page setup ...) all within
one macro. Now it seems I have to create a macro for each sub menu
item. Is this correct? Is there another way. I can't seem to find
anything in the help file to suggest otherwise. Also what I am
actually calling in the menu is a macro that points to a vb function
(Runcode). It would be easier to link the menu directly to a piece of
code. Is that possible? Any help would be appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The old macro menus are from Access 1.0/2.0 Were they
preserved for backward compatibility in Access 95/98?
Lots of the remaining backward compatitibility stuff
for Access 2.0 was dropped from Access 2000.

Or:

Open a macro in design mode
right click on the caption of the macro window
select "Macro Names"
enter macro names into the macro names column.

These macro names may be used in your menus. They are
displayed in the drop down list of available macros,
organised by the name of the containing macro:
mcr_menus
mcr_menus.menu_A
mcr_menus.menu_B
etc.

also, yes, you can type a code function name into a menu
property, instead of selecting a macro, like this:
=myfunction()
or this
=myMenuFunction(1,"from menu item")
or this
=eval("myFunc()")

(david)

"Pete" <my*****@netzero.net> wrote in message
news:a3**************************@posting.google.c om...
In Access 95/97 I used to be able to create pull down menus (File,Edit
..) from a macro. It seems there used to be some wizard for that.
However in Access 2000 it seems you have to build your menus by
customizing a toolbar. With this method you have to create a separate
macro for every single menu and sub menu. The old method would allow
me to include several menus (File/ print/ page setup ...) all within
one macro. Now it seems I have to create a macro for each sub menu
item. Is this correct? Is there another way. I can't seem to find
anything in the help file to suggest otherwise. Also what I am
actually calling in the menu is a macro that points to a vb function
(Runcode). It would be easier to link the menu directly to a piece of
code. Is that possible? Any help would be appreciated.

Nov 13 '05 #2

P: n/a
Thanks. That helps now I don't have to create a dozen macro's. It's
also much faster to throw a prototype database together.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.