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
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
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
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
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.