[AccessD] Breaking the 64k limit on combo boxes

MastercafeCTV mastercafe at ctv.es
Tue Jul 8 17:14:12 CDT 2003


We solve this problem with a new window that appear like a combobox in the
position. The solution apper good but the speed to charge the data are not
good.
It's a simple trick only
 
Juan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: martes, 08 de julio de 2003 23:26
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Breaking the 64k limit on combo boxes


I tried to bypass it with code, by filling the combo from a function.  I
made a table with 100,000 records, and it put 100,000 lines in the combo
dropdown, without any errors, but it didn't fill anything past 64k.  I also
tried to 'trick' it, by only filling a few lines, and then try to get it to
'slide' the source, but that didn't work either.  I think the only option
would be to build a combo box window, don't know how affective that would be
though....
 
Drew

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Tuesday, July 08, 2003 11:45 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Breaking the 64k limit on combo boxes


Dear List:
 
Does anyone know  a way to get around the 64k limit on combo boxes?  Other
than trapping the first few keystrokes and filtering the row source until
the number of records drops below 64k? Any third party controls?
 
MTIA
 
Rocky Smolin
Beach Access Software
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030709/c0be555e/attachment-0001.html>


More information about the AccessD mailing list