While in design view, select the form (as shown below).
Now, we are going to change some of the properties of the form for aesthetic purposes and most importantly, for making sure that users cannot bypass this form without entering the correct login details.
While in design view, select the password textbox.
Next, change the input mask of the password textbox so that it will also be displayed as a series of asterisks (*). We are going to refer to these form controls in our code later so it would be best to rename them so that they can be easily identified:
Close the table and save the changes made.Ĭreate a blank form with 2 textboxes and 2 command buttons (as shown below).
Open the table in Data Sheet view and enter the first record (your login details).
When the Input Mask Wizard pops up, select Password.
Edit the password’s input mask so that it will be displayed as a series of asterisks (*).
Add the following fields with their corresponding data types:.
Create a new table and name it as tbl_login.
The first thing that we need to do is to create a table that will store all the login information. Steps to Create a Login Form in Access 1. Otherwise, if you want to DIY, you can read the contents below. If you want to start to use the feature as soon as possible, then you can:ĭownload the Sample Database with VBA Codes Now Follow the steps below so you can create your own login form to protect your database from invalid access. A login form is a must for databases that contain sensitive information.
0 kommentar(er)
