[AccessD] Combo Box not Autocompleting

...wags ...is the client's A2k3 a full install or a runtime? ...if full, 
have you decompiled/compiled on that system? ...if runtime, does the xp 
version work on your system with the runtime switch set?

William Hindman

----- Original Message ----- 
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, December 04, 2006 12:31 AM
Subject: Re: [AccessD] Combo Box not Autocompleting


> Nothing unusual.  It is an ID field automatically generated.  Because
> the database is so basic and has a lifespan of about three weeks, the
> data table is in the same file as the form.  The same data was copied
> to the client machine as on my machine.  No records have been added -
> only some fields edited.
>
> David
>
> At 4/12/2006, you wrote:
>>Well, it was a pure shot in the dark.  Even a blind squirrel finds a nut
>>once in a while.
>>
>>How about the bound column?  Anything out of the ordinary there?
>>
>>Rocky
>>
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
>>Sent: Sunday, December 03, 2006 6:38 PM
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] Combo Box not Autocompleting
>>
>>Thank for the reply Rocky,
>>
>>The database wasn't recreated in 2003.  I just copied the XP file
>>onto the client's computer.
>>
>>The only thing that needed adjusting was a reference to Microsoft
>>Offic XP Web Components (Not sure what that was there for).  I
>>removed the reference in both versions of the database - the XP
>>version still works fine, the 2003 still doesn't.
>>
>>I also tried recreating the combo box direct in the 2003 copy but it
>>behaved the same way (IE no auto complete).
>>
>>David
>>
>>At 4/12/2006, you wrote:
>> >On the theory that there's some difference in the combo box that you
>>dropped
>> >into the original XP mdb and the combo box that you create in A2K3, I
>>wonder
>> >what would happen if you deleted the box and re-created it on the A2K3
>> >system?
>> >
>> >Rocky
>> >
>> >
>> >-----Original Message-----
>> >From: accessd-bounces at databaseadvisors.com
>> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
>> >Sent: Sunday, December 03, 2006 3:05 PM
>> >To: accessd at databaseadvisors.com
>> >Subject: [AccessD] Combo Box not Autocompleting
>> >
>> >Group,
>> >
>> >I have developed a simple database in Access XP (One table, one
>> >form).  On the form is a combo box that shows all the records on the
>> >form.  The bound field is a number (long)
>> >
>> >When I start entering a number the combo box auto completes it with
>> >the first match from the list.
>> >
>> >When I copy the database to another computer with Access 2003 on it
>> >(mu client's computer) the combo box does not auto
>> >complete.  Entering a full number and pressing the enter key returns
>> >an error message "The Text entered is not an item on the
>> >list".  However, I can scroll down the actual list and select the item.
>> >
>> >Has anyone come across this and have a fix?
>> >
>> >Regards
>> >
>> >David Emerson
>> >Dalyn Software Ltd
>> >Wellington, New Zealand
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>--
>>No virus found in this incoming message.
>>Checked by AVG Free Edition.
>>Version: 7.5.430 / Virus Database: 268.15.6/566 - Release Date: 12/3/2006
>>4:36 PM
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>