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