Not a problem Stuart. I ended up playing detective all morning and this afternoon with a strange issue where I had copied queries to other queries, changed a few things, and they kept getting twisted up with each other like someone was "out there" with a big "cosmic eggbeater" scrambling them together over and over again. I'm doing a compact and repair.
How is it down under today?
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: Thursday, March 29, 2012 1:42 PM
To: MS_Access_Professionals@yahoogroups.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@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, 30 March 2012 4:22 AM
To: 'MS_Access_Professionals@yahoogroups.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@yahoogroups.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>
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@yahoogroups.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> '
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@yahoogroups.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>
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@yahoogroups.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> '
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]
------------------------------------
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