[AccessD] A2010: Create custom popup menu to run custom function

philippe pons phpons at gmail.com
Fri Aug 17 04:55:04 CDT 2012


Gustav,

Here is a link where you can download a events.xlsm Excel workbook with a
code to create a popup menu.
I guess it could be used in access the same way.

http://gallery.technet.microsoft.com/Excel-2010-Code-Example-ad66f451

Regards,
Philippe

2012/8/17 Gustav Brock <gustav at cactus.dk>

> Hi Charlotte
>
> No, unfortunately not, that link is about the ribbon.
> My popup menu will be completely separated from that.
>
> /gustav
>
>
> >>> charlotte.foust at gmail.com 17-08-12 5:28 >>>
> I haven't done it in years in Access.   Does this help?
>
> http://www.accessribbon.de/en/index.php?FAQ:9
>
> Popup menus seemed to have devolved into context sensitive ribbons, which
> aren't the same thing at all.
>
> Charlotte
>
> On Thu, Aug 16, 2012 at 10:19 AM, Gustav Brock <gustav at cactus.dk> wrote:
>
> > Hi all
> >
> > So this would be one of the tough questions at a job interview?
> >
> > Has no one created a popup-menu?
> >
> > /gustav
> >
> >
> > >>> gustav at cactus.dk 15-08-12 18:23 >>>
> > Hi all
> >
> > I need some help with this.
> >
> > I've found out that you need a reference to the Office Object Library and
> > then create a "commandbar" to achieve this, but the code examples I can
> > locate just adds standard Access/Office commands to the menu using
> "secret"
> > values.
> >
> > My popup should be displayed when right-clicking the form outside the
> > controls.
> > It should contain a few menu entries, say:
> >
> >   Create New
> >   Reset
> >
> > When clicking one of these, a function of mine should be called, like:
> >
> >   CreateNewOrder()
> >   ClearOrder()
> >
> > No fancy icons or the like is needed.
> >
> > I've managed to create a shortcutmenu (macro) but, when I right-click, no
> > menu is shown - the macro is executed right away.
> >
> > /gustav
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list