Recent content by Cassim

Geotch, "IN" didn't work in the query, for what I can workout so far I need a "Split" function statement in the VBA for my Search button. I am not having any luck yet :banghead:.

It works if only one item is selected in each search field, as soon as you select more (i.e. shop 1 & 2 - which comes up in the search box as 1, 2) it doesn't work. Perhaps I need some sort of VBA statement for search button :confused:

OK, I will test that. I have a good news I managed to add the lookup table as a search field so now I can see and select different options in each field and select them using tick box ;), so problem 1 resolved! Problem 2 is still open :(.

Geotch, I had a look at the database and have got few ideas from it. The thing is, it does not let you select the Part Number if Shop is not selected. I want each search field to be independent until a selection is made on any of them. At the moment I have to select a Shop to see the PN's...

Many thanks Geotch. I have made some progress! I modified the rule in the query to Like "*" & [forms]![Form Name]![Field Name] & "*" and it ticked one of the boxes :-) Any more ideas about the other stuff ?

Hi Guys, I am new to Access and need some guidence. I am having some difficulty putting togather a small database (attached). Basically I want to be able to search for mutiple words and get the results There are 3 main columns in the main table 1) Shop 2) Part Number 3) Part Type...

Hi Guys, Is there any way I can use data in the row as a column header ? I only have 1 row of data which i want to use as a header to I can link it to other tables/queries. (Access 2007 query) Many Thanks :)

Hi Guys, I am new to MS Access and I have a tiny problem :rolleyes: I have genetated a table using a crosstab query and it gives the information as below 12/10 12/11 12/12 13/01 Part 1 1 2 Part 2...