Private Sub recherche_contrat_Click()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim uSQL As String
Dim sSQL As String
cnn.Open "Provider=Microsoft.Ace.OLEDB.12.0; Persist Security Info = False;" & _
"Data Source=.\Projet\bdd_projet.accdb;"
uSQL = "Update contrat Set num_contrat = 'test2' Where id_contrat = 1"
cnn.Execute uSQL
sSQL = "Select num_contrat From contrat Where id_contrat = 2"
rs.ActiveConnection = CurrentProject.Connection
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Source = sSQL
rs.Open
<=== Afficher le contenu de rs dans texte15.text ===>
cnn.Close
End Sub
Partager