Arthur Fuller
artful at rogers.com
Tue Jul 8 19:29:47 CDT 2003
I wrote a piece about this problem a while back, but I forget to whom I sold it. The general concept is this: "SELECT * FROM someTables WHERE myColumn LIKE " & myControl. Redefine the rowsource after every keystroke, beginning at the third keystroke. Until then there is now rowsource. This cuts down the hits to a miniscule fraction of the total rows. "Those who would sacrifice liberty for security deserve neither." -- Benjamin Franklin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MastercafeCTV Sent: July 8, 2003 6:14 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Breaking the 64k limit on combo boxes 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/20030708/49921d86/attachment-0001.html>