pull down menu in Access-VBA

  • Thread starter Thread starter Gerd Sechting
  • Start date Start date
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
 
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
 
Back
Top