How to create user login form (MS Access 2000 - 2003)
Hello,
I have a table called "users", it has two fields "username" and "password".
I have a form called "User Login Form". It has two text boxes and a button as following:
1- txtUsername
2- txtPassword
3- btnEnter
I would like to link these textboxes with a table. The idea is that the user must enter his/her username & password in the mentioned text boxes. Then, the user will press the enter button.
So the system will varify the input, if it not correct the error message will appear. If it correct, then the required form will be displayed (^_^).
this process is very new for me and I would like to learn it and I would be more appreciate with your kindly assistance.
Re: Log-in form in Microsoft Access
Good day!
Can you please send me a copy of Log-in form in Microsoft Access? I also want to use such kind of form instead of using workgroup security.
Thank you in advanced...
Hope to hear from you...
Thanks once again...
Ronald
Storing user_id for later use
Good afternoon,
I have used your login form and it is quite useful and easy to adapt to my needs. I have several processes that run and I would like to stamp them with the user_id that initiates them. I have tried to work with the user_id from the main login screen but have not been successful.
I have limited VBA experience and I was wondering if there is an easy way to 'store' the user_id data for use later?
Thank you.