Search results for query: *

Another developer and I have both experienced some abrupt Access crashing when going back and forth from Design mode to Form mode of a form that used this code. Adding this terminate code seems to have resolved that problem. Your mileage may vary. Can you provide a link to the "FAQ" you...

thread702-1716817 thread702-1765353 These two threads are closed for the awesome FindAsYouTypeListBox and FindAsYouTypeCombo classes created by MajP but I wanted to share this small addition. If you open and close the form that uses this class too many times, Access may crash unless you've...

Continuation of this thread: thread702-1756368 The images shows what happens when you type "del" into the combo box. It is configured to search any part of the word in two columns. Only two lines of code need to be added to your form after the Class Module has been added to the project...

I have incorporated the previous suggestion by MaJP and have also made an improvement to the Enter key behavior. See the updated functions that follow. Private Sub FilterList() ' Create a filter string based on what has been typed so far and update the dropdown list. ' NOTE: The DAO filter...

After I type a few characters I may have reduced the list to a few records which are displayed in the dropdown. In the current behavior, if I press Enter, it gives me an error because I haven't selected an item from the list. The desired behavior is to have it select the first item in the list...

@bobsan42: Thanks for sharing you enthusiasm and your code enhancement. @All: I'm trying to make this a little better and would like some help. In the mCombo_KeyDown() event you'll see have some commented out code that handles the Enter/Return key. After using this class for a while I...

thread702-1756368 I wanted to share an update of the fayt class since the discussion closed 6 months ago. I was stumped trying to find a way to reload the records of the combo box with a different query. I have two use cases for needed to requery the combo box. In one case I have cascading...

With great hope I tried adding your method: but it fails because my RowSource contained a query that had a VBA function in it, which can't be executed from VBA. I changed the query to be very simple and I'm able to get the line to run but the combo box list never changes. I have to admit I...

I'm glad to have this exchange with you. I have been a full time developer in VB6/VBA since around 1998. I have to admit that I have hardly ever used classes. It used them some in the beginning but generally don't see the need for them. In this case having the ability to trap events is...

MajP, I've made some additions and to your fayt combo class. Please don't take offence. I had these in my own beta AutoComplete code and am used to them. I want to switch to using your class because your recordset method is faster than requerying the database with each keystroke. After...

Thanks for the response to my .Dropdown inquiry. I'll accept "I have no idea" as a good answer (much better than making stuff up). My next question will be in regards to the AfterUpdate event not firing all the time. I was trying to put together a good test case that consistently failed...

I tried to disable the mCombo.Dropdown in the mCombo_GotFocus() event because I don’t like that the combo drops down every time a user tabs through it. Unfortunately this event appears to be required, or at least the mcombo.Dropdown needs to execute during InitalizeFilterCombo(), otherwise the...

Ugh. I just spent 40 minutes making a reply and lost it when my browser crashed. Is there a chance we could talk directly? Is there a way to get your email address without publishing it in the forum? Your latest class is better than the one I was using, but there is an issue with the...

thread702-1228727 I was developing my own way of having an auto-complete combo box class when I came across an idea from user "MajP" that suggested using the recordset property of the combobox instead of fussing with the SQL statement. I've got a big combo box that is slow to query so I was...