Search results

Thank you. I'll give this a shot a little later

After learning about setting a flag I decided it should be the userID but didn't think about the date/time or that it may become corrupted. Thanks for that! I started coding it yesterday but ran out of time as this is just one of my side projects at work that go along with my regular duties.

It is a split database. From my reading when I started this whole thing I learned that's the only way to go. Thank you

It's nothing like that, just an Access database with a few tables stored on a network drive. Thanks for the help, everybody, I'll try adding a flag stored in a table.

I'm not sure if you saw the other answer but they are created when the request is submitted. Here's what wrote then: The current code finds the last serial number entry for the requesting department, ex. 1235PA, strips the alpha, adds one to the integer, adds the alpha back then stores the new...

I have absolutely no idea how to set a flag. That works on a shared database? Would everybody have to be working from the same network file?

I'm sorry about that. The current code finds the last serial number entry for the requesting department, ex. 1235PA, strips the alpha, adds one to the integer, adds the alpha back then stores the serial number with the other info (part number, work order...). There is a bunch of other code that...

Hello All, I'm a QA Engineer (not software) for a manufacturing company, so I'm not a programmer but have done some coding - although very little. Most of my coding knowledge comes from a little bit of VB I learned over 20 years ago. What I've learned since then comes from the web. Also, 20+...

A few years ago I wrote some VBA code for my company in Access. The code issues serial numbers of a particular format, 1234AA, 1235AA, 1236AA...9999ZZ. This is a shared database with just a few (5-8) users in total, and each department is issued their own set of alpha suffixes. The user enters...