I have a large number of computers arriving for our computer refurbishing project (http://helpingtulsa.org
) and I need to generate a sequential series of numbers, each with a check digit, which I can print out on Avery Labels (#5160 30 labels to a sheet), so I can stick a label on each computer, and then when it is processed manually type in the number on the label and have the check digit make sure I did not transpose digits when typing in the number.
(1) How can I generate let us say 20 sheets at a time (600 lables), such that the 600 numbers are all unique and include a check digit, and the next time I generate another 20 sheets they use different numbers
(2) When I am manually updating the database how can I put validation in an Access Form to perform the checkdigit calculation on the entered number.
I realize many checkdigit routines are based on bar coding, and I don't object if the label includes a bar code version of the number as well as a human readable version, but right now I don't have a bar code wand available everytime I might want to read a number, so the label must have a human readable number, whether it has a bar code readable one or not.