Search results for query: *

"quite the norm" was refering to if one has only 3 available digits, 4 digit material won't fit. Like I said in my first post, it's been about a year since I've worked with Access and I wanted a quick reminder instead of looking through my notes and books. However, since you (Jeremy)...

Thanks for the input there Jeremy. You're insight is nice yet quite the norm. I used an example as T001, not an absolute. I'm trying to find a way where the primary key is an auto number in the sense that a user cannot pick the key and it automatically is filled in on the form, but also has a...

Thanks for your input. However, let me restate my question. What I am trying to do is have forms that input the data into the tables (obviously). So, on the form, I want the ID to fill in automatically with a logical progression from the previous given key. For example, I have a Customer...

It's been a year since I've worked with Access and I am now building a database for a financial company. I have the design and format all set up, but i forgot the controls and data type format for a primary key that is a letter-number combination (ie T001). Thanks in advance!