Recent content by alex44

Pual, Thank you for your reply. You are correct - the following function calls were working. The error was in my logic in the function itself (I'm not very VBA proficient). Your suggestion of the break points cleared it up. Thanks, Alex

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...

Worked perfectly! Thanks!

Thank you for your reply. I will try to clarify. For the following sample data set: NUMBER | NAME ========================= 11111 | Red ------------------------- 11111 | Red ------------------------- 33333 | Blue ------------------------- 33333 | Green...

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

Thank you Pat. That does make sense. And, with my particular field, it is easy to separate the string. However, this still leaves me with the FK issue (See initial post); Because each tables PK only relates to the other table with a portion of it's characters, I can only achieve a...

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...

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...

Plog, Thanks for the reply! What about the relationships though? I stll have no FK's. Do I need them in a DB that I'm not updating, just querying?

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...

Thank you for your reply! Unfortunately, I am not at liberty to show any sample data due to the confidential nature of the material - can't even use real table and column names. :( What I can say is that one table is at a system level, while the other is at a piece/part level; The query...

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...

Paul, Thank you very much for your reply! You have confirmed my worst fears ;) I'll begin transfering the query to VBA. One question- what is the best way to output the results of the query from VBA? For example, one of my co-workers does this by creating a table in the DB that is simply...

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...