David Emerson
newsgrps at dalyn.co.nz
Mon Dec 4 14:38:00 CST 2006
Ok, We created a new database, and were able to get it to work using a value list. We also were able to create a new form in the main database and get the value list combo to autocomplete. However, when we replicated the combo box in the new form using the query as the source, the autocomplete didn't work :-( I am trying to get hold of it so that I can do some tests for myself (so far it has been via giving instructions over the phone). David At 4/12/2006, you wrote: >">I also tried recreating the combo box direct in the 2003 copy but it > >behaved the same way (IE no auto complete)." > >If you create a new form and create a combo box with a different data source >does it behave the same way? With the same data source, does it behave the >same way? IOW, do all combo boxes in this installation of A2K3 fail on the >auto complete? > >Is Tools-->Options-->General-->Track Name Autocorrect info turned off? >Don't see why it should matter but that seems to cause a lot of random >problems. > >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 9:32 PM >To: Access Developers discussion and problem solving >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 > >-- >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