Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tomh1
  • Order by date
  1. tomh1

    Combobox as Find As You Type?

    PH and MajP, thank you! Combining your two solutions provides a more portable solution than the one I posted above. It works great and is fast. Very nice.
  2. tomh1

    How Do I Set Up Find As You Type In A Combo Box?

    Firefox and the various Desktop Search applications have introduced users to the concept of "find as you type." Combo Boxes in MS Access offer an automatic AutoComplete property to automatically select the first entry that matches the characters that the user types. AutoComplete assumes that...
  3. tomh1

    Combobox as Find As You Type?

    Thank you, MajP. I'm having some difficulties with the Set rsTemp = ... line; Access keeps throwing an error, telling me that it expects two parameters and only found one. I'll keep working on that, though; your approach definitely looks more portable. I have been able to get Remou's code...
  4. tomh1

    Combobox as Find As You Type?

    Ah, I think I found it... Just insert me.cboCombo.DropDown at the end of the if/then statement in Sub cboCombo_Change(), so it looks like: If Len(Trim(strText)) > 0 Then For i = 1 To Len(Trim(strText)) strFind = strFind & "Appname Like '*" & Mid(strText, i, 1) & "*' And "...
  5. tomh1

    Combobox as Find As You Type?

    PH, SELECT tName.nameKey, tName.Name, tName.SortOrder FROM tName ORDER BY tName.SortOrder; Remou, That's a great start; it does exactly what I want. Now I just need to figure out how to have the menu portion of the combo stay open as the user types so that the user can see the available...
  6. tomh1

    Combobox as Find As You Type?

    Thank you for your quick response, PH, but AutoExpand doesn't do what I'm looking for. In the example I provide, AutoExpand would jump to the "Messenger" entry, but would not find the other entries ("NetMeeting," "Microsoft Excel," etc.). For example, I might be looking for Excel, but not be...
  7. tomh1

    Combobox as Find As You Type?

    I would like to implement a combobox with "find as you type" functionality similar to that found in application launchers like AppRocket and Colibri (on Windows; LaunchBar or Butler on Mac OS X). These work by dynamically filtering the list as you type, finding all entries that contain the...
  8. tomh1

    Conditional Formatting with CSS?

    I'm developing a website and would like to alter the formatting of <p> tags based on their position in a document. For instance, a <p> tag following another <p></p> tag should have one formatting, but a <p> following an <h?></h?> should have a different formatting. I know how to do this using...
  9. tomh1

    Help Sorting a Union Query

    Yes, and no. It wasn't working; now it is. Maybe I needed to save the query or something to get it to recognize the new sort order. Thank you for your help!
  10. tomh1

    Help Sorting a Union Query

    PHV, That turns out pretty good, but it still sorts on FullName; not LastName or FirstName. - Tom
  11. tomh1

    Help Sorting a Union Query

    Hello, I'm trying to create a query for a drop-down list. The selection in the drop-down is used to filter a report or form, and I'd like to have a wildcard value, "(All)", included in the list. I can do that much; my SQL looks like SELECT [Table Employee List].FullName FROM [Table Employee...
  12. tomh1

    Hash Functions In VBA?

    I'm looking for a hash function (SHA or MD5) written entirely in VBA--no DLLs or external EXEs--and free for corporate use. Can anyone point me to such code? If not, perhaps you can point me to resources that will tell me how to do bit manipulations (bit shifts and such) in VBA, and I can try...
  13. tomh1

    Return A Value From A Form?

    Thanks, Daniel, but I don't see how that would work. Using OpenArgs I can pass arguments from the calling form (Form1) to the opened form (Form2), but I don't understand how the openargs property of the form that I open (Form2) helps me pass data back to the calling form (Form1). I'm probably...
  14. tomh1

    Return A Value From A Form?

    I would like to be able to have a form return a value to another form, in much the same way that msgbox() and inputbox() do. Is there any way to do this? Some more specifics: I don't want to use msgbox() or inputbox() because of the type of data I'm trying to collect. The return value will be...

Part and Inventory Search

Back
Top