Search results

Hi, I was wondering if a list box can be made so the header of each columns is clickable.. so you can sort by that column either alphabetically or numerically? Thanks.

Just want to say thanks again Jdraw :) id been looking for days and that was just what i needed... sorted all my other problems as well.

Hi, thanks Jdraw. I have actually got it to search on the column i want now i think i had to modify: j = 7 ' using description field only ' so it is looking at the particular column i want which falls as the 7th column. Is this correct? The trouble i am having now is more with the form...

Jdraw that is exactly what i need.... thank you so much! I am having trouble however in specifying which column it searches... Where do i specify that?.. i am searching but cannot seem to find it. I am not very good with vb i can read some of it but not all. Thank you again.

Thank you I will take a looksee :)

HI again ^^ So i found this on another thread.. This is pretty much exactly what i am looking for however i cannot get it to work!.. I have a form with two text boxes and have set the correct values as outlined in Evans post. I then have the query set to run via a button. I run it but it will...

Ahh maybe im going the wrong way about this and need to start over ><. Can anyone point me to a way i can link a bunch of keywords to each record and then bring up a prompt which the user will be able to enter multiple words... and these words will be checked against the keywords for that record...

Can anyone explain how i would write this so it comes up with a simple pop up like my single search query.... for example i want to right click and choose open my "Multiple Keyword Search" Query... and it pops up with a simple prompt box... i can then put in "cat, dog, sheep" or even/or with no...

Hmm not sure if that will work for me? Could i possibly use the InStr function?

Ok thank you for the link i will have a read.

Hi, I am very new to access. My knowledge level is very low so far... I am using Access 2007. I have a bunch of records and i want to be able to do a Multiple keyword search on one particular column which is called keywords. I have a single search query which works fine... this is the query...