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!

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

Auto search/sort in Excel, or possibly Access

Status
Not open for further replies.

liquidone

Programmer
Apr 11, 2007
1
US
I have a spreadsheet that I pull from quickbooks that has all our inventory items information. About 3000 items with 10 or so columns each. I need my sales guys to be able to find the items they need for jobs quickly. I want there to be like a search box that allows them to type what they are looking for, and it will sort the list down to what they are looking for after each keystroke. Kind of like the way most ajax websites are doing it, and the indexed search in outlook 2007. I am a programmer, but I dont know visual basic or vba almost at all. Is there an example of this already made, or a program I could buy to make this effect?
Thanks in advance,
Mike
 
In ms-access you may play with the AutoExpand property of a ComboBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top