'********************************************** ' Écrire le Code Nt dans la table DbBase * '********************************************** Public Function EcrireQuiDepot(qui As String) If TesterBD() = True Then Dim chemin As String chemin = cheminDbBase adoDepannage.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & chemin & ";Persist Security Info=False" adoDepannage.RecordSource = "quiDepot" adoDepannage.Refresh txtChemin.DataField = "quiDepot" If adoDepannage.Recordset.RecordCount > 0 Then adoDepannage.Recordset.Delete adoDepannage.Refresh adoDepannage.Recordset.Requery adoDepannage.Recordset.AddNew txtChemin.Text = qui adoDepannage.Recordset.Update adoDepannage.Refresh adoDepannage.Recordset.Requery Else adoDepannage.Recordset.AddNew txtChemin.Text = tempo adoDepannage.Recordset.Update adoDepannage.Refresh adoDepannage.Recordset.Requery End If End If End Function
'******************************************************************************************* ' Fonction qui verifier le code NT de la personne connectée a la base de données Depot * '******************************************************************************************* Public Function VerifierQuiDepot() Dim cnx As New ADODB.Connection Dim rst As New ADODB.Recordset Dim chemin As String chemin = cheminDbBase cnx.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & chemin & ";Persist Security Info=False" cnx.Open rst.Open "SELECT quiDepot FROM quiDepot", cnx While Not (rst.EOF) VerifierQuiDepot = rst("quiDepot") rst.MoveNext Wend cnx.Close Set cnx = Nothing End Function
Public Type_Module As String Declare Function wu_GetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) _ As Long
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOption Explicit Private Declare Function wu_GetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) _ As Long Public Function ap_GetUserName() As Variant Dim strUserName As String Dim lngLength As Long Dim lngResult As Long '-- Set up the buffer strUserName = String$(255, 0) lngLength = 255 '-- Make the call lngResult = wu_GetUserName(strUserName, lngLength) '-- Assign the value ap_GetUserName = UCase(Left(strUserName, 7)) End Function
'********************************************** ' Écrire le quelqu'UN dans la table DbBase * '********************************************** Public Function EcrireQuelquunReg(tempo As String) If TesterBD() = True Then Dim chemin As String chemin = cheminDbBase adoDepannage.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & chemin & ";Persist Security Info=False" adoDepannage.RecordSource = "qqcnReg" adoDepannage.Refresh txtChemin.DataField = "qqcn" If adoDepannage.Recordset.RecordCount > 0 Then adoDepannage.Recordset.Delete adoDepannage.Refresh adoDepannage.Recordset.Requery adoDepannage.Recordset.AddNew txtChemin.Text = tempo adoDepannage.Recordset.Update adoDepannage.Refresh adoDepannage.Recordset.Requery Else adoDepannage.Recordset.AddNew txtChemin.Text = tempo adoDepannage.Recordset.Update adoDepannage.Refresh adoDepannage.Recordset.Requery End If End If