Stuart, Thanks so much. The particular user who initiated this need (after well - I had to lock the db down and all...) reported that it worked well. I told him someone out there in the world named Stuart was the real benefactor.
Have a wonderful day all. It's FRIDAY!
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 Bill Mosca
Sent: Friday, March 30, 2012 7:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Run time and right clicking
Stuart -
Ah HA! Macro Name has been replaced with Sub Macro. I guess that makes sense seeing how macros are gradually making their way into the VBA World for Dummies. Now a macro name is a sub routine.
Thanks for giving me a sample, Stuart. If I get some time I'll poke around in my copy of Access 2010 Inside Out to see how to make a real context menu without macros called to expose them.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Luckman" <stuartluckman@...> wrote:
>
> Liz/Bill,
>
>
>
> I have uploaded an example which works on my machine.
>
> Hope it all works for you.
>
>
>
> Cheers,
>
> Stuart
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Stuart Luckman
> Sent: Friday, 30 March 2012 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
>
>
>
>
> Hi Bill,
>
> I'm using 2007, I've never used 2003.
>
> When you have the macro open in design view, click on the design ribbon at
> the top and in the Show/Hide group their is Show all actions, Macro Names,
> Conditions, Arguments.
>
> There you click on Macro Names.
>
> I'm no pro, so I'm not great at explaining . . . I'll try to get an example
> posted.
>
> Cheers,
>
> Stuart
>
> My Signature
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Friday, 30 March 2012 10:32 AM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Hi Stuart
>
> I don't see a macro name column and can't find a way to expose it like you
> could
> in 2003.
>
> Regards,
>
> Bill
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Stuart
> Luckman
> Sent: Thursday, March 29, 2012 1:42 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Hi Liz/Bill,
>
> I am using Access 2007 but I forgot one part of the step.
>
> In the FlitMenuFunc macro add the Macro Name: Filter and Sort
>
> Otherwise it looks like you have nothing to click on.
>
> Sorry it took so long replying, I'm in Australia so when you guys were
> chatting I was sleeping.
>
> Cheers,
>
> Stuart
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz
> Ravenwood
> Sent: Friday, 30 March 2012 4:22 AM
> To: 'MS_Access_Professionals@yahoogroups.com
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Thanks Bill. I appreciate the validity.
>
> 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%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Thursday, March 29, 2012 10:18 AM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Liz
>
> I followed Stuart's instructions and I get what you get: a blank box. Maybe
> Stuart was working with Access 2003 or earlier and this isn't translating in
> 2007 or 2010.
>
> Maybe someone can step in and give us another way.
>
> Regards,
>
> Bill
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz
> Ravenwood
> Sent: Thursday, March 29, 2012 9:31 AM
> To: 'MS_Access_Professionals@yahoogroups.com
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Bill. I did this and when I open up the accdr, I don't see any menu nor have
> any
> response from my right clicking on the form.
>
> 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%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Thursday, March 29, 2012 9:18 AM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Run time and right clicking
>
> Liz
>
> I'll let Stuart continue with this topic, but I thought I'd interject this:
>
> Runtime has no menus except the very limited File menu. No context menus.
> None.
> Nadda.
>
> You have to build all the custom menus, including context (right-click)
> menus,
> custom toolbars (or Ribbons if in 2007/2010).
>
> To see what your runtime users will see use:
>
> 1. If file is MDB - the /runtime switch in a shortcut to open the database
> as in:
>
> "C:\Program Files\Microsoft Office\Office11\msaccess.exe" /runtime
> "YourDBFullPath"
>
> 2. If accdb change file extension to accdr
>
> Regards,
>
> Bill
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz
> Ravenwood
> Sent: Wednesday, March 28, 2012 3:59 PM
> To: 'MS_Access_Professionals@yahoogroups.com
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.com>
> <mailto:%27MS_Access_Professionals%40yahoogroups.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.
>
> [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.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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.
Tidak ada komentar:
Posting Komentar