Custom Menus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way for me to create menus of my own to store actions? I have
one form on which various actions may be performed using command buttons.
The number has become so copious that it is beginning to look cluttered with
command buttons and I would like a different approach. A combo box would be
my first approach, but if there is a more aesthetically pleasing method such
as customized menus, I would rather apply that.

Thank you in advance for your time.

Joe
 
Hi,
You could also create a table with 2 fileds. One is the Description (for
lack of the better word) and the other is the macro that will execute to do
your action.
 
JL, thanks for your response, but that is not really what I'm looking for.
The combo box that you wrote about is, in fact, what I will resort to barring
any aesthetically pleasing alternative (perhaps I was a bit unclear when I
wrote this earlier). I am wondering if there's any way to create a
customized menu, perhaps using VBA.
 
Menus are indeed a nice way to remove clutter....

You can make any custom menu call a public function (your code) by placing
the function name in the "on action" property of the menu you make.

=MyDelete()

The above would call a function named:

Public Function MyDelete

bla bla...

The above function code would thus just be placed in your forms code module.

Here is some example screens that I made in ms-access that use menus....

http://www.attcanada.net/~kallal.msn/Articles/UseAbility/UserFriendly.htm

And, here is a link on how to make menus:

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm
 
Alas! The links no longer work. :-{

Can anyone point me to the new addresses? I've poked around a bit, but not
found anything useful. . . . . . . .
 
Kari said:
Alas! The links no longer work. :-{

Can anyone point me to the new addresses? I've poked around a bit, but
not
found anything useful. . . . . . . .
Click to expand...

That article can be found here:

http://www.members.shaw.ca/AlbertKallal/Articles/UseAbility/UserFriendly.htm

Keep in mind the above article against only suggests some good ideas on how
to use menus, not actually had to build them. you can find some articles on
how to build custom menus here :

http://office.microsoft.com/en-ca/assistance/HP051890051033.aspx
 
Back
Top