If IsNull(Me.tb_ID) Or isNull(Me.tb_pwd) Then The below code will prompt user a MsgBox if either password or login ID is Null. This step is optional because you will verify the password anyway. When the Login button is clicked, the first thing we want to check is whether the user has not input any value. Private Sub Form_Load()Įnd Sub Step 4 – Login Form Button Click Event: Check Null login ID or password ![]() The insideHeight and insideWidth is to set Windows size for Pop Up Form. Everytime you load the login Form, login ID and password are cleared. Insert the below code in Load Event of Form. I name the User ID Text Box as tb_ID, password as tb_pwd. – login Button to verify password and navigate to the next pageīelow is an example of a login Form. – two Text Box, one is for login ID and the other is for password. In the Design View, you just need to make three Control: User_Type is to navigate to different Form for different people.Ĭreate a Form called login. Step 1 – Create a TableĬreate a table that store the verification information. The one I am going to demonstrate must not be the best, but will fulfill your basic requirements. There are many tutorials in Google about making user login Form, some of them make a lot of error handling and conditions. ![]() This Access tutorial demonstrates how to create user login Form, verify password, create user level / privilegeĪuto Run Access Form using AutoExec Access user login Form
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |