Recent content by snoto

Finally got it all done, cheers everyone for their help!

removed This is what I have at the moment, but its not returning any results, anyone know what the problem is?

This is a code I googled and is similar to what I need (I think) Set DB = CurrentDb() Set Q = DB.QueryDefs("MultiSelect") Q.SQL = "Select * From Orders Where [CustomerID] In(" & Criteria & _ ");" Q.Close Where criteria is the end result of a loop for the multi list box. How...

Sorry im a newbie, but I appreciate all the help im getting :P This is my code for my run query button Option Compare Database Private Sub run_Click() On Error GoTo Err_run_Click Dim stDocName As String stDocName = "qryTest" DoCmd.OpenQuery stDocName, acNormal, acEdit...

Yep thats it basically. So far I have a multi list box, these are used to select paramater values for my query. When I select both CR and PR and then REL, it works and finds all the recrods I want. But if I choose PR and REL only, it doesn't work :S (Only works for non-multi list box) However...

Ive checked out that page, but like, I have 2 list boxes, I select 2 values in listbox 1 and it needs to match listbox2 to display the records (so first selection in listbox1 + listbox2, second selection in listbox1+listbox2 etc), the examples given only have one listbox! + my form works...

OK, so i've made a listbox that allows me to select mulitple values for 1 paramater, however it doesn't work, can anyone help me on this?

Hey, still didnt work :( But thanks for the responses, I don't really want to make a form but I'll guess I'll have to...

Tried the first one, don't think it worked. Not really sure how to do the second one (really new to MS access) Let me explain my problem from the top (if I've been unclear). I have a query that prompts 2 paramaters, these 2 paramters are matched and then are used to find records in a database...

Ok I have a select query, where there are 2 paramaters. I need one of the paramaters to accept mulitple values. At the moment, I have 2 prompt messages, one asking for an Enter Trace from Requirement, where i would input PR. But want I want to do is to input PR, CR. SO that it would search...

Hey all, is it possible to enter multiple values in 1 paramater? At the moment, I have 2 parameters where I enter 1 value in each to find the records. Example of what I want: Enter colors: Blue, Red Is it possible to have a comma delimiter or even a space delimiter, and how would I go...