Paul Lemelin
New member
- Local time
- Today, 04:19
- Joined
- Dec 1, 2022
- Messages
- 9
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 some information about the product, including quantity, and Access runs some code to store the pertinent information and spit out 1 or more serial numbers. If there is a quantity greater than one, the serial numbers are expected to be consecutive. In the past there was never an issue with non-consecutive serial numbers because each department only had one person issuing serial numbers and they were only pulled from their pool of suffixes.
Now the company would like all departments to pull from one pool of serial numbers, starting with AA0001. The problem I'm having is a situation where two or more people are pulling serial numbers at the same time. Some requests are for up to 50 or even 200 serial numbers. How can I top person2's request from running until person1's code has finished?
Disclaimer, I'm not a programmer. I cobbled together the current code using the VERY little bit of knowledge I gleaned from playing around with VB 20+ years ago, and a whole bunch of code samples from the web.
Now the company would like all departments to pull from one pool of serial numbers, starting with AA0001. The problem I'm having is a situation where two or more people are pulling serial numbers at the same time. Some requests are for up to 50 or even 200 serial numbers. How can I top person2's request from running until person1's code has finished?
Disclaimer, I'm not a programmer. I cobbled together the current code using the VERY little bit of knowledge I gleaned from playing around with VB 20+ years ago, and a whole bunch of code samples from the web.