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.
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...
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...
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 "...
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...
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...
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...
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...
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!
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.