David Emerson
newsgrps at dalyn.co.nz
Mon Dec 4 14:35:51 CST 2006
The client's laptop is a full version. However, it is a hired one and they seem to have locked down the programs. 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). When I get it I will try decompile etc. David At 4/12/2006, you wrote: >...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 > > > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com