Search results

Jobs a goodun! That works lovley - thankyou very much

AHH, nice - any ideas how? cheers

Hi all, A bit of a longshot me thinks! But anyway... can you make a measurement converter on Access 2013. I would like to be able to convert meters into feet and feet into meters! Thanks

Hi all, When I make a search using a search form, I get a table with the results that match. Can I make a link from this table to a report to display the details of the matching product? One of the reasons I need to do this is because one search may bring up more than one product...

So I have a range of trailers. Each range has various models (different sizes etc) These are all in one form for each range. I then have a page to search for a model in the range. I would like to hit search and the model that would fit the search is displayed. hope this makes sense

Hi, I have made a query to search for some items on a table. I want there to be a button on the search form that says 'search' and takes you to the corresponding page on the form. (The form has multiple pages in, all with different products on) Is this possible?

Hi there, I am at the point where I want to click search, on my search form, and the database shows the results in a report. I know I need to type in some code but I am unsure what it is? Any ideas or examples would be appreciated please! Thanks

Hi all, My search form has, say, 5 search boxes. Eg. Vee Cathederal RIB Keel Lifting Keel I need to have all the boxes visible and searchable. BUT I only want to search one or two at a time. How do I do this? Thanks

Thanks for that - Just a quick question. When you have multiple search boxes that don't need to be searched at once (I have 10 search boxes, boat only 1 is to be searched at once for example) do you put "*" & before and after the expression?

Hi, In my table I have the following fields that are tick boxes Vee Cathedral Round Bilge Bilge Keel RIB Semi-Displacement Keel Lifting Keel Each record can take a couple of these options. For example record 1 could be ticked for a 'vee' and a 'cathedral' whereas record 2 could...

Yes - I completely agree - I have just done what you suggested and it has worked perfectly! Thanks, I didn't put the { Like "*" & } in. If I put the "*" & this means that search box doesn't have to have data in to search another field. is that correct?

Thanks, that is what I am after, I suppose it would be Like "*" & <=[Forms]![Boat_Trailer]![Max_Length] AND >=[Forms]![Boat_Trailer]![Min_Length] "*" &

Hi all - 1st post so a little introduction - I am 17, my father owns a towbar and trailer company and I am making a database so he can search for a trailer to suit the boat. I have fair knowledge of Access, making one for an estate agency company in my year 12 school project. In the Table I...