[AccessD] Strategies for populating combo boxes

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



More information about the AccessD mailing list