Re: combos in large app

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

miss031 wrote:
I generally filter the RowSource for Combos if the list will have
more than a few thousand rows. However; I do that to reduce LAN
traffic and resources on my database server, not because it will
make the list faster for the user. In many cases a really long
list in a ComboBox with AutoExpand enabled will still be plenty
fast.

Thank you. That's exactly what I mean - not actual speed for the
user, but drain on resources. Please tell me how you would recommend
I proceed.

What I typically do is use the GotFocus event to prompt the user for starting
characters and then set the RowSource of the Combo to a SQL statement using
those characters as filter criteria. Even just 2 or 3 characters will usually
reduce the list size to a manageable number of rows.

On one or two occasions I got fancier and laid a TextBox on top of the Combo and
made it look more seamless, but I generally find that to be more trouble than
it's worth. Particularly if you want a seamless response when the user
backspaces or deletes.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: SQL Server 2000 Hardware Recommendations?
    ... Hardware Performance CheckList ... Andrew J. Kelly SQL MVP ... >> trace and see what is taking up all the resources especially cpu. ... Currently the database server houses all data pertinent to ...
    (microsoft.public.sqlserver.server)
  • Re: Peak Oil, for Trav
    ... resources. ... characters who were earth firster types, ...
    (rec.martial-arts)
  • Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified
    ... always redundant as there is a plethora of resources, ... Did you run tnsping on the webserver or on the database server? ...
    (comp.databases.oracle.misc)
  • Re: heavy lifting
    ... Where they're really useful is for complex plots with many characters, ... and sufficiently interested in cat-vacuuming to figure out how to tweak it. ... resources," you're going to assign to the McGuffin, and "non-departmental ... I *wish* somebody would do something like that with a more modern interface ...
    (rec.arts.sf.composition)
  • Re: RTF text in resource file
    ... "MyResxFile.resx", but the bottom line is that you need _actual_ newline characters in your resource, not the characters that the C# compiler would treat as special escaped characters. ... It seems that the trick to insert newline is Resources .RESX file is to use SHIFT-ENTER where you want the newline. ...
    (microsoft.public.dotnet.languages.csharp)