ACCESS FEED: RE: [MS_AccessPros] Run time and right clicking

Kamis, 29 Maret 2012

RE: [MS_AccessPros] Run time and right clicking

You're brilliant Stuart. I'm going to try this.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Stuart Luckman
Sent: Wednesday, March 28, 2012 7:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Run time and right clicking

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]

------------------------------------

Yahoo! Groups Links

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.