Recent content by gmc5135

@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.