Create a simple login form in visual basic 6.0 using ADODC control and Microsoft Access 2003 database-Step by Step demonstration.
After watching this video,you will be able to create a login form where multiple users can logged in and use the system.
In this Video tutorial,following points are discussed:
1.How to create a database and store the login credentials of different Users using access for VB login app.
2.How to Create a login form and do database connectivity with access .
3.How to do the authentication of users using some SQL commands and a piece of VB code.
Tutorial is only for Beginners,No validations rules are applied or followed while developing this login form.
No step is skipped while demonstration.All steps are explained with written text.
Source Code:
LOGIN BUTTON
Private Sub loginbtn_Click()
loginado.RecordSource = "select * from Logintab where Username='" + txtuser.Text + "' and Password='" + txtpass.Text + "'"
loginado.Refresh
If loginado.Recordset.EOF Then
MsgBox "Login failed,Try Again..!!!", vbCritical, "Please Enter correct Username and Password"
Else
MsgBox "Login Successful.", vbInformation, "Successful Attempt"
welcome.Show
End If
End Sub
CANCEL BUTTON
Private Sub cancelbtn_Click()
End
End Sub
Please Leave a comment and Subscribe to my channel :-)
