Search results

Below is what I posted a few days ago. Let me see if I can ask it any differently. I basically need to know if it is possible in a query to have 2 operators so that you can pull a value "=" and a value "between". Can you make both a "=" and "Between" value set for one category? ie...

Make a Table of the 8 values call it table1 Design your form and link the combobox to the table1 In you query you tell the Criteria to equal the value entered in the form combo box. The code I worte above is the code you need. I just have it viewed in SQL view for you.

I believe I have come up with a different solution using frames that turn off and on depending on which query I want to perform. I still would like to know if above can be done. Thanks

all you need in the SQL View SELECT table1.categoryinquery FROM table1 WHERE (([Categoryinquery]=[forms]![Formname]![comboboxname] Or [forms]![Formname]![comboboxname] Is Null)=True) And of course the your table with your 8 values is linked to your form

Can you make both a "=" and "Between" value set for one category? ie. [Patent]=[Forms]![WDCRPD]![Patent1] And [Forms]![WDCRPD]![Patent2] And [Forms]![WDCRPD]![Patent3] And [Forms]![WDCRPD]![Patent4] Or [Forms]![WDCRPD]![Patent1] Is Null Or [Forms]![WDCRPD]![Patent2] Is Null Or...

You will need to setup in Visual Basics editor a Serach_Click() Sub set the focus of the text box you want to have int he search by Textbox.SetFocus then make a DoCmd.OpenQuery "Query1" If you want to make a Form that is based on the Query then just change the DoCmd to DoCmd.OpenForm...

How would you go about requesting query request of Primary Key value OrderIDs? [OrderID] Between [forms]![SearchForm]![txtStartOrder] And [forms]![SearchForm]![txtEndOrder] Or [forms]![SearchForm]![txtStartOrder] Is Null Or [forms]![SearchForm]![txtEndOrder] Is Null This doesnt work it pulls...

Thanks a bunch Pat. wasnt sure if what I was doing was possible without having to go and actually build the code. I have very used VB so I am teaching myself as I go. Again thanks for your time

Using it within the actually query itself in the Criteria

In the following code I would like to add a user input criteria expression selectible through a form combobox with three option to select from And/Or/Not Like "*" & [Forms]![Test]![AbstractBox] & "*" And Like "*" & [Forms]![Test]![AbstractBox2] & "*" And Like "*" &...