By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,925 Members | 732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,925 IT Pros & Developers. It's quick & easy.

Access 2007 Runtime - Right Clicking issue

P: n/a
Converted an A2003 system to A2007, on testing founf out that right-
click to bring up a shortcut menu on a combo box didn't work if the
combo box was in a subform.

Found out that this was a known bug and applied the relevant hotfix.
Voila!

However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?

Help - right-clicking is a key component of my application.

Cheers
Reg

Oct 27 '07 #1
Share this Question
Share on Google+
12 Replies


P: n/a
ARC
Try to get one user to install the hotfix as well, then see if that does it.

I wonder if they've built in a version check in the runtime that will let
the user now when the runtime needs to be updated? That would be nice!
"Reg (Lincolnshire)" <re*@solutionj.co.ukwrote in message
news:11*********************@50g2000hsm.googlegrou ps.com...
Converted an A2003 system to A2007, on testing founf out that right-
click to bring up a shortcut menu on a combo box didn't work if the
combo box was in a subform.

Found out that this was a known bug and applied the relevant hotfix.
Voila!

However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?

Help - right-clicking is a key component of my application.

Cheers
Reg
Oct 27 '07 #2

P: n/a
"Reg (Lincolnshire)" <re*@solutionj.co.ukwrote:
>However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?
Not sure about A2007 but in A2003 even if you have SP2 installed the runtime creates
a package that contains msaccess.exe without any patches. Furthermore, in my
admittedly limited testing, Microsoft Update doesn't realize that the Access runtime
isn't installed and thus doesn't offer to update it.

Therefore I suspect you are going to need to figure out how to include the hotfix in
your package, if the MS EULA will allow you, and to "chain" (which is the correct
term I think) the hotfix so it runs after the runtime install.

Finally A2007 seems to be a bit too close to the bleeding edge of technology for my
comfort zone.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 27 '07 #3

P: n/a
ARC
By the way, there is another issue broken in runtime, and that is the
"OutputTo / Export" command, which is a biggie for me in terms of e-mailing
forms. I understand they're working on a patch, so hopefully they'll be
updating the Access2007Runtime.exe soon! I bet it would include the fix for
the above, as well as the right-clicks for subforms.
"Reg (Lincolnshire)" <re*@solutionj.co.ukwrote in message
news:11*********************@50g2000hsm.googlegrou ps.com...
Converted an A2003 system to A2007, on testing founf out that right-
click to bring up a shortcut menu on a combo box didn't work if the
combo box was in a subform.

Found out that this was a known bug and applied the relevant hotfix.
Voila!

However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?

Help - right-clicking is a key component of my application.

Cheers
Reg
Oct 27 '07 #4

P: n/a
Reg (Lincolnshire) wrote:
Converted an A2003 system to A2007, on testing founf out that right-
click to bring up a shortcut menu on a combo box didn't work if the
combo box was in a subform.

Found out that this was a known bug and applied the relevant hotfix.
Voila!

However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?

Help - right-clicking is a key component of my application.

Cheers
Reg
Is it a custom shortcut menu? The runtime has never supported built in
menus of any kind (including right-click menus). It will work with custom
ones though.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Oct 27 '07 #5

P: n/a
On Oct 27, 6:35 pm, "Rick Brandt" <rickbran...@hotmail.comwrote:
Reg (Lincolnshire) wrote:
Converted an A2003 system to A2007, on testing founf out that right-
click to bring up a shortcut menu on a combo box didn't work if the
combo box was in a subform.
Found out that this was a known bug and applied the relevant hotfix.
Voila!
However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?
Help - right-clicking is a key component of my application.
Cheers
Reg

Is it a custom shortcut menu? The runtime has never supported built in
menus of any kind (including right-click menus). It will work with custom
ones though.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -
Hi Rick,

Thanks for replying. Not totally sure what you mean though. I created
a menu from scratch that is linked to a particular combo box such that
right-clicking the combo box brings up the menu. That does work in
A2007 provided the combo box is not on a subform.

Reg

Oct 28 '07 #6

P: n/a
On Oct 27, 3:51 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
"Reg (Lincolnshire)" <r...@solutionj.co.ukwrote:
However, I have now tested the system on a machine with only A2007
runtime installed, and the problem still exists. Why did Microsoft not
fix the problem in the runtime exe as well, or am I missing something
(quite possible!!)?

Not sure about A2007 but in A2003 even if you have SP2 installed the runtime creates
a package that contains msaccess.exe without any patches. Furthermore, in my
admittedly limited testing, Microsoft Update doesn't realize that the Access runtime
isn't installed and thus doesn't offer to update it.

Therefore I suspect you are going to need to figure out how to include the hotfix in
your package, if the MS EULA will allow you, and to "chain" (which is the correct
term I think) the hotfix so it runs after the runtime install.

Finally A2007 seems to be a bit too close to the bleeding edge of technology for my
comfort zone.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Hi Tony,

Thanks again.

Just for fun I tried applying the relevant hotfix to the machine that
only has A2007 runtime loaded on it, but I just get a message saying
tha there is no software running for which the hotfix is applicable. I
don't know if that rules out your chaining idea, but to be honest
that's probably beyond me anyway.

I totally agree with you about A2007's current status. I'm kicking
myself for not sussing out what people's experience of it has been
before starting out on this upgrade.

Reg

Oct 28 '07 #7

P: n/a
On Oct 28, 10:51 am, "Reg (Lincolnshire)" <r...@solutionj.co.uk>
wrote:
On Oct 27, 3:51 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:


