Recent content by csharrock69

I'm not, but on re-reading my post I can see why you may have interpreted it in that way. It should read "Query Giving Undesirable Results". Regardless, thanks for your suggestion, the SQL for the two queries is: qryTPAExpiry: SELECT tblTPACyclesUsedIn.ID, tblTPACyclesUsedIn.[Cycle Used]...

Dear all, Please may I summon your assistance in getting to the bottom of an access query-related problem! There are two queries in the attached example database which act as a means of calculating when an item (called a TPA) expires and can no longer be used. Once a TPA is used in a cycle...

Thank you so much PaulO! This has been bugging me for a while and I never realised it was this simple! :D The second query is the one that actually answers the question in my first post. For anyone who may find this useful, the solution has been implemented into the attachement. Thanks...

*SOLVED* Badly Behaved Query! Dear all, Please could I call upon your expert assistance in solving this query related problem? Attached is an example database with the query in question. The plan is to determine when a component (called a TPA) reaches its “use by” date. This happens to be...

Thank you! It does exactly what I want it to do now. Kind Regards Chris.

A kind request to all you access gurus out there: I’ve been trying to construct a query that will display the list of objects used in a particular cycle. For example, the search results will return a list of objects only used in cycle 1 when a “1” is entered into the textbox. Ok, that bit was...

Hi John After testing your example that you mentioned in the link, it seems that the search doesn't show all records based upon the criteria entered in the text box. It appears that if there is a blank field for that record in one of the related tables, the search does not show that record at...

Oh right. So to save extra sweating over code (if access even has the capacity for searching on multiple strings), the issue could be overcome by having multiple search boxes- one for each string.

Hi Dave To clarify, I can confirm that I dont understand what you mean by: One object (main form) can have multiple documents associated with it. These documents are listed within the subform. Some objects have no documents while others have one or more documents. This one to many...

Hi John, thank you for your rapid and helpful reply. Just tested the sample you refer to above and it's great! It sets out what I wanted to do however there has been an issue with it and I would like to call upon your wisdom once again please! When in form view on the form FRM_SearchMulti...

Hi I need to search for criteria found in a subform which when found then goes to the record in the parent form. There may be multiple records which share the same criteria so this project needs to be able to go to all records that share that criteria (essentially a "go to next record...