Auto Numbering and Label Question

  • Thread starter Thread starter Amy Murphy
  • Start date Start date
A

Amy Murphy

I have a few questions that I hope someone can answer. I am supposed to
design a database for my supervisor and I'm not an Access guru. ;-) This is
the gist of the database:
He wants to be able to print multiple labels for parts we manufacture using
a database and to be able to give them random serial numbers.

I know how to do the basic Access stuff...I've "designed" two databases for
school, but he's stumping me on this. Anyway....

I need to be able to assign random serial numbers to parts that we
manufacture. Using autonumber, is there a way to do it with at least 5
numbers? And I need to be able to print multiple labels using the same part
number (that is ONLY in the database once) but with different serial
numbers.
Can anyone help me?! ;-) Email address is: (e-mail address removed) if you wish
to reply privately. Thanks!
--



Amy Murphy

My greatest fear is that there is no such thing as PMS & this is really my
personality.
 
Amy Murphy said:
I have a few questions that I hope someone can answer. I am supposed to
design a database for my supervisor and I'm not an Access guru. ;-) This is
the gist of the database:
He wants to be able to print multiple labels for parts we manufacture using
a database and to be able to give them random serial numbers.

I know how to do the basic Access stuff...I've "designed" two databases for
school, but he's stumping me on this. Anyway....

I need to be able to assign random serial numbers to parts that we
manufacture. Using autonumber, is there a way to do it with at least 5
numbers? And I need to be able to print multiple labels using the same part
number (that is ONLY in the database once) but with different serial
numbers.
Can anyone help me?! ;-) Email address is: (e-mail address removed) if you wish
to reply privately. Thanks!
Click to expand...
There are several solutions to printing multiple labels. The one in the
Access developers handbook by Getz and Litwin is good and the code is
included with the book. A good investment.
You can set up an autonumber and use random type. This will almost guarantee
a random number if you use the whole thing.
If you use part of it it probably will do.

HOWEVER.

If your numbers are random there is absolutely no reason why you may not get
duplicates. In fact if you don't they are not random.

If you want essentially random with no duplicates there is one fairly easy
way.
Fill one column of a two dimensional array with numbers from 1 to whatever.
Fill the other column with random numbers (there may be duplicates but we
don't care)
Sort on the random numbers and the other column will be in a pseudo random
order with no duplicates and no need for code to check for dupes.
 
Back
Top