Jim Hewson
JHewson at karta.com
Fri Nov 3 16:22:10 CST 2006
I ran into the 64k limitation a couple of weeks ago. The combo box and list box are both limited. Had a little over 65K list of names... wouldn't show the last 1K or so. It wasn't very slow, but the users would not have found it except they wanted to find a name starting with Z. Jim jhewson at karta.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, November 03, 2006 4:17 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Strategies for populating combo boxes Cool! Good to know. And are you sure that combos are limited to 65K? I seem to remember actually running into the 32K limit, but it was awhile ago so don't sue me if I'm wrong. I do know that they slooowed waaaaaay doooowwwwwn at that size. Now you can talk him through a callback function. There's a subject not for the faint of heart (at least to truly understand). John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Friday, November 03, 2006 4:43 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Strategies for populating combo boxes Combos are limited to 65k. But I just whipped together a quick routine to add a long integer to a collection. In debug mode, without external indication of how fast it was going, I stopped it for after about 20 seconds, and it had millions in the collection already. Populating the display with the collections count property ran over 65k in about a minute. I would say the limit is closer to 2^31. Drew -----Original Message----- From: JWColby [mailto:jwcolby at colbyconsulting.com] Sent: Friday, November 03, 2006 2:50 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Strategies for populating combo boxes Drew, I was going to suggest this, however IIRC (and I was going to test this the other day), collections are limited to 2^15 items in the collection (~32 k items). I seem to remember that he has some large tables. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Friday, November 03, 2006 3:25 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Strategies for populating combo boxes Build a collection, pull the records once to fill the collection, then populate the combos from a Callback function (which would get the data from the collection, vs. the recordset) Drew -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com