Hi guys, new to the forum.
I have been rebuilding our database here at the office and have pulled out all of my hair trying to get this to work properly.
Intro
We were originally using a server hosted SQL program. That was discontinued so I spent some time and pulled everything into excel from the DB file. So naturally I turned to MS Access to rebuild something to read the excel tables with.
Where I am currently
I have everything all set up and all my search fields work. I can now navigate through the table (Which contains 1700 row entries) using a query with 4 text box search filters, two drop down list filters and a multiselect list box filter which is great. But we cannot be that specific with each search so sometimes it comes down to only searching by the first letter of the company name which results in 50+ search results which is irritating to scroll through using the buttons automatically built in by Access.
The problem
So to alleviate the need to search through the results one by one, I have been trying to get a list box to display (Or be filtered from the entire list) So then you can easily just click on the desired entry in the search results.
Well, I have tried everything. I have the box displaying all 1700 entries and when you click on one it does display all that entry's information in the text boxes etc. that I am using as display fields. But the damn thing will not filter for the life of me.
I cannot actually attach my database thus far as it was voilate company policy however to give you an idea of what I am doing I have included a link to a screenshot below in design view because for some reason it won't display the image.
http://img135.imageshack.us/img135/5405/27086331rb4.jpg
Does anybody have any code I can use? and further tell me where to put it so this works?
Thanks in advance,
I have been rebuilding our database here at the office and have pulled out all of my hair trying to get this to work properly.
Intro
We were originally using a server hosted SQL program. That was discontinued so I spent some time and pulled everything into excel from the DB file. So naturally I turned to MS Access to rebuild something to read the excel tables with.
Where I am currently
I have everything all set up and all my search fields work. I can now navigate through the table (Which contains 1700 row entries) using a query with 4 text box search filters, two drop down list filters and a multiselect list box filter which is great. But we cannot be that specific with each search so sometimes it comes down to only searching by the first letter of the company name which results in 50+ search results which is irritating to scroll through using the buttons automatically built in by Access.
The problem
So to alleviate the need to search through the results one by one, I have been trying to get a list box to display (Or be filtered from the entire list) So then you can easily just click on the desired entry in the search results.
Well, I have tried everything. I have the box displaying all 1700 entries and when you click on one it does display all that entry's information in the text boxes etc. that I am using as display fields. But the damn thing will not filter for the life of me.
I cannot actually attach my database thus far as it was voilate company policy however to give you an idea of what I am doing I have included a link to a screenshot below in design view because for some reason it won't display the image.
http://img135.imageshack.us/img135/5405/27086331rb4.jpg
Does anybody have any code I can use? and further tell me where to put it so this works?
Thanks in advance,
