Member Avatar for 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

  • 4 Contributors
  • 3 Replies
  • 354 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by johnly
Member Avatar for 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

Member Avatar for 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

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.