Hi Groupies:

I'm not sure which newsgroup this question belongs to, sorry.

I have an Access 2003 database that was built on my Vista laptop. This
laptop also has Access 2007 installed but that version has not been used at
all to work with this database. My other computer has Windows XP and only
has Access 2003 installed.

In a couple of forms I have combo boxes that are used for searches. On my
Vista machine, these searches work fine, on my XP machine, the searches
work, but no data is "visible" when you push the down arrow. The list still
shows the correct number of rows as if the data was there, but no words show
up so you have to guess at what you are selecting.

The query behind the search boxes works fine and if you try the query by
itself all of the data shows up properly.

Not realizing what was going on, I spent a couple of hours trying to fix the
searches on my XP machine. I changed formatting, rebuilt the query,
everything I could think of. There was no way that I could make this thing
work on XP yet no problems on Vista.

What is the deal????
Any insight?......Anybody.......

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

Re: Access 2003 database inconsistent behaviour between Vista and XP by Mark

Mark
Fri May 09 09:10:08 PDT 2008

The 'common controls' dll for that in Access 07 is probably different from
the one in 03. I would locate the comctl32.dll used by Access 07, and put it
in the path for your search dialog in XP (not system32, but the Access .exe
folder.) You might also accomplish this by installing the Runtime files for
Access 07.
Access 2007 Download: Access Runtime:
http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dd9ae78d9-9dc6-4b38-9fa6-2c745a175aed%26DisplayLang%3den
--
Was this helpful? Then click the Ratings button. Voting helps the web
interface.
http://www.microsoft.com/wn3/locales/help/help_en-us.htm#RateAPostAsAnswer
Mark L. Ferguson
.

"CJ" <private@newsgroups.com> wrote in message
news:20B7A98C-2758-4183-B504-EE43AA9132EC@microsoft.com...
> Hi Groupies:
>
> I'm not sure which newsgroup this question belongs to, sorry.
>
> I have an Access 2003 database that was built on my Vista laptop. This
> laptop also has Access 2007 installed but that version has not been used
> at all to work with this database. My other computer has Windows XP and
> only has Access 2003 installed.
>
> In a couple of forms I have combo boxes that are used for searches. On my
> Vista machine, these searches work fine, on my XP machine, the searches
> work, but no data is "visible" when you push the down arrow. The list
> still shows the correct number of rows as if the data was there, but no
> words show up so you have to guess at what you are selecting.
>
> The query behind the search boxes works fine and if you try the query by
> itself all of the data shows up properly.
>
> Not realizing what was going on, I spent a couple of hours trying to fix
> the searches on my XP machine. I changed formatting, rebuilt the query,
> everything I could think of. There was no way that I could make this thing
> work on XP yet no problems on Vista.
>
> What is the deal????
> Any insight?......Anybody.......
>
> --
> Thanks for taking the time!
>
> CJ
> ---------------------------------------------------------
> Know thyself, know thy limits....know thy newsgroups!


Re: Access 2003 database inconsistent behaviour between Vista and XP by George

George
Fri May 09 10:05:45 PDT 2008



Check Microsoft/Office Update. I bet your XP machine has Office 2003 SP3
installed but not the hotfix (and your Vista machine has either both or
neither).

What you describe was a problem created by SP3 and subsequently "fixed".
http://support.microsoft.com/kb/945674/en-us

--
HTH,
George


