Search results

  1. A

    Calling multiple function on Form Load

    I'm trying to call a function multiple times, with different parameters, in the "Form_Load()" event. Unfortunately, it seems only the first call works; all following calls are ignored. I'm thinking that it may have something to do with the function already running when it's called the second...
  2. A

    Find duplicates with condition

    Hello all, I'm struggling to write the query bellow. Any suggestion are appreciated. (Using Access 2013) Sudo Code: SELECT * FROM MYTABLE WHERE COLUMN-A HAS COUNT > 1 AND COLUMN-B IS THE SAME In other words, find the duplicates that have the same value for column-b. Thanks! Alex
  3. A

    "Data should be single valued"

    I’m struggling with a particular table; it seems to me that it currently violates the “Data should be single valued” rule of database design. Or does it…..? Table1 has SYSTEM_ID, ModelA, ModelB, ModelC, ModelD and ModelC columns. The SYSTEM_ID column combined with one of the Model columns...
  4. A

    Table Relationships

    I’m trying to define a relationship between tables. However, the unique nature of my data doesn’t seem to be allowing typical relationships. Because of my inexperience, I’m not sure if I need to somehow create a relationship (junction table?) or just keep things as they are. Do I need a Foreign...
  5. A

    Table Relationships

    I’m trying to define a relationship between tables. However, the unique nature of my data doesn’t seem to be allowing typical relationships. Because of my inexperience, I’m not sure if I need to somehow create a relationship (junction table?) or just keep things as they are. FYI, I’m only...
  6. A

    UPDATE and ORDER BY

    The Problem: (In ACCESS 2007) I have a query with an INNER JOIN and ORDER BY that is working great. Now, using the same JOIN, I need to update values in one table with the values in another. I thought it would be simple until I learned you can't do an ORDER BY with an UPDATE. Is there...
  7. A

    Passing Column Name Parameter to Query

    Greetings! I am an Access newb and this is my first post to this forum. I've spent some time searching the forum and google, but I have not been able to find an answer to my question. SUMMARY: In Access 2007, can I pass a Column Name as a parameter from a Combo Box in a form? DETAILS: I...
Back
Top Bottom