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
|
Function posivariable() As String
On Error GoTo CapteErr
Dim lasq As String
Dim rst As Recordset
Dim letexto As String
letexto = "Il faut renseigner le fichier des salariés"
lasq = "SELECT Personnel.IDPersonnel, Personnel.Genre, Personnel.NomSalarie, Personnel.PrenomSalarie, Personnel.Login, Personnel.nivsecure, Personnel.DashboardType"
lasq = lasq + " FROM Personnel"
Set rst = CurrentDb.OpenRecordset(lasq, dbOpenSnapshot)
rst.FindFirst "login='" + Environ("Username") + "'"
If Not rst.NoMatch Then
numeroempl = rst!IDPersonnel
NOMPRENOM = rst!PrenomSalarie + " " + rst!NomSalarie
nivsecure = rst!nivsecure
DashboardType = rst!DashboardType
posivariable = "OK"
Else
If Environ("Username") = "Administrateur" Then
numeroempl = 0
NOMPRENOM = "Administrateur réseau"
nivsecure = 2
DashboardType = 0
MsgBox "L'application ne vous a pas reconnu mais vous êtes administrateur." + vbCrLf + letexto, vbInformation, "Attention"
posivariable = "Admin"
Else
numeroempl = 0
NOMPRENOM = "Utilisateur inconnu"
nivsecure = 1
DashboardType = 1
MsgBox "Vous n'êtes pas administrateur. Il vous sera impossible de configurer cette base" + vbCrLf + letexto, vbInformation, "Attention"
posivariable = "Rien"
End If
End If
rst.Close: Set rst = Nothing
Sortie:
Exit Function
CapteErr:
Select Case Err.Number
Case Else
MsgBox "Erreur " & Err.Number & ": " & Err.Description, vbCritical, "Module :Posivariable "
End Select
posivariable = "Rien"
Resume Sortie
End Function |
Partager