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

Stuart

I'm using 2010. All that is in the Sho/Hide group is "Action Catalog" and "Show All Actions". I'll check out your sample to see if it exposes the Macro Name or if 2010 just did away with that.

Arg! I hate change with no explanation!

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Stuart Luckman" <stuartluckman@...> wrote:
>
> 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@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Friday, 30 March 2012 10:32 AM
> To: MS_Access_Professionals@yahoogroups.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@yahoogroups.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>
> 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@yahoogroups.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> '
> 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@yahoogroups.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>
> 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@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: 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> '
> 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@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 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>
> 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@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: 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> '
> 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]
>