By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Creating a macro that will check password

P: 2
To whomever can assist!!

I'am doing a class project that involves creating an alumni database. It begins with a form where the user type is broken down into alumni or student. If you are an alumni clicking the button will take you to a form were you must enter in your username and password before going to a new form that will allow you to update your information.

My problem is that i can not creat a macro that will do the following:
(1) check to see if the username typed in the text box can be found in the table that contains all of the usernames and passwords.
(2) then it should do the same thing but with the password.
(3) If a proper username and password is typed into the text box then the form titled faculty1 should open.
(4) if false values are enter then a message box should appear saying "invalid user"

I don't know much about macros so detailed and ordered instructions would be nice if possible!!

Chris
Nov 28 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,661
There are other threads in here which deal with the matter in more detail, but simply, you can do a DLookup on the table that contains your usernames and passwords passing the values to be checked. If it returns a record then the values are ok.
MsgBox() etc should handle the rest for you.
Nov 28 '06 #2

P: 2
There are other threads in here which deal with the matter in more detail, but simply, you can do a DLookup on the table that contains your usernames and passwords passing the values to be checked. If it returns a record then the values are ok.
MsgBox() etc should handle the rest for you.

How do i perform a Dlookup.. im very new with macros
Nov 28 '06 #3

NeoPa
Expert Mod 15k+
P: 31,661
I suggest, for questions of that level, you should look it up in the help system.
Nov 29 '06 #4

Post your reply

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