vbjohn

On this part of my code I am doing a randomized letter generator. What is going on is that it comes out duplicate. How can I fixed it?

FOR i = 1 to 2
Randomize()
For forUserIdCharacterCount = 1 To 80
rndNewUserIdCharacter = Int((90 - 65 + 1) * Rnd() + 65)
strNewUserId = strNewUserId & Chr(rndNewUserIdCharacter)
Next
Next

John

Take the Randomize out and put it once in the Form_Load. Then see if the problem continues. Randomize should only be called once.

ElderKnight

I think you *are* getting new letters appended to your string at the end, but because you're not clearing it out (e.g., strNewUserId = "", maybe just bnefore the second "For") you're not seeing them -- they're off the far right of the screen.

You should also move the Randomize statement out of that loop. Call it only once at program start.

loquin

You'll probably need to flush strNewUserId after it's used. You are adding the second random number string to the end of the first.

Plus, as Elderknight said, the randomize sub should only be used onec in the life of your project.

Edit: Whoops. WAYYYY too late!