Oky doky Stuart. Now how do I actually run this? I tried the right click from the accdr and I still get the little blank square box. Am I missing something?
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 Liz Ravenwood
Sent: Thursday, March 29, 2012 7:50 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: 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.
------------------------------------
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.
Tidak ada komentar:
Posting Komentar