Search results

  1. F

    Correlation between two records of the same table

    Hi @MajP, I have temporarily set aside the problem of the double-click code because I would first like to resolve the issue of not only unilateral relationships between products. Following the way you approached the problem posed by KitaYama, I recreated a sample database of my own and found...
  2. F

    Correlation between two records of the same table

    I think I don't understand where I have to insert the msgbox in the code?
  3. F

    Correlation between two records of the same table

    For my part it is not necessary, because what I am looking for is what you expressed in the screenshots, that is, I think we are looking for the same thing
  4. F

    Correlation between two records of the same table

    @KitaYama You don't have to apologize, on the contrary, you allowed me to understand that my concept of relationship (similarity) was wrong: I took it for granted that every relationship between two products was unidirectional and that many products were potentially related to many others, at...
  5. F

    Correlation between two records of the same table

    I tried to insert this wonder into my database, but unfortunately I can't make the double click work, I'm sure I'm doing something wrong in the code but not what, could you look at the screenshots? Thanks again
  6. F

    Correlation between two records of the same table

    I'm amazed! How did you do it in such a short time? Thank you very much, really. Now I carefully study everything so I can understand it and see how I can apply it to my database. Thanks again from the bottom of my heart
  7. F

    Correlation between two records of the same table

    This is another sore point. What essentially makes them similar is the function, at least in the case of equipment, while for clothing it may be the type, etc. In this case tags would be useful, but honestly I've never heard of them applied to Access
  8. F

    Correlation between two records of the same table

    Yes, you have fully understood the meaning of what I would like to do. It's not clear to me how you can add items from the subform that contains all the products to the selection list
  9. F

    Correlation between two records of the same table

    There are not many associations to make for each product, but there are many products to scroll through to find the ones I need to associate. Let me explain better: if I have to associate product A with B and C, I have to look for B and C among thousands of articles, that's why I thought of the...
  10. F

    Correlation between two records of the same table

    I apologize for formulating the request in my language instead of English. Yes, I use Google Translate, without realizing I must have copied my sentence in Italian instead of English. @Pat Hartman Your interpretation is very correct, with the expression "related products" I was thinking (I was...
  11. F

    Correlation between two records of the same table

    Grazie a tutti, ho provato a seguire le vostre indicazioni per quanto riguarda la tabella di giunzione, ma purtroppo non ci sono riuscito, come potete vedere nel file allegato. Principalmente, però, non capisco come si facciano a collegare molti prodotti ad uno solo, tutti appartenenti alla...
  12. F

    Correlation between two records of the same table

    Hi everyone, I have a database in which I have inserted the products of my business, now I would like to specify the similarities that exist between the articles, for example product A is similar to product B and product C. I have a Products table on which the "Product Sheet" form is based, I...
  13. F

    Weird symbols in a Long Text field on a form

    Thank you! In the form I changed the "Control Source" associating it to "PrimoDiMioCampo" and everything works perfectly. Thanks again
  14. F

    Weird symbols in a Long Text field on a form

    Thank you. Yes, my problem is precisely the one covered in the article. If I insert "First" instead of "Grouping" to the two fields with Memo Text, I resolve in the query, while instead in the form on which the query is based, the words "#Name?"
  15. F

    Weird symbols in a Long Text field on a form

    I realized that the problem is already present in the query on which the form is based; is a query with Grouping, if I remove this function everything goes back to normal, that is, the strange characters disappear
  16. F

    Weird symbols in a Long Text field on a form

    Good morning, suddenly for some days in a field of type Long Text, in Mask mode, strange symbols appear. If, on the other hand, I open the reference table, the text is written correctly. How can I solve this problem?
  17. F

    Solved two cbo in subform

    Can anyone help me?
  18. F

    Solved two cbo in subform

    With the screenshots I sent in the previous message everything works. The problem starts with the settings you see in the following screenshots
  19. F

    Solved two cbo in subform

    I try to insert screenshots, hoping you understand
  20. F

    Solved two cbo in subform

    As I said I used the code from the attached file 3 posts above mine, the only change I made is to add the same code to the extra combo box, so no need to read the mind, just look at the attached example code, that's what I asked for info and I thank those who can help me.
Top Bottom