T
tricky300
Hi. Thanks to anyone who can help.
As far as I can tell Microsoft seem to want to discourage use of right click
in Access 2007. In 2003 using right click to do things like copy/paste or run
macros from a popup menu was easy. Now it seems this is no longer the case,
we are being 'guided' down the highly technical route of using the ribbon
(which I have started to get to grips with).
However right click seems so much more convenient. From research in the 2007
help pages it would seem that these popup menus can be created in vba however
there is very little sample code to help me understand what to do.
Presumably this code should be added in the form's open or load event? Can
anyone give me a sample to create a popup with 3 options to copy, paste and
run a macro? From there on I should be able to figure the rest out for
myself. Code to delete the popup on exiting the form might also be helpful.
One other problem I encountered during my unsuccessful experiments is that
some of the constants (e.g. msobarxxx) don't seem to be recognised even
though I have referenced the Microsoft Office v12.0 Object library.
As far as I can tell Microsoft seem to want to discourage use of right click
in Access 2007. In 2003 using right click to do things like copy/paste or run
macros from a popup menu was easy. Now it seems this is no longer the case,
we are being 'guided' down the highly technical route of using the ribbon
(which I have started to get to grips with).
However right click seems so much more convenient. From research in the 2007
help pages it would seem that these popup menus can be created in vba however
there is very little sample code to help me understand what to do.
Presumably this code should be added in the form's open or load event? Can
anyone give me a sample to create a popup with 3 options to copy, paste and
run a macro? From there on I should be able to figure the rest out for
myself. Code to delete the popup on exiting the form might also be helpful.
One other problem I encountered during my unsuccessful experiments is that
some of the constants (e.g. msobarxxx) don't seem to be recognised even
though I have referenced the Microsoft Office v12.0 Object library.