"Reg (Lincolnshire)" <r...@solutionj.co.ukwrote:
>However, I have now tested the system on a machine with only A2007
>runtime installed, and the problem still exists. Why did Microsoft not
>fix the problem in the runtime exe as well, or am I missing something
>(quite possible!!)?
Not sure about A2007 but in A2003 even if you have SP2 installed the runtime creates
a package that contains msaccess.exe without any patches. Furthermore, in my
admittedly limited testing, Microsoft Update doesn't realize that the Access runtime
isn't installed and thus doesn't offer to update it.
Therefore I suspect you are going to need to figure out how to include the hotfix in
your package, if the MS EULA will allow you, and to "chain" (which is the correct
term I think) the hotfix so it runs after the runtime install.
Finally A2007 seems to be a bit too close to the bleeding edge of technology for my
comfort zone.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Hi Tony,

Thanks again.

Just for fun I tried applying the relevant hotfix to the machine that
only has A2007 runtime loaded on it, but I just get a message saying
tha there is no software running for which the hotfix is applicable. I
don't know if that rules out your chaining idea, but to be honest
that's probably beyond me anyway.

I totally agree with you about A2007's current status. I'm kicking
myself for not sussing out what people's experience of it has been
before starting out on this upgrade.

Reg- Hide quoted text -

- Show quoted text -
Interesting....

I copied the file MSACCESS.EXE from my development A2007 machine to
the machine running A2007 runtime. The right-clicking issue is solved!
I guess in this instance the hotfix applied a change to the .exe
itself.

I can't see a problem with this from the licensing perspective as the
file exists in both the full and runtime versions.

Comments anyone? Dangerous? Stupid? Worth trying? Illegal?

Reg

Oct 28 '07 #8

P: n/a
Reg (Lincolnshire) wrote:
Hi Rick,

Thanks for replying. Not totally sure what you mean though. I created
a menu from scratch that is linked to a particular combo box such that
right-clicking the combo box brings up the menu. That does work in
A2007 provided the combo box is not on a subform.
I re-read your original post and saw nothing that suggested it was a "menu from
scratch" and just wanted to point out that lack of built in menu support is a
major factor when using the runtime.

The runtime (all versions) only supports custom menus that the developer adds to
the application. Many developers who use the runtime for the first time expect
all the standard menus to be available. If yours was a custom menu then the
issue is not relevent.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Oct 28 '07 #9

P: n/a
"Reg (Lincolnshire)" <re*@solutionj.co.ukwrote:
>Just for fun I tried applying the relevant hotfix to the machine that
only has A2007 runtime loaded on it, but I just get a message saying
tha there is no software running for which the hotfix is applicable. I
don't know if that rules out your chaining idea, but to be honest
that's probably beyond me anyway.
Aw cr*p. Now that bites. Ok, can you post the URL or the KB number of the hotfix
and I'll report that to MS.
>I totally agree with you about A2007's current status. I'm kicking
myself for not sussing out what people's experience of it has been
before starting out on this upgrade.
Hindsight.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 29 '07 #10

P: n/a
"Reg (Lincolnshire)" <re*@solutionj.co.ukwrote:
>Interesting....

I copied the file MSACCESS.EXE from my development A2007 machine to
the machine running A2007 runtime. The right-clicking issue is solved!
I guess in this instance the hotfix applied a change to the .exe
itself.

I can't see a problem with this from the licensing perspective as the
file exists in both the full and runtime versions.

Comments anyone? Dangerous? Stupid? Worth trying? Illegal?
Dangerous but probably acceptable. Do you know if there were any other files which
were updated in that hotfix? If yes then all those files need to be copied across to
the target system. If those files are DLLs, especially if in the Windows System32
folder then the Wnidows Protection (whatever it's called) might wipe out your dlls
and replace them with older "correct" versions.

That is this approach would work until the next SP. Which would be updating lots of
DLLs and such. Thus you'd have to copy all the files. Now that shouldn't be a
problem as the hotfix should be included in the SP.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 29 '07 #11

P: n/a
On Oct 29, 1:48 am, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
"Reg (Lincolnshire)" <r...@solutionj.co.ukwrote:
Just for fun I tried applying the relevant hotfix to the machine that
only has A2007 runtime loaded on it, but I just get a message saying
tha there is no software running for which the hotfix is applicable. I
don't know if that rules out your chaining idea, but to be honest
that's probably beyond me anyway.

Aw cr*p. Now that bites. Ok, can you post the URL or the KB number of the hotfix
and I'll report that to MS.
I totally agree with you about A2007's current status. I'm kicking
myself for not sussing out what people's experience of it has been
before starting out on this upgrade.

Hindsight.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Here you go Tony.

http://support.microsoft.com/kb/935875/en-us

Cheers
Reg

Oct 29 '07 #12

P: n/a
On Oct 28, 12:24 pm, "Rick Brandt" <rickbran...@hotmail.comwrote:
Reg (Lincolnshire) wrote:
Hi Rick,
Thanks for replying. Not totally sure what you mean though. I created
a menu from scratch that is linked to a particular combo box such that
right-clicking the combo box brings up the menu. That does work in
A2007 provided the combo box is not on a subform.

I re-read your original post and saw nothing that suggested it was a "menu from
scratch" and just wanted to point out that lack of built in menu support is a
major factor when using the runtime.

The runtime (all versions) only supports custom menus that the developer adds to
the application. Many developers who use the runtime for the first time expect
all the standard menus to be available. If yours was a custom menu then the
issue is not relevent.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Gotcha. My misunderstanding. Thanks Rick.

Reg

Oct 29 '07 #13

This discussion thread is closed

Replies have been disabled for this discussion.