423,516 Members | 2,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,516 IT Pros & Developers. It's quick & easy.

Validate Password Creation with Criteria

P: 2
I want to set requirements for password creation (see example).

Example:
Xray2319! (form entry) Accepted
ray05 (form entry) Rejected

Requirements:

At least 8 characters.
Must contain:
1 Uppercase
1 Lowercase
1 Special Character ( !@#$%^&*` )
1 Digit (0-9)
May NOT contain:
First Name
Last Name
Username
Employee ID

I hope this isn't too confusing. I am relatively new with VBA and trying to learn the best that I can. I have created basic login forms but I have always disliked not knowing a way to implement password requirements.

Note: Using Access 2016

Appreciate the assistance!
1 Week Ago #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,608
tjb0205,

Welcome to Bytes!

You really have two, very distinct and very different questions here. I will split this one thread into two threads, so folks who have questions more similar to one or the other will be able to find them.

This might also help you focus your efforts on one problem at a time--even though these issues are related.
1 Week Ago #2

twinnyfo
Expert Mod 2.5K+
P: 2,608
I think the short answer is to examine the User's entered password character by character, see if the characters meet the criteria and when all the criteria are met, then the password is accepted.

You say you are relatively new to VBA, and that's fine. However, we typically don't build the solution for you. We will expect you to have something started that we can troubleshoot with you and help guide you toward a viable solution.

Hope this hepps!
1 Week Ago #3

NeoPa
Expert Mod 15k+
P: 31,047
Please see my answer in your other thread (How can I Validate a User entered the Correct Password?).

Short answer - just don't do it!
6 Days Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.