pull down menu in Access-VBA

G

Gerd Sechting

I am working at the field of database developing.
The usual way to create a application with Access and VBA
is to put command controls onto a form.
With the command controls you connect a event procedure
with VBA code.
That is the same as with Visual Basic 6.

My problem is that the command controls are a little bit
clumsy and if you have to put a lot of them onto the form
it is very complex.
Visual Basic 6 is using an Menu editor (Menu Extras / Menu
editor). You can create there pull down menus with sub
menus and you can spare a lot of space on the form.

If the user run this application he or she can use these
pull down menus like in Windows itself.
My question is:
Is there any solution for this problem in VBA like it is
in Visual Basic 6?

If you have a solution for this problem please let me know.

Thanks.
Gerd

Gerd Sechting
(e-mail address removed)
Neuruppin
Germany
 
D

Daniel Plomp

It is very easy to use the Office Object Model to make
commandbars, shortcutmenus, menubars. You can do it by
drag and drop buttons in new menus or you can do it
programmaticaly in VBA.

The way I do it is I build up a table and use a function
to create the shortcutmenus. All features are accessible:
enabled, faceid, text etc.

Just make a reference to the Office .dll (mso.dll) in
your references and check the object browser for
information how to program.

Success
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top