Search results

what a div! I was changing the join type in the overall relationship not for the query. Join 2 works. Thanks for your help rickster

Yes, records show up if and only if they have an experiment record. But to me this doesn't make any sense as 'Experiments' doesn't enter into the query. A join of type 2 between papers and experiments doesn't resolve this problem

Sorry, I'm having a bit of trouble understanding this. The join types can be set as 1,2 or 3. Could someone suggest which I might try for the relationship structure given above.... Thanks

Thanks that's helpful.... This is correct. I'm new to this and I'm not sure what you are refering to. Are you talking about the join types? again, not sure exactly what you mean here.

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

selecting unique records in query design solved, sorry.

Ok this is still a problem. 3 tables: Authors, Papers, Join. Authors ------- AuthorID AuthorName Papers -------- PaperID Title etc (unimportant fields) Join ---- AuthorID PaperID Authors and Papers relate to Join in one to many. Join type 1 in each case. Join table fields set to 'duplicates...

That works well. Thank you very much!

I thought you couldn't use Is Null with Like?

Yes I have tried that. The difference between that and the one above is that the 'Like.... & "*"' doesn't include null records. This is what I want it to do: 3 fields (for now) Field A Field B Field C If I enter text into fields A and B I want it to search using criteria for just those...

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

I figured out that this was due to me not including fields from the Join table in the search query. And in fact the requery of the subform was unnecessary.

Three Crow, Do you want information about the original Query the subform is based on or the Search query that I want it to requery/refresh/change record source to? At the moment the main form is based on qPapers. The subform is based on qAuthors. Authors and Papers are linked in a many to...

Do you mean in the query 'qSearch'?

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

Sorry. Do I just put this at the front of my existing criteria?

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

Thanks to both of you. Pat was right to suggest the Child/Master fields weren't set correctly.

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