Code for Creating random letter combinations, but there are duplicates

T

Telesphore

Thanks to James A. Fortune in the Newsgroups comp.databases.ms-access with
the title "Creating random letter combinations", I execute the code he
proposes and there were 500,000 combinations generated. This is more than we
need to give passwords to our students.

But then, I realized that there were many duplicates.

Somebody can give me the code to avoid the duplicates? Or a query to delete
the duplicates in the tblOutput?

Any help will be appreciated.

Thank you in advance.

P.S. I am not a VBA expert!
 
T

Telesphore

Sorry!

I forgot to run the query qryLetterPaths

I should have read ALL the instructions.

Thanks again to James A. Fortune
 
Top