Creating Access menus using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Harbaugh - 30 Jan 2006 20:45 GMT

I want to create custom menus in an Access XP database using VBA. One of
the menus I need to create will open selected forms, queries, and reports
directly off of the menu. Using the Customize command (not using VBA) I
have added forms and reports to menus but I can not figure out how to create
this same functionality using VBA. Can anyone assist me? Thanks.

Jim Harbaugh

Reply to this Message

Alex Dybenko - 31 Jan 2006 06:48 GMT

Hi,
look at VBA help for commandbar object - you will find several samples. Do
not forget to add reference to office 10 library

I also made a building toolbar sample (which is actually same thing as
menu) here:
http://www.pointltd.com/Downloads/Details.asp?dlID=19

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I want to create custom menus in an Access XP database using VBA. One of
>the menus I need to create will open selected forms, queries, and reports
[quoted text clipped - 3 lines]
>
> Jim Harbaugh

Reply to this Message