Auto generate a number

[TopDawg]

I need to auto generate a number. I am trying to log trouble call tickets and auto assign a number when I create a new ticket. ( Not the Primary key number) I need it to be 4 or 5 random unique numbers long.

Thanks in advance

 

[faztech]

Try this TopDawg,
this will generate a random number between 4 and 5 character long

Dim ticketValue
ticketValue = Int((100000 * Rnd) + 10000)

Good Luck

Faztech

 

[faztech]

Opppps Sorry Topdawg put to many zeros in the random try between 10000 and 1000

Sorry

Faztech
:-D

 

[faztech]

Opppps Sorry Topdawg put to many zeros in the random try between 100000 and 1000

Sorry

Faztech
:-D