Search results

Which part of the code is "search as you type", can I have it inserted in the search box which @arnelgp modified for me? Or it's just a feature for listbox only?

The search which I found has a text box with the content like "... results were found." That search uses a list box, I see this code: = IIf(ListBoxName.ListCount-1=-1,"0",ListBoxName.ListCount-1) & "results were found." Can you help me with that on your search db?

That's the only listbox I saw :unsure:

I think may be the problem is in his code Private Sub Text2_Change() 'SELECT [Bangchinh].[Maluutru], [Bangchinh].[Hoten] FROM Bangchinh; Dim strSql As String strSql = "SELECT [Bangchinh].[Maluutru], [Bangchinh].[Hoten] FROM Bangchinh where Hoten like ""*" & Me.Text2.Text & "*"""...

You mean this

All done but...

"Search as you type", never cross my mind, I tried it for purpose of diversifying my option on some day, but when I increased the column count to 4, it still only showed the content of Hoten field, what happened here?

I made the same changes to my db as you did, everything went well but one In your file, when I select a record, it goes blue In my file, when I pick a record, it goes white. Actually, I mean I don't know it goes white or it just doesn't change the colour at all :unsure: Did I miss something?

I've just found out another method to do the search and intending to tell you that, but your timely help kept me staying the old way. Thank for the superb support, I really appreciate it.

Tried it, there are some errors. I can't put ID in the combo box pointed by red arrow and when I tried harder, I get that error message.

Hi, I have an issue with the search engine, but it isn’t big enough to create a new thread, so I place the question in the sample db, can you sometimes take a look at that, thank for the time.

It works perfectly (y) Thank for your kindness of the detailed instruction.

Thanks guys but I encountered this error

Each of my records starts with a number, e.g. 21033185, 21 is the current year (2021), 03 is the current month (March), 31 is the current date (today) and 85 is the ordinal number of the buyer (the 85th buyer). My problem is that I have to fill this serial number manually everyday. Therefore, I...