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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| Private Sub VALIDER_Click()
'Appel d'une variable
Dim valide As String
'Rechercher le mot de passe correspondant à l'identifiant
If IsNull(DLookup("MDP", "T_UTILISATEUR", "[ID] = Forms!F_IDENTIFICATION!TXTID")) Then
MsgBox ("Identifiant inconnu !")
Me.TXTID.SetFocus
Me.TXTID = ""
Else
valide = DLookup("MDP", "T_UTILISATEUR", "[ID] = Forms!F_IDENTIFICATION!TXTID")
'Si le mot de passe inscrit n'est pas correct alors
If (Me!MDP <> valide) Or IsNull(Me!TXTID) Or IsNull(Me!MDP) Then
'Message
MsgBox ("Mot de Passe incorrect !")
Me.MDP.SetFocus
Me.MDP = ""
'Sinon
Else
securite = DLookup("Utilisateur", "T_UTILISATEUR", "[ID] = Forms!F_IDENTIFICATION!TXTID")
Select Case securite
Case "ADMIN"
'DoCmd.Close acForm, "F_IDENTIFICATION"
DoCmd.OpenForm "F_MENU"
Case "GESTPRIN"
'DoCmd.Close acForm, "F_IDENTIFICATION"
DoCmd.OpenForm "F_MENU"
Case "GESTSEC"
If Me.Connect = False Then
Me.Connect = True
Else
MsgBox "deja connecté ", vbInformation
End If
' Forms![F_IDENTIFICATION].Visible = False
'DoCmd.Close acForm, "F_IDENTIFICATION"
DoCmd.OpenForm "F_MENU"
Case Else
End Select
End If
End If
DoCmd.SetWarnings False
'Appel d'une variable
Dim Insert As String
'Insérer dans la table T_Connexion l'identifiant et la date et heure de connexion
Insert = "INSERT INTO T_Connexion ([ID], DATE_HEURE) " _
& "SELECT '" & Me!TXTID & "',#" & Now & "#"
'Active la variable
DoCmd.RunSQL (Insert)
'Réactive les warnings DoCmd.RunSQL (Insert)
DoCmd.SetWarnings True
'Fermer le formulaire
End Sub |
Partager