Search results

I have a search form, and it has 2 combo boxes, and 3 textboxes. I would like one of the textboxes to search 10 different fields for the inputted data. Along with that search all of the others must be able to be used to narrow down the criteria. How can I do this with SQL? Right now I have a...

I have a form that searches a table using a query based on 3 text boxes and two combo boxes. I want to add a button that will clear all of the boxes and rerun the query so that it includes everything. What would the code be for this, or where might I be able to find it. Thanks Riley

I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it...

could you save it as MS 97, that's what I am using, and it won't recognize it.

I would agree it is cumbersome, but as i am quite new at this I don't even know what you are refering to "on the fly" where would this be and what do you think it would require?

Ken, if you are still looking at this I have a strange occurance. I can get the code to work when I keep it simple For example: SELECT DISTINCT [WeldingSpecification].[Spec], [WeldingSpecification].[SteelType], [WeldingSpecification].[Group11], [WeldingSpecification].[Group143]...

Still haven't figured out how to get it to recognize just partial entries, it is still giving me the error that the text entered is not in the entry list. While I realize this is true, I want it to search individual characters not the whole word. Any ideas on this?

Ok, I figured that part out. here is the code. SELECT DISTINCT [WeldingSpecification].[Spec], [WeldingSpecification].[Steel Type], [WeldingSpecification].[Group11], [WeldingSpecification].[Group143], [WeldingSpecification].[Substitute1] FROM WeldingSpecification WHERE ((([spec] & "") Like...

For some reason, before I entered that new code you gave me, my filter is only working for the very last And statement, my substitute1. I can't figure out why that is the case considering they are all the same thing just different field names.

It allows me to do this for the code, but it gives me the error "The text you entered is not an item in the list" I am typing in 1839 and the item is B1839. Do I need this to be a list box or a text box to enable what I want to do?

I have a SQL that enables the user to search the form from different combo boxes to narrow down the data. I can get this to work but it only finds the fields that exactly match their input data. I want them to be able to type something in the combo box and then it pull up anything with that...

I figured it out, I had an error in my SQL that was calling for my boxes, but looking for the old boxes. Figured it out and it works great!

I have been using the forums for the past month and a half, and they have been extremely beneficial to me. I am working on a database that cross references my companies Steel standards to American standards. I am trying to make it searchable in a couple of different ways. I have borrowed code...