Recent content by esrigby

Hi Mark! Thanks for your reply. I'll admit you're right that it would be a much easier solution to do that. Unfortunately, the purpose of our part IDs isn't just to have a unique identifier for each record in the database. Our part IDs get used in practical situations outside of a database...

Hi everyone! I'm making a stock control database at work and I'm caught up on this one feature. Each part we keep in stock for manufacturing has a part ID, PartRefID, which is formatted as 00-0000. The first two digits are the part type code. For instance, 11 is metalwork, 12 is hardware, 13 is...

Hi! I've learned a lot on this forum so it'll be great being a member here now. I'm in the UK using Access for work. I learned how to use Access on a much older version and I didn't get into SQL at that time, so my knowledge is pretty entry level, but I'm getting the hang of basic SQL now...