Search results

Oh ok, that's simple enough. Is there any way to remove the navigation bar at the bottom of that search form?

Ok, I know this next questions has to be simple. But how could I create a button to "clear" all of the selected criteria in the form to start a new search without having to manually delete each criteria?

Oh, never mind, once you change the Row Source, it does the filter Just so I know how that work, how does changing the Row Source to that query remove the duplicates?

Ok, Let me try that. Any coding needed for the filtering?

ok, once I have a query for each drop down menu, and have Total - Group By selected. What do I need to do next? And then how do I filter the drop down menus to not display the duplicate entries?

Oh ok, got it. Now each drop down menu needs it's own query? Why is that?

KeithG I'm totally confused on the "group by" total menu. I can't seem to be able to add that function to an existing query. The "Total" option isn't there in any of my queries? How did you do that?

KeithG Ok, here's my up to date database file with all the criteria set up I want except the subtable "Individual Tool Information" criteria. I noticed in your most recent post with the "Vendor" as a criteria, the search results produced included other records that didn't have that vendor I...

I had posted what I had done up until your recent posting with changes to the query to remove the duplicates. I deleted that post because I didn't want to confuse you as I try to combine what you gave me to what I've added for search criteria in the form and VBA code if that makes sense.

wow, getting more and more complicated now huh? Going to take me a bit to figure all that out. Again, thank you for your help once again. Truly appreciate it.

Just so I can learn and understand how to do it for future reference. How did you change the drop down boxes to be based on Grouped queries so each entry is listed only once?

Ok, I'll try my best to do that. I did have one more question. Some of my drop down boxes will have the exact same info in many lines in teh drop down box, is there a way to delete/filter the duplicate out so each available entry is only listed once?

Yes, but that would only bring back one result, because that is one physical tool. If that makes sense.

I'm sorry to confuse you. What I guess I'm trying to ask, I would like to use some of the fields in "Individual Tool Information" table to search for results as well. Bascially, if any of the "Individual Tool Information" fields are used in a search, it filters the results in the "Individual...

There is a link in the relationship window I believe. The "Individual Tool Information" tool does have the "NC Tool #" field in it as well. That link allows the subtable in "Tool Information" form to change as the "NC Tool #" changes as you go through the form results. So does that answer you...

Everything you've given me has worked just great. I have just one last question before I assmeble everything based on what you've given me. (I hope!) If you remember from my "Tooling Information" form, I had a subtable. I've tried to setup up a pull down menu to search based on criteria from...

Got it. You rock. If there was a Internet Bar, I'd be buying the rounds for a while for sure. Last question for a bit. I have two criteria that I want to put on the form that are Notes and Description that would have key words in them. How do I set up a text box to allow for someone to type...

Ok, I've named the check box on the form "chkUsedFFallsVeneer" (no quotes) If Me.chkUsedFFallsVeneer = -1 Then If IsNull(strWhere) = False And Len(strWhere) > 2 Then strWhere = strWhere & " AND ([Profile # or Name]='" & Me.cmbProfile & "')" Else strWhere...

Oh ok, thanks for the info. Got it working. Again, I really appreciate all your help with this. You have saved my head from further bruising as I was beating it into my desk for a few days now. I didn't know the whole issue with symbols in field names would be a problem. I should be able to...

KeithG I do have to leave the office for the day @ 4:30pm CST If you have a solution to what I did wrong, or list of step by step instructions to what I did wrong. Post it here, I'll check on it Friday, 6/9/2006. If possible, as I go forward in with this to have you keep checking this thread...