Search results

If the user inputs two words (or names in this case) such as "Bloggs Smith", how could I get it to return records with Bloggs & Smith in whatever order they were input? Example: Author: Smith, Medin & Rose User searches: Smith Rose ..........and it returns a hit for Smith, Medin and Rose...

Thanks. This is clearly the way to do it.

DirectorMac - Yes was trying to learn how to use subforms, but my Access book says very little. Do you have a good link (somewhere on this forum?)

Didn't spot the right mouse click option on the relationship. Have now set it to 2 (Inc. only experiments that match the correct specified field). But now I cant get a form to use this query as a record source!!! I have the form's control source set to the query, but selecting a source for a...

Hi I have a one to many DB. One 'Paper' (academic journal articles basically) can contain many 'Experiment' records. I'm also thinking about adding another table of Authors, so one Paper can have many Authors, but this is not that important here. I am wondering whether it is possible to have a...

Yes that works very well but any ideas on how I might do this.... If the user inputs two words (or names in this case) such as "Bloggs Smith", how could I get it to return records with Bloggs & Smith in whatever order they were input? Example: Author: Smith, Medin & Rose User searches: Smith...

Thanks, that's useful for setting and fixing the size of each form and stopping the user from changing the size. But what if i wanted to position the forms in the top hand corner of the screen while working in other windows? Any suggestions on how you'd begin to do that? Is it possible to...

well that was simple. Many thanks.

Hi Cant find much information on this... I have a bunch of forms now, that all link together but I only ever have one on screen at a time. What I'd like to do is find a neat way to present these on screen, i.e. center them or get them to be the same size and appear in the same position as the...

Hi I've searched this forum but dont seem to be able to find the right info on this.... I have a form that passes parameters to a query (a user search form). I want it to display records based on the following criteria: 1. If Null display all the records 2. Use wildcard values (i.e. "Blog"...