<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=013002300-09072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>"Those who would sacrifice liberty for security deserve
neither."<BR>-- Benjamin Franklin </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>MastercafeCTV<BR><B>Sent:</B> July 8, 2003 6:14 PM<BR><B>To:</B> 'Access
Developers discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD]
Breaking the 64k limit on combo boxes<BR><BR></FONT></DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff size=2>It's
a simple trick only</FONT></SPAN></DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff
size=2>Juan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Drew
Wutka<BR><B>Sent:</B> martes, 08 de julio de 2003 23:26<BR><B>To:</B>
'Access Developers discussion and problem solving'<BR><B>Subject:</B> RE:
[AccessD] Breaking the 64k limit on combo boxes<BR><BR></FONT></DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff size=2>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....</FONT></SPAN></DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach
Access Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Tuesday, July
08, 2003 11:45 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Breaking the 64k
limit on combo boxes<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>