Bill,
I was wondering if you could do this without using the macros, they end up
being the only macros in the application.
Hopefully you can do this just with VBA.
Cheers,
Stuart
My Signature
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Saturday, 31 March 2012 1: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
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Stuart
Luckman
> Sent: Friday, 30 March 2012 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
> <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%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 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>
> <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%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: 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>
> <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%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 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>
> <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%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: 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>
> <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%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>
> <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>
> <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%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>
> <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>
> <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]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar