Search results

No, it wasn't. I have added it now. (Qry is still running on my slow PC). I didn't get any errors or the parameter box. Thank you.

I have a multi select list box. I copied the corresponding code from a functioning database. It runs correctly in the new database until LOCNCODE. I then get an "input box" to enter the LOCNCODE. LOCNCODE should be pulled from the list box. I have tried removing the statement, but then the...

I need to filter or query my records based on a text field containing a certain string. Basically, I have an item description. I need to return only those records that contain "screw" or "nut" or whatever else I want to enter. Thanks!

I have three queries. One that contains ALL items that have been received (qryLastRCTDate), one that has all items that have been shipped (qryLastShip), and one that contains the unmatched records (qryNoShip) i.e. the ones that have been received but never shipped. Ultimately, I would like to...

That worked great. Thank you very much! :D

This is great. The query runs. I managed to get all the field/listbox reference replaced with my specific names. However, the query returns no results. Here is the modified Code. lbxLocationLookup is the Location List Box. lbxClassCodeLookup is the Class List Box. qryResult contains all...

Thanks, Jon, but I am using 2002 and it has a problem opening the sample database. I can't convert it because it's read-only. Also, it occurs to me that I'll need two multiselect list boxes, one for location and one for item class. Will it be possible to do this, as I all the examples I've...

I have gotten it to work correctly in MultiSelect is set to None. From what I have found elsewhere on line, MultiSelect will require some code which I have NO experience at. I tried using an article just now that explains it but I failed. If anyone has code that will run a query based on two...

Forms![frmLookup]![lbxLocationLookup] is the criteria for the field Location. It refers to a list box. I also have <[Forms]![frmLookup]![SinceDate] for field LastSaleDate. It refers to an unbound text box. This seems to work fine. It's the list boxes that are the problem.

So now my lack of patience has made a fool of me. I have gotten the "gizmos" created. I have figured out how to choose multiple options in the same list box. I have linked these list boxes to their corresponding fields in my query. When I run the query from the form, it returns no records...

How do I get the query to run based on the options the user chooses? Nevermind, I think I figured this out. But, is it possible for more than one option in the list box to be chosen? Nevermind, I figured this out too. Thanks for your help.

I am creating queries based on tables linked to our accounting package. I have a query for which the user will need to choose parameters. I need to have a lookup feature of some sort for this criteria using a field in a query. I am thinking a list box. I know how to add a parameter based on...

Actually, if I have 7 in a field I want it to pull the last receipts until the total received equals 7. If the last receipts don't equal exactly 7 (i.e. if most recent is 5 and the next is 3), I need it to return up to or greater than the amount on-hand. I hope this makes sense. Thanks!

Hi, guys. I have a query in which I only want to return the most recent records until the sum matches a particular field. For example, I have 7 of an item on hand. I want the query to return only receipts for the last 7. Is this possible? Thanks!