"Mark L. Ferguson" <MarkLFerguson@discussions.microsoft.com> wrote in
message news:3A397E3E-0E8A-483C-8178-0313CC51363D@microsoft.com...
> The 'common controls' dll for that in Access 07 is probably different from
> the one in 03. I would locate the comctl32.dll used by Access 07, and put
> it in the path for your search dialog in XP (not system32, but the Access
> .exe folder.) You might also accomplish this by installing the Runtime
> files for Access 07.
> Access 2007 Download: Access Runtime:
> http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dd9ae78d9-9dc6-4b38-9fa6-2c745a175aed%26DisplayLang%3den
> --
> Was this helpful? Then click the Ratings button. Voting helps the web
> interface.
> http://www.microsoft.com/wn3/locales/help/help_en-us.htm#RateAPostAsAnswer
> Mark L. Ferguson
> .
>
> "CJ" <private@newsgroups.com> wrote in message
> news:20B7A98C-2758-4183-B504-EE43AA9132EC@microsoft.com...
>> Hi Groupies:
>>
>> I'm not sure which newsgroup this question belongs to, sorry.
>>
>> I have an Access 2003 database that was built on my Vista laptop. This
>> laptop also has Access 2007 installed but that version has not been used
>> at all to work with this database. My other computer has Windows XP and
>> only has Access 2003 installed.
>>
>> In a couple of forms I have combo boxes that are used for searches. On my
>> Vista machine, these searches work fine, on my XP machine, the searches
>> work, but no data is "visible" when you push the down arrow. The list
>> still shows the correct number of rows as if the data was there, but no
>> words show up so you have to guess at what you are selecting.
>>
>> The query behind the search boxes works fine and if you try the query by
>> itself all of the data shows up properly.
>>
>> Not realizing what was going on, I spent a couple of hours trying to fix
>> the searches on my XP machine. I changed formatting, rebuilt the query,
>> everything I could think of. There was no way that I could make this
>> thing work on XP yet no problems on Vista.
>>
>> What is the deal????
>> Any insight?......Anybody.......
>>
>> --
>> Thanks for taking the time!
>>
>> CJ
>> ---------------------------------------------------------
>> Know thyself, know thy limits....know thy newsgroups!
>



Re: Access 2003 database inconsistent behaviour between Vista and XP by CJ

CJ
Fri May 09 13:46:33 PDT 2008

Fantastic, that was it!

I had SP3 on both machines but neither had the HotFix. I don't have updates
auto installed but I don't recall seeing anything about this fix from MS.
Or, there may have been so many that I quit paying attention to them.

Have a great weekend.
--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

"George Nicholson" <GeorgeNJunk@Junkmsn.com> wrote in message
news:u8qLubfsIHA.5872@TK2MSFTNGP04.phx.gbl...
>
> Check Microsoft/Office Update. I bet your XP machine has Office 2003 SP3
> installed but not the hotfix (and your Vista machine has either both or
> neither).
>
> What you describe was a problem created by SP3 and subsequently "fixed".
> http://support.microsoft.com/kb/945674/en-us
>
> --
> HTH,
> George
>
>
> "Mark L. Ferguson" <MarkLFerguson@discussions.microsoft.com> wrote in
> message news:3A397E3E-0E8A-483C-8178-0313CC51363D@microsoft.com...
>> The 'common controls' dll for that in Access 07 is probably different
>> from the one in 03. I would locate the comctl32.dll used by Access 07,
>> and put it in the path for your search dialog in XP (not system32, but
>> the Access .exe folder.) You might also accomplish this by installing the
>> Runtime files for Access 07.
>> Access 2007 Download: Access Runtime:
>> http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dd9ae78d9-9dc6-4b38-9fa6-2c745a175aed%26DisplayLang%3den
>> --
>> Was this helpful? Then click the Ratings button. Voting helps the web
>> interface.
>> http://www.microsoft.com/wn3/locales/help/help_en-us.htm#RateAPostAsAnswer
>> Mark L. Ferguson
>> .
>>
>> "CJ" <private@newsgroups.com> wrote in message
>> news:20B7A98C-2758-4183-B504-EE43AA9132EC@microsoft.com...
>>> Hi Groupies:
>>>
>>> I'm not sure which newsgroup this question belongs to, sorry.
>>>
>>> I have an Access 2003 database that was built on my Vista laptop. This
>>> laptop also has Access 2007 installed but that version has not been used
>>> at all to work with this database. My other computer has Windows XP and
>>> only has Access 2003 installed.
>>>
>>> In a couple of forms I have combo boxes that are used for searches. On
>>> my Vista machine, these searches work fine, on my XP machine, the
>>> searches work, but no data is "visible" when you push the down arrow.
>>> The list still shows the correct number of rows as if the data was
>>> there, but no words show up so you have to guess at what you are
>>> selecting.
>>>
>>> The query behind the search boxes works fine and if you try the query by
>>> itself all of the data shows up properly.
>>>
>>> Not realizing what was going on, I spent a couple of hours trying to fix
>>> the searches on my XP machine. I changed formatting, rebuilt the query,
>>> everything I could think of. There was no way that I could make this
>>> thing work on XP yet no problems on Vista.
>>>
>>> What is the deal????
>>> Any insight?......Anybody.......
>>>
>>> --
>>> Thanks for taking the time!
>>>
>>> CJ
>>> ---------------------------------------------------------
>>> Know thyself, know thy limits....know thy newsgroups!
>>
>
>