If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display Search results in a List box
Please forgive me if this is an obvious question...
My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. I have created a form that allows the user to search the master list for locations (really network folders) containing his/her specified criteria. Several of these folders have similar names ("Environmental Justice", "Environmental Tracking", "Environmental Management", etc.), so if the user enters the word "Environmental" as his/her criteria, the search results include items in all of these folders. I would like the results of the search to display so that all of the folders meeting the criteria appear in a list box, allowing the user to select the specific folder he/she is looking for and pull up a list of only the files inside that folder. Is this possible? It must be! I just haven't had any luck figuring out how to make it happen. Perhaps the answer is staring me right in the face but I'm missing it? Any help would be greatly appreciated...Thanks so much!! |
#2
|
|||
|
|||
Display Search results in a List box
This can certainly be done; however, since you already have the search
working, it would be important to know what method you are using to accomplish the search and where the results of the search is. Also, do you want the user to be able to select one folder or multiple folders from the list? "bejewell" wrote: Please forgive me if this is an obvious question... My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. I have created a form that allows the user to search the master list for locations (really network folders) containing his/her specified criteria. Several of these folders have similar names ("Environmental Justice", "Environmental Tracking", "Environmental Management", etc.), so if the user enters the word "Environmental" as his/her criteria, the search results include items in all of these folders. I would like the results of the search to display so that all of the folders meeting the criteria appear in a list box, allowing the user to select the specific folder he/she is looking for and pull up a list of only the files inside that folder. Is this possible? It must be! I just haven't had any luck figuring out how to make it happen. Perhaps the answer is staring me right in the face but I'm missing it? Any help would be greatly appreciated...Thanks so much!! |
#3
|
|||
|
|||
Display Search results in a List box
The user should only be able to select one folder from the list.
In my query, in the "criteria" row of the "Current Locations" column, I have entered: Like "*" & [Enter Phrase to Search] & "*" I then created a form based on this query, which, when run, prompts the user for a search term. The resulting form includes all of the records that meet the criteria entered. It works as long as the "Current Folders" field is a text box - it just displays each record with its current folder in the field. But when I change it to a Combo Box (sorry, I've been calling this is a list box, I actually mean a combo box, because I want the user to be able to select a specific folder from a dropdown list of folders that meet the criteria), it only shows the current folder and a blank row in the dropdown. Hope this answers your question?? "Klatuu" wrote: This can certainly be done; however, since you already have the search working, it would be important to know what method you are using to accomplish the search and where the results of the search is. Also, do you want the user to be able to select one folder or multiple folders from the list? "bejewell" wrote: Please forgive me if this is an obvious question... My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. I have created a form that allows the user to search the master list for locations (really network folders) containing his/her specified criteria. Several of these folders have similar names ("Environmental Justice", "Environmental Tracking", "Environmental Management", etc.), so if the user enters the word "Environmental" as his/her criteria, the search results include items in all of these folders. I would like the results of the search to display so that all of the folders meeting the criteria appear in a list box, allowing the user to select the specific folder he/she is looking for and pull up a list of only the files inside that folder. Is this possible? It must be! I just haven't had any luck figuring out how to make it happen. Perhaps the answer is staring me right in the face but I'm missing it? Any help would be greatly appreciated...Thanks so much!! |
#4
|
|||
|
|||
Display Search results in a List box
Okay, here is how you do that.
Create a text box on your form for the user to put the value in instead of letting the query pop up and ask for a value (ugly anyway). Change the criteria in your query to look for the value in your text box: Like "*" & Forms!MyFormName!MyTextBoxName & "*" Make the query the row source of the combo box In the After Update event of the text box, Me.MyComboBox.Requery Now, when the user puts a value in the text box and navigates away from it, the combo will requery with what the user is looking for. Now, if you want to get really fancy with it, you can use what is called Cascading Combos. That is, rather than using a text box to enter the criteria, Use a combo with a row source that will allow the user to select something to look for. Everything else remains the same, you still use the query the same way, you still do the requery in the after update, etc. "bejewell" wrote: The user should only be able to select one folder from the list. In my query, in the "criteria" row of the "Current Locations" column, I have entered: Like "*" & [Enter Phrase to Search] & "*" I then created a form based on this query, which, when run, prompts the user for a search term. The resulting form includes all of the records that meet the criteria entered. It works as long as the "Current Folders" field is a text box - it just displays each record with its current folder in the field. But when I change it to a Combo Box (sorry, I've been calling this is a list box, I actually mean a combo box, because I want the user to be able to select a specific folder from a dropdown list of folders that meet the criteria), it only shows the current folder and a blank row in the dropdown. Hope this answers your question?? "Klatuu" wrote: This can certainly be done; however, since you already have the search working, it would be important to know what method you are using to accomplish the search and where the results of the search is. Also, do you want the user to be able to select one folder or multiple folders from the list? "bejewell" wrote: Please forgive me if this is an obvious question... My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. I have created a form that allows the user to search the master list for locations (really network folders) containing his/her specified criteria. Several of these folders have similar names ("Environmental Justice", "Environmental Tracking", "Environmental Management", etc.), so if the user enters the word "Environmental" as his/her criteria, the search results include items in all of these folders. I would like the results of the search to display so that all of the folders meeting the criteria appear in a list box, allowing the user to select the specific folder he/she is looking for and pull up a list of only the files inside that folder. Is this possible? It must be! I just haven't had any luck figuring out how to make it happen. Perhaps the answer is staring me right in the face but I'm missing it? Any help would be greatly appreciated...Thanks so much!! |
#5
|
|||
|
|||
Display Search results in a List box
Thanks so much for your help! I really appreciate it!
"Klatuu" wrote: Okay, here is how you do that. Create a text box on your form for the user to put the value in instead of letting the query pop up and ask for a value (ugly anyway). Change the criteria in your query to look for the value in your text box: Like "*" & Forms!MyFormName!MyTextBoxName & "*" Make the query the row source of the combo box In the After Update event of the text box, Me.MyComboBox.Requery Now, when the user puts a value in the text box and navigates away from it, the combo will requery with what the user is looking for. Now, if you want to get really fancy with it, you can use what is called Cascading Combos. That is, rather than using a text box to enter the criteria, Use a combo with a row source that will allow the user to select something to look for. Everything else remains the same, you still use the query the same way, you still do the requery in the after update, etc. "bejewell" wrote: The user should only be able to select one folder from the list. In my query, in the "criteria" row of the "Current Locations" column, I have entered: Like "*" & [Enter Phrase to Search] & "*" I then created a form based on this query, which, when run, prompts the user for a search term. The resulting form includes all of the records that meet the criteria entered. It works as long as the "Current Folders" field is a text box - it just displays each record with its current folder in the field. But when I change it to a Combo Box (sorry, I've been calling this is a list box, I actually mean a combo box, because I want the user to be able to select a specific folder from a dropdown list of folders that meet the criteria), it only shows the current folder and a blank row in the dropdown. Hope this answers your question?? "Klatuu" wrote: This can certainly be done; however, since you already have the search working, it would be important to know what method you are using to accomplish the search and where the results of the search is. Also, do you want the user to be able to select one folder or multiple folders from the list? "bejewell" wrote: Please forgive me if this is an obvious question... My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. I have created a form that allows the user to search the master list for locations (really network folders) containing his/her specified criteria. Several of these folders have similar names ("Environmental Justice", "Environmental Tracking", "Environmental Management", etc.), so if the user enters the word "Environmental" as his/her criteria, the search results include items in all of these folders. I would like the results of the search to display so that all of the folders meeting the criteria appear in a list box, allowing the user to select the specific folder he/she is looking for and pull up a list of only the files inside that folder. Is this possible? It must be! I just haven't had any luck figuring out how to make it happen. Perhaps the answer is staring me right in the face but I'm missing it? Any help would be greatly appreciated...Thanks so much!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Press Release - New Search Engine Debuts Features | [email protected] | Powerpoint | 0 | December 17th, 2005 11:35 AM |
Press Release - New Search Engine Debuts Features | [email protected] | General Discussion | 0 | December 17th, 2005 11:28 AM |
Creating a Form to Search a Query and display the results in a subform with the click of a command button | [email protected] | Using Forms | 1 | December 8th, 2005 12:00 PM |
Display results in the same form | dpac | Using Forms | 5 | October 24th, 2005 07:04 PM |
Visible Property | Ben | General Discussion | 4 | September 14th, 2005 08:22 PM |