Search results

@pr2-eugin- Works great! Thank you so much.

Sorry guys... If you look at the database I attached in the original post, qos and qalloy are both queries. I have the form "searchform" which is where I want the user to be able to enter parameters and to search two tables. qalloy is on the left and is used to search the "Alloys" table. qos is...

I've attached my database so that you can see what I'm working with. Basically, I want qos to be exactly like qalloy, just for the different table. It won't let me run it. It says "qos" is not a valid name. Let me know if I'm being unclear. Thanks!

Anything at all?

As you can see in the attached database, I'm trying to make a search form. The query qalloy seems to work fine, but qoxsamples is giving me troubles. looking in SQL view, I tried modeling qoxsamples after qalloy. It won't let me save it, but the block of code at the bottom is what I was trying...

Works perfectly! Thank you so much for all your help.

It works when you first open the form, but doesn't seem to work when you hit the clear parameters button, then try it.

Kind of the same thing as before, except that instead of saying it's too complicated, it just does not show any records, as though nothing matched.

Ok so this is what I've gathered. If you clear parameters, then try the single text box, it will not work. However, if you type a value into all the text boxes, it does work. Then after you do that, you can click on the text boxes and hit backspace, then the single text box thing works. So I'm...

And now it's not working again. Funny how these things work.

For some reason it started working now. Thanks so much for all the help!

Sorry to be a pain, but when I do that and try to run it, I get a prompt saying, "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the...

It works for me when you enter data all the text boxes. Any idea on how to make it work if you only type in one of the text boxes?

Thank you for the help. That was a stupid mistake on my part. Now that we got that straightened out, it still doesn't seem to be working. If you type a number into one of the text boxes and hit run query, it does not show any records. Maybe what I'm expecting it to do is different from the way...

Bob, attached is the 2003 version.

I have attached my database so you guys can see what I'm looking at. I would like the query to search my database based on what is entered in the text boxes in the form. Right now, it has pop-ups that prompt you to enter information, and even that isn't working right. Any help is appreciated...

Thank you both very much!

Hello all, I've very new to Access and need some serious help, or at least a nudge in the right direction. Attatched is my database. I would like to have one form that can enter all the information in the database. Not sure if it matters or not, but eventually I would like to have buttons to...

Absolutely perfect! I think I have all I need now to complete it. Thank you JLCantara, and everyone else for the help!

Referring back to the excel sheet in the original post. The five topics being alloy, oxidation samples, high temperature oxidation, ring compression-1, and ring compression-2. To explain what I mean for information, Use the topic high temperature oxidation. Information being run #, target temp...