System logon dialog box Summary

System logon Summary

Part 1 Background

1. Set the defalt attribute of the command button control to true. The button becomes the default button in the window. Other command buttons are automatically set to false. Press enter to activate them, other widgets with focus do not accept enter Keyboard Events.

2 Addo connection object. Used to open and establish a connection with the data source. The connectionstring attribute, open method, and close method are mainly used.

3ado recordset object. Used to save the records obtained from the data source. The active connection attribute, the EOF attribute fields set, and the open method are used.

4 trim function. Function: delete spaces at the beginning and end of a string.

5msgbox function. The dialog box is displayed. Variable = (information content, Dialog Box Type + icon type, dialog box title)

Feature of the second sub-system

1. Save the authentication information in the database and query the data during login to complete data verification.

2. added the limit on the number of logins function. Users can perform verification at most three times each time.

Part 3 implementation process and code

1. Create a database

2. design form

3. Create an ADO reference

4. Write functional code