Recent content by tvu732

  1. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Uhm, thanks. I kind of know that, but I'm more familiar with Excel and still love the ability to see everything in a spreadsheet and move quickly between columns/rows when inputting data.
  2. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    I forgot to mention that some relations I will set for word pairs are hierarchical, so [word1] is kind of "broader" than [word2] (but not always). Therefore using alphabetical order doesn't work, but thanks for the idea.
  3. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Hi, Does this mean that I need to create a query and run it every time I want to check for duplicates? I still don't understand how to run the check automatically each time I update the table, because as far as I've learnt up until this point, running a query is a manual task. That's why I...
  4. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    I got the "first word comes before the second one" part, but don't understand what exactly myfunc is (googled and didn't find it). I'm still learning the ropes of the expression builder, let alone codes. :banghead: I really appreciate every answer in this post, each helped improve my knowledge...
  5. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    I see what you meant, but the composite key prevents the duplicate of the combo (Word1, Word2) in the exact order. If the new record is (Word2, Word1) it doesn't trigger any alert because this by definition is not a duplicate.
  6. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Hi, I got the part word1>word2, however could you explain more about myfunc(word2,word1)? I know virtually nothing about codes. :(
  7. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Hi, Could you explain the criteria "[Word1]='" & me.word2 & "' AND [Word2]='" & me.word1 & "'". I'm still learning and not very familiar with expressions. Thank you.
  8. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Thank you. It worked. But do I have to do this manually every time I add new records? I'm still new to Access, and although I've learnt some basic lessons, still trying to recall and apply them.
  9. T

    Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

    Hi, I am designing a vocabulary database. I want to create relationships between words within the database, so I make a junction table, add two fields (Word1, Word2) and another field for relations. I want to avoid the situation in which a word pair, for example (Word1 = A; Word2 = B) is...
  10. T

    Hello from Vietnam

    Hi, I'm absolutely new to Microsoft Access. I'm learning it at my own pace, first watching GCFLearnFree's lectures and now googling my way through the first database. I wonder where I can find more advanced lessons than GCF's ones (still, so much appreciation for GCF because their lessons are...
See more
Top Bottom