1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| With EqpRst
If .State = 1 Then .Close
.Open "Equipement", Ocnn, adOpenKeyset, adLockOptimistic, adCmdTable
.AddNew
!code_eqpt = code_eqp.Text
!denomination = libelle.Text
!classe = classe.Text
!sous_classe = sousclasse.Text
!Type = type_eqp.Text
!etat = etat.Text
!date_fab = date_fab.Text
!date_mes = date_mes.Text
!num_serie = num_serie.Text
!model = model.Text
!puissance_installe = puissance.Text
!intensite = intensite.Text
!marque = marque.Text
!centrale = frmmenu.lblstatut.Caption
.Update
MsgBox libelle.Text & " enregistré", vbInformation, App.Title
End With |
Partager