If you Login into my sample as TEST3 you will see a menu item title Add/Edit Users it is a continuous form.
Would you prefer a form to Add and another form to Edit an user? Please provide your requirements.
Allan
Printable View
If you Login into my sample as TEST3 you will see a menu item title Add/Edit Users it is a continuous form.
Would you prefer a form to Add and another form to Edit an user? Please provide your requirements.
Allan
im sorry allan,but i dont know where to find TEST3..maybe you can provide another to me,it will be my pleasure =)
edit by admin: no contact info permitted on the forum, thank you
Hi Allan,Quote:
Originally Posted by Allan Murphy
I was wondering if you still have this login form available. I'm kinda new to databases and was wondering how to use a similar login for an existing database. At the same time do you know how to change the first window/form that appears when opening a database?
Thanks!!
The sample database is an attachment to one of my replies on the page 1 of this thread.
What do you mean how to change the first window/form that appears when opening a database?
You can set a form to be displayed when the database opens by going to the menu bar select Tools, then select Startup from the dropdown menu, a dialog box is displayed, then in the Display Form/Page, select the form you want to display when the database opens.
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
Ronald
The sample database is an attachment to one of my replies towards the bottom of page 1 of this thread.
Hi Allan, Im have created a database and need to apply the security settings 3 levels as you have done to show certain buttons for the 3 levels. I Have looked at your code and still can seem to understand what you have done. Can you please help!!!!!!!
I am not using the Security Level settings available in Access.
I have a table tbl_users that has the user's details, the field access_level is a term that I use to determine the menu items (switchboard) that will be displayed when the user logs in.
Briefly this is how it works.
- User Logs in with an User Id and Password.
- User clicks on ENTER
- Module display_menu in mod_display_menu is called
- variable valid_user is initially set to 2 as a flag inidcate a valid user.
- Variable check_user is check if the user_id exists in tbl_users.
- If it is a valid user then the user's password at login is checked against the password in tbl_users.
- if the user id and password are correct then the user's access level is obtained. This access_level will be used to displayed the relevant menu (switchboard).
- The Select Case valid_user. Case 0,1 are for invalid user id or password. Case 2 is for a valid user.
- The Select Case access_level is used to display the relevant menu. The variable password_period is used to check the expiry date of the password. If the password has expired then the user is FORCED to change their password by opening the form frm_change_password. If the password has not expired then the switchboard is displayed relevant to the access level. If for some reason there is an invalid access_level a message is displayed to the user.
- When the form frm_change_password is displayed the user must change their password, the password expiry date is set to the current date plus 30 days. Then the relevant menu is displayed using similar code for the access_level in the above Select Case access_level in the form frm_change_password.
Contact me if you still need more information.
Hi Guy,
I downloaded the attached file. But, it did not work with the password you provided with the txt file.
Also, I CANNOT open any OLD db file from now. Access need to input login and password every time.
How come?:eek:
Hi
I am Logan. I need the form design and coding for the first time as sample. Thanks & Regards.
Loganathan.R
Quote:
Originally Posted by Allan Murphy
Look at message 10 on this thread
I will appareciate your help on how to create a user login form which i can link with a database table,using MS Access 2003.
Thanks,
cutebj.
Message 10 on this thread will give you some ideas. Otherwise post your requirements.
[QUOTE=meLady]Hello,
I have a table called "users", it has four fields "username", "password", "Login Time" and "Log out time"
I have a form called "User Login Form". It has two text boxes and a button as following:
1- txtUsername
2- txtPassword
3- btnClick
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 is not correct the error message will appear. If it correct, then the required form will be displayed.
What do I do?
I would be glad if any body can help with with this.
Thank U.
Please read through the thread and if you still require more information please post your question to the forum I will assist you.