Need advice on listbox or another way (1 Viewer)

[miked1978]

I have a simple data entry form and one of the fields the user needs to input into is a Ticket# field which is set as a long text but in reality its between 10-15 characters (SQL server has it as nvarchar(255). The ticket number already exists and the user just needs to pick/input the correct one he is working.

I currently have the ticket # as a list box that is pointed to local table that contains all of the tickets. It works but the local table has over 30,000 records so as you can imagine the list box is quite full.

I guess my question is should I maybe do some type of validation where the user inputs the ticket # themselves and have some type of process that validates it against the table with all of the tickets in it to make sure its a good ticket? Or should I just leave it as a list box? It wouldn't be so bad if the user could type "159" and all the values that start with 159 would appear in the list box but its not working that way.

 

[theDBguy]

Hi. Maybe you could implement some sort of a "search as you type" feature.

 

[Gasman]

You could use @MajP FAYT class for the listbox?
A combo would work the same would it not?, but here is the FAYT demo in this thread.

Solved - Search as you type with in Combobox / instant filter combobox itself

I am looking for code "want to filter combo-box (drop down data) by key word while typing". On a form I have three comboboxes. 1) for Articles 2) for Company 3) for Catalogues I was able to do this search filter for one combobox (Articles), but dont know how to change it for the other two...

www.access-programmers.co.uk

 

[miked1978]

You could use @MajP FAYT class for the listbox?
A combo would work the same would it not?, but here is the FAYT demo in this thread.

Solved - Search as you type with in Combobox / instant filter combobox itself

I am looking for code "want to filter combo-box (drop down data) by key word while typing". On a form I have three comboboxes. 1) for Articles 2) for Company 3) for Catalogues I was able to do this search filter for one combobox (Articles), but dont know how to change it for the other two...

www.access-programmers.co.uk

thanks. How would I implement it to my field? I copied the module to my DB but I don't see where he is calling the module in his form.

 

[Gasman]

Have a look at his demo.
Basically it is one line to create a FAYT listbox as far as I recall? It is all done by classes.

Been a while since I implemented it?

 

[MajP]

You need code like

Public faytLst As New FindAsYouTypeListBox

'--------------------------------------- Needed To Create FAYT  -----------------------

Private Sub Form_Load()
  faytLst.Initialize Me.lstSearch, Me.txtSearch, "ProductName", ftlb_fromBeginning
End Sub

'Pass in a reference to the listbox, textbox, and optionally the field to search
'if you leave it blank it will search all fields. The last argument tells is to search
'from the beginning or anywhere in the string