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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top