Automatic Password

[zadjali2000]

Hi,
I want to know how could i do anything in ACCESS 2002 to automatically generate a password whenever i add a new member to my database. So can u help me in that. I just need a good idea and the way of doing it is not a problem.

 

[Emohawk]

I've just got a bit of code that generates a random number between 1 and 10 that is then passed to a Case statement that assigns a word to a String Temp and then another random number is generated (0-999) and added onto the end of that.

So you end up with something like

Fish789

Or

Tiger342