1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Option Compare Database
Private Sub Connecter_Click()
Dim Rs As DAO.Recordset
Dim Reconnu As Boolean
Reconnu = False
Dim stDocName As String
Dim stLinkCriteria As String
Static i As Byte
Set Rs = CurrentDb.OpenRecordset("User")
Do While Not Rs.EOF
If Rs.Fields("Username").Value = Z_User.Value Then
If Rs.Fields("Password").Value = Z_Pass.Value Then
MsgBox "Ok"
Reconnu = True
On Error GoTo Err_Connecter_Click
stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Connecter_Click:
Exit Sub
Err_Connecter_Click:
MsgBox Err.Description
Resume Exit_Connecter_Click
Exit Do
Else
MsgBox "Erreur de mot de passe"
i = i + 1
GoTo Fin
End If
If i = 3 Then
MsgBox "Vous avez dépassé le nombre de tentatives autorisés", vbCritical
DoCmd.Quit
End If
End If
Rs.MoveNext
Loop
If Reconnu = False Then
MsgBox "Utilisateur non reconnu !!!", vbCritical, "Attention.."
GoTo Fin
End If
'Traitement suivants
Fin:
End Sub |
Partager