Search results

Whou ! Now everything works just fine ! It was not very complicated, I don't understand why there is not a clear article about that somewhere. I am going to post my database later with full instructions. Thanks again everyone :)

Ridders I am actualy trying something, but here's the other problem: When I am filtering with other field (example: Description), the records with two Treatments to appear twice (like in a Query). I would like them to appear only once with the Treatment(s) in one textbox. I am trying to...

Ridders Thank you ! It works :) One problem solved

I just find a code that would allow me to stock all the Treatment in one row. I'll to try this tomorrow and see if it's works. Option Compare Database Option Explicit Public Function SimpleCSV(strSQL As String, _ Optional strDelim As String = "," ) As String 'Downloaded from...

Excuse me, what do you mean ?

Hummmm, I see. There is the Soil_T wich contain ID_Soil, the Treatment_T wich contain ID_traitement and Treament, and Treament_link_T wich contain ID_Soil and ID_Treatment. I am going to try this tomorrow morning ! This might solve at least one problem. Thank you! Still, I need to figure out...

jdraw Ok I was trying Something. When I do the Search with Treatment in a combobox, Nothing happen. But when I do the search with a textbox, there are results. (But I don't want to use the text box...) However, there a still duplicates of the same record if it have more than one treatment...

Pat Harman Like I said in my original post, it's a MV OR a many-to-many. You said MV were to much trouble, so I change it for a many-to-many Relationship. For the 2 table level lookups, it seems fine for the moment.

I got the version with the Treatment in the header as a filter too. But it doesn't work.

Ok ! Pat Hartman: Thank you for your exemple. However, I know how to do many-to-many Relationships. The problem is filtering. Records with many Treatment appear multiple times. Jdraw: This data base is use to store and find analyses of soil. I did a clean and English version of my data base. Ok !

My data base is done (well, draft version) except for the Treatment field in the Search form. In the header of the seach form, I can search with "Description", "Type",... it's going to work. In the result, the record is going to appear once ONLY IF the Treatment values are in ONE FIELD...

Hello everyone, I've got a big problem, so I'll try to be crystal clear. My Database My database contain informations about soil. The Soil_T have different fields : ID_Soil (Auto#), Type (linked to another table), description (long text)... and Treatment (Multivalued field or many-to-many)...

Allo Richard ! Thank you :) At least what you know in french is good ! I think in Québec we would say "je c pâ". Hahah, we've got some special speaking too.

Hello everyone, My name is Lesly and I am from Québec, Canada. Sorry for my bad English. I just started working on Access one month ago, so... I am not so good. But I tried hard and I am getting better. Thanks a lot already for all the help this forum gave me. Just by reading old posts I find...