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 12 5394
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******** *************@5 0g2000hsm.googl egroups.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
"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/
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 Access2007Runti me.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******** *************@5 0g2000hsm.googl egroups.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
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
On Oct 27, 6:35 pm, "Rick Brandt" <rickbran...@ho tmail.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
On Oct 27, 3:51 pm, "Tony Toews [MVP]" <tto...@teluspl anet.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
On Oct 28, 10:51 am, "Reg (Lincolnshire)" <r...@solutionj .co.uk>
wrote:
On Oct 27, 3:51 pm, "Tony Toews [MVP]" <tto...@teluspl anet.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
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
"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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Wayne |
last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom
menu bar designer. Is it in the beta? Maybe I'm blind. The question
that comes to mind is: Will custom menu bars be the same height as they
were in previous versions or will they be the "ribbon" style that takes
up a huge portion of the screen?
Also when I use Access 2007 to open an Access 2003 database that has
custom menu bars they display as they did in Access...
|
by: ARC |
last post by:
Hello All,
I have a major application for quoting and invoicing that is written in
Access 97 (both front and back ends). I have a user base of over 300
customers, and currently I don't require that they have Access 97, as I use
the access 97 runtime scripts from Sagekey software. The main problems I've
seen with Access 97 are the built in e-mail support for sending reports.
Unless a user uses the MS Outlook 2000/XP method, they have to...
|
by: Neil |
last post by:
A client of mine likes some of the new bells and whistles in Access 2007,
and is thinking about converting our A03 format MDB to an A07 format file.
However, while some of the users have A07, many do not, and it's not clear
when they would get it. His thought was to use the upcoming Access 2007
runtime to allow the users who are still running Office 2003 to be able to
run the database.
While I use multiple versions of Access on my...
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might know one way or the other whether that was
true or not, or could point me to an article or help text that would. What I
have seen so far online and in Access 2007 help seems to confirm the above.
But that (or at least (b)) seems incredible that it...
|
by: ARC |
last post by:
I'm currently looking at the access developer extensions for creating an MSI
installer package for a 2007 runtime app. Couple of observations and
questions.
1) Doesn't look like we have the ability to set a packaged file to always
overwrite, or never overwrite, unless I'm missing something. This could be a
sticking point, as I would always want the program to overwrite on
re-installing, but NEVER the back end database. I have a few more...
| |
by: Alfred |
last post by:
Hi
In Access 2007 (the MDE) The taskbar displays Powered by Microsoft Access.
How can I remove it
Thanks
Alfred
|
by: Lou O |
last post by:
I have been using Access 2007 for a number of months and have
successfully deployed ACCDR files on many client machines.
The client machines have the "free" Access runtime version installed.
I recently installed SP1 for Office 2007 on my computer.
Now when I make an ACCDE file to distribute, I get an error on client
machines something like
"database is in an unrecognized format".
There seems to be a compatibility problem between Office...
|
by: Tony |
last post by:
I am continuing to develop an Access 2007 application which was
originally converted from Access 2003. In Access 2003 I was able to
disable the Access Close button in the top righthand corner of the
screen. I have been unable to find any way to disable this button in
Access 2007 and subsequently I have been forced to find ways to detect
and handle the situations after the Access Close button has been
clicked.
I have been largely...
|
by: ncsthbell |
last post by:
I have a dilemia, I have an application that I am having to make some changes to in order for it to run sucessfully under Runtime 2007. We are currently working on upgrading from 2000 to 2007. The users will be running the apps under 'Runtime Access 2007' Here is my dilema... This application is used as a 'stand alone', basically, my users get a copy of the 'master' database and enter their data specifically for one account, each account they...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |