Search results

Hi. I have a many-to-many relationship set up which seems to be working fine. I have now created a query that requests criteria from a form (See gif for relationship and query design). The problem is that when i put in details for the first record the query works. however, for any other record...

I've got a query that does exactly what this chap got his to do. However I want to add a "*" character to the criteria to allow for searches with partial matches. Here's the criteria that works: [title]=[Forms].[Search]![Title] Or [Forms].[Search]![Title] Is Null However when I try the...

Hi. Having a bit of a problem getting a subform to requery/refresh after running a query from a seperate form. The seperate form is acting as a 'search form' and running query qSearch. I've tried various things (requery the form, subform etc) but here is the code I'm currently using: Private...

I have a search form passing text from unbound controls to a query. These two fields (AuthorName & Title) of the query are from two different tables (Authors & Papers) set up in a many to many join. The 3 dummy records I am using are as follows: Record 1 AuthorName: Smith (Author 1) Title...

At the moment I have a field 'Author' which is displayed using a subform. The user can cycle through the many authors that are associated with each record in the main form. However, what I'd like to do is to display each record simultaneously in the same control, and with a little bit of playing...

Sorry for posting yet another thread on many-to-many based queries, but mine aren't working and I need some pointers. I have downloaded and studied Pat's example of the many-to-many DB, and mine now looks fairly similar. Relationships have been properly defined, it's just that my forms dont seem...

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...

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...

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"...