Generate Random numbers without duplication other than storing in the database

[renu_kj]

Hi,

Is there an option/ or a formula to generate random numbers without duplication...Currently i'm not storing the random generated numbers in the database.
Please help me..its quite urgent

[vb5prgrmr]

Use the Rnd function (see VB's help), with randomize. Use an array to hold the values, and use a sorting routine or just a simple For Loop structure to make sure a duplicate number is not generated.

Good Luck

[jinnie_gia]

Try using the RND([number]) in a loop to generate the nos. randomly....
TC

Hi,

Is there an option/ or a formula to generate random numbers without duplication...Currently i'm not storing the random generated numbers in the database.
Please help me..its quite urgent

[johnly]

Hi,

Is there an option/ or a formula to generate random numbers without duplication...Currently i'm not storing the random generated numbers in the database.
Please help me..its quite urgent

You can use the below function to return a random number

Public Function GetRandomNumber(Upper As Integer, Lower As Integer) As Integer
'Generates a Random Number BETWEEN the LOWER and UPPER values
Randomize
GetRandomNumber = Int((Upper - Lower + 1) * Rnd + Lower)
End Function

For preventing duplication you need to write seperate code to check each random number returned by this function against your the list of already used numbers.