Wanted to create Multi User login System in access. For This I have completed following steps.
Note: for this I want users to login in the system by using their “Login ID” / UserID” which is created by system automatically.
(1) I created user registration form, it is working
(2) I have users table, which contains users info
(3) I created “Users Query” which creates “UserID / LogIn ID” based on User First Name and Name, which will they enter in registration form. This Users Query Source is User table.
What is Extra:
My user Query Table has extra field of “UserID/LoginID” which does not exist in Users Table.
(4) Problem:
How to bring this “UsersID/ LoginID” to login form, which should not be prefilled but user has to fill it by his own and system will recognize it whether it exists and correct.
NOTE: I am new to this, not an expert. So I am stuck at this step.
(5) If I had “userID/LoginID” in Users Table, then I would not had any problem, I would have created login form to link with that, also password etc as well.
Note: for this I want users to login in the system by using their “Login ID” / UserID” which is created by system automatically.
(1) I created user registration form, it is working
(2) I have users table, which contains users info
(3) I created “Users Query” which creates “UserID / LogIn ID” based on User First Name and Name, which will they enter in registration form. This Users Query Source is User table.
What is Extra:
My user Query Table has extra field of “UserID/LoginID” which does not exist in Users Table.
(4) Problem:
How to bring this “UsersID/ LoginID” to login form, which should not be prefilled but user has to fill it by his own and system will recognize it whether it exists and correct.
NOTE: I am new to this, not an expert. So I am stuck at this step.
(5) If I had “userID/LoginID” in Users Table, then I would not had any problem, I would have created login form to link with that, also password etc as well.
- Now only my problem is with, when “LoginID” created by the system automatically is existing in the UsersQuery, don’t know, How to code this to bring to login form, to be workable for users who have registered in system.
- Can some one explain me or refer me to youtube video, which is explaining this that Data Picking from Query and matching it with the User who is logging in.
- Thanks in advance.