Greetings:
I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution. I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).
The database I'm working on will generate tens, perhaps hundreds of
thousands of records, each of which need to be identified uniquely.
Using the autonumber would be ideal except that I'll need to use this
unique field to generate barcodes which will have to be printed on
small labels. So - If I get to record 999,999 and generate a barcode
for it, the barcode will be huge - or to big to fit on my label.
I think my solution would be to use letters rather than numbers.
Instead of counting 1, 2, 3, 4... 1,000; I want to count A, B, C, D...
ABCD. I guess my logic can be flawed, but I was thinking that since
there are 26 letters in the alphabet and only 10 numbers, I would be
able to get quite a bit farther in each place value using letters.
Thanks a bunch for any suggestions!
Matt