Generate 3 random letters 1

[MrM121]

Hi, can anyone please tell me the code to create 3 random letters, I can do numbers but I'm not sure about letters.

Thanks,

Nick

 

[MacCaillean]

Hi MrM121

Generate a random number (between 97 and 122 for lower case letters, for example) and then use the

Chr

function to return the lower case letter that corresponds with your number.

Regards

Mac

 

[MrM121]

ok, I get you, but how do you generate the random numbers between 97 and 122?

Thanks for you help

 

[cpaige]

Here:
'122-97=25
c = chr(CInt(rnd() * 25) + 97)

That should do it




Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[MacCaillean]

Clayton's got it ...

 

[MrM121]

Thank you very Clayton, I owe you a pint!

Nick

 

[cpaige]

No Prob

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[MrM121]

I don't suppose you know how to search all the fields in the Access hidden tables for a string, and then replace that string with another?

Nick