I love this kind of thing, in the days of Ribbon Functionality, the easiest way to get Context Menus back is to use those methods we had in Access 2.0 (may have been there in 1.1 as well but I can't remember.)
I use the Commandbars Objects in order to create and manipulate Context Menus so if Stuart's "blast from the past" doesn't get you where you want/need to be, maybe my nearly as old methods will help.
(Apropos Commandbars and Ribbons, don't poke me too hard otherwise I'll start ranting again... the Ribbon is partly available within the old Commandbars structure... :-D )
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Luckman" <stuartluckman@...> wrote:
>
> Hi Liz,
>
>
>
> I don't know if this is the best way but here is what I did (I found this on
> the net somewhere I can't remember, might have been here??):
>
>
>
> Create a Function in a module:
>
>
>
> Function FiltMen()
>
>
>
> On Error Resume Next
>
>
>
> CommandBars.ExecuteMso ("FiltersMenu")
>
>
>
> End Function
>
>
>
> Then create a macro I called FiltMenuFunc:
>
>
>
> Action: RunCode Arguments: FiltMen()
>
>
>
> Then created another macro I called FiltMenu:
>
>
>
> Action: AddMenu
>
>
>
> Menu Name: MyRightClick
>
> Menu Maacro Name: FiltMenuFunc
>
> Status Bar Text: My Edit
>
>
>
> Then on the form you want it on go to the form properties:
>
>
>
> Shortcut Menu: Yes
>
>
>
> Shortcut Menu Bar: FiltMenu
>
>
>
> You right click on any field and it gives you most of the filtering
> functions.
>
>
>
> Hope this helps
>
>
>
> Cheers,
>
> Stuart
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> Sent: Thursday, 29 March 2012 9:59 AM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Subject: [MS_AccessPros] Run time and right clicking
>
>
>
>
>
> Greetings pros, I just learned that creating a run time version (accdr)
> loses right click capability.
>
> I searched on line and see that there was some bug that was fixed but not in
> the run time version... is that correct?
>
> Does anyone know how to give someone right click access or if they know that
> I'm missing something here?
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you
> are not the intended recipient, please contact the sender by reply e-mail
> and destroy all copies of the original message.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar