I was missing the qualcode field in my main frm. As soon as i added it to the record source of my main form it works.
Thanks again for your time and expertise its hugely appericated.
Thanks and best of luck in the future.
Kind regaeds,
James
woodey2002
Last Activity: Mar 3 '09, 12:32 AM
Joined: Feb 19 '09
Location:
-
filter a subform based on multiple multi select list boxes
Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just can’t get any where on.
My databse mostly includes bits of code for different examples. I have one last thing to finish.
I am trying to create a search form that will allow users to select criteria from multiple sources eg ,multi select list boxes , combo boxes.
I have a subform... -
Hi
thanks for the responce.
I figured is out it was finally with some advice from my friend.
qualCode a numeric value in the table (the data type) so, i don't want quotes around the value.
Thanks so much for all the assistance.
All the best and thanks again.
Regards
JAMES.Leave a comment:
-
Thanks for the reply hugely appreciated.
I have tried your suggestion and its giving me a runtime error
"data type mismatch in criteria expression"
If i try [tblqualificatio ns]_[qualCode] i get a syntax error in query expression
'( [tblqualificatio ns]_[qualCode] = "3") this error seems somewhat correct because its recognising the qualCode from the listbox.
In answer...Leave a comment:
-
No problem.
Thanks for the advice.
Won't do again.
Kind regards,
James.Leave a comment:
-
Hi mate
I found a great example on the site below maybe it can help you also.
Regards, JAMES
*** Edit - Illegal link removed ***Leave a comment:
-
Search form multiple multi select list box's Error
Hi Everyone. Thanks for your time.
I am trying to create a search form that will allow users to select criteria from multiple multi select boxes. So far i have managed to achieve a search option for 2 list boxes:- county and nationality, while trying to add a third multi select list box for qualifications search is where i encounter my problem.
I've copied the working code from my working list boxes, however it cant... -
Hi guys,
My problem is now resolved thanks to some advice
Changed
varWhere = varWhere & "( " & CountyCode & " ) AND "
to
varWhere = varWhere & "( " & CountyCode & " ) "
Many thanks for all the time.
JamesLeave a comment:
-
resolved thanks to ChipR
ChipR
Your the man.
Worked like a charm.
I owe you a beer.
Many thanks and the best of Luck all the way from Ireland.
Regards
thanks so much again
JAMESLeave a comment:
-
2 multi select list boxes on one search form
Hi Guys and thanks for your time.
I have a search form for my database that allows users to select multiple criteria from multi select list boxes.
I successfully integrated a multi select listbox for users to select and search for counties.
On the same page however I would like to integrate a similar multiselect box for nationality. I would like the user to be able to search for nationality with county... -
lost the order option now stuck with 2 multiselects listBx
Hi Guys and thanks for all the input.
I decided to lose the order by feature so that makes more straight forward.
However i have encountered a new problem.
I successfully integrated a multi select listbox for users to select and search for counties.
On the same page however I would like to integrate a similar multiselect...Leave a comment:
-
hello again and thanks so much for all your time.
My friend tole me i can't add an order by clause to the wherecondition argument. is that true? if so is there an easy way for me to keep the order by option to my subform and add some degree of user selected ordering to my report.
Kind Regards James
'' ORDER BY [surname]
'' ORDER BY [surname]
'' ORDER BY [surname]
'' ORDER BY [surname]
...Leave a comment:
-
debug results
Hello these are my results.
Kind regards and thanks so much!
Someone mentioned to me that you can't add an order by clause to the wherecondition argument.
Is that true? if so whats a easy way to add grouping options ot my report and keep the ordering in my subform.
JAMES
...Code:'' ORDER BY [surname] '' ORDER BY [surname]
Leave a comment:
-
1 error left
Major Thanks!!!
ADezii & OldBirdman
Your information really helped me understand what was going on. This problem was driving me nuts. Thank you so much for your time and knowledge.
I managed to create a Search form to meet my specification exactly but i have one error left to sort out.
The search feature works great it updates the subform of search...Leave a comment:
-
woodey2002 started a topic multi select list box in a search form user selected selected criteria queryin Accessmulti select list box in a search form user selected selected criteria query
This problem is driving me crazy.
Hello there,
i am trying to create a search form for records in my access database. The search form will contain text boxes and a multi select list box. The user can enter their search criteria eg. surname, reg num, etc. in the text boxes. The multi select list box allows the user to select multiple counties which they have the option of including in the search. The user should be able to select...
No activity results to display
Leave a comment: