[AccessD] Strategies for populating combo boxes

JWColby jwcolby at colbyconsulting.com
Fri Nov 3 17:02:06 CST 2006


LOL.  And I did and have, but to actually understand it...  I was trying to
generalize it.  To make a callback where one callback could be used for more
than one object, with more than one datasource.  It got ugly pretty quick.
If you have 500 combos in a big app and wanted to use a callback for many of
them, it gets painful building a new one for each object.

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 5:21 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Strategies for populating combo boxes

Access 97's help file was a pretty easy read to do it, along with a sample
function.

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com]
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
--
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