Recent content by dgoreth

Awww man... seriously? I just got it working. I was trying to join "CalID" to "NewToolName". As soon as I tried linking "ID" to "ID" it came to life. Thanks for the help.

Here is how they relate to each other: For example, we receive in a new 1" micrometer. We enter the tool into the "Tool" database, giving it its own unique calibration ID based upon location of the tool and the number of tools issued to that spot. (at the Swiss CNC machine 01 we have a Mic...

So there is no way to join these two fields? I really can't change the data types on them without breaking the rest of my functionality. The Calibration ID number in the calibration database is a lookup to the string in the "NewToolName" Field so that only the tools that are in the tool database...

I thought something like that, and did actually try joining CalID to NewToolName, but I get a type mismatch since the CalID is actually a lookup to the NewToolName field, and it won't allow it. Is there some other trick I should be aware of?

Hello! Hey guys. I am pretty new at Access, so bear with me a little. I have designed a database that is for calibration of all of our in-house tools. With this, I would like to add a report function that tells me what is due in the next week. I have one Table that contains all of the...

Hey everyone! Just wanted to formally say hello to everyone out there. Hmm.. Now about me.... I am pretty new to Access, but I have a long background in micro controller programming, IT, Calibration, Quality Inspection, and other tech roles. I work for a small company, and currently I am in...