Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionAdodc1.Recordset.Fields("champ1").Value = Text1.text ...............??
Private Sub cmdajouter_Click() Set rs = New ADODB.Recordset Set cn = New ADODB.Connection cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\contrat_qualif2000.mdb;Persist Security Info=False" cn.Open rs.Open "SELECT max(numformation) as derniernum FROM type_formation", cn, adOpenDynamic, adLockOptimistic Text1.Text = rs("derniernum") + 1 rs.Close
Private Sub cmdvalider_Click() rs.Open "SELECT * FROM type_formation", cn rs.Update