Generate auto number by code but not repeated.

[arun_kumar112]

dear sir,
i wish to generate auto number starting from 1000 to 1000000. but each time number automatically generated no duplicate number generate assign.
thanks,
arun kumar

[desperateinc]

Public Function Rand(ByVal Min As Long, ByVal Max As Long) As Long
  Rand = Int((Max - Min + 1) * Rnd) + Min
End Function
 

Example:

NextCard = Rand(1, 52)
 

Will pick a random number between 1 and 52.

[Killer42]

...Will pick a random number between 1 and 52.

There's actually a function like this in our Articles section. I know, because I wrote it. :)

To cover the second part of the question, you should allocate an array and store the numbers in it. Each time you request a number from your "generate a number between..." function, check it against the array. If it has already been used, ask for another.




Hm... I think I'll write a new version of the random-number routine which won't generate repated numbers. Stay tuned...

[Killer42]

Took a bit longer than planned, as I had to do some other things. But here is what I've got so far. I think it works.