Private Sub CmdPremier_Click() If DataEnvironment1.rsMachine.RecordCount > 0 Then DataEnvironment1.rsTableClients.MoveFirst End If End Sub Private Sub CmdDernier_Click() If DataEnvironment1.rsMachine.RecordCount > 0 Then DataEnvironment1.rsTableClients.MoveLast End If End Sub Private Sub CmdPrécédent_Click() With DataEnvironment1.rsMachine If .RecordCount > 0 Then .MovePrevious If .BOF = True Then .MoveLast End If End If End With End Sub Private Sub CmdSuivant_Click() With DataEnvironment1.rsMachine If .RecordCount > 0 Then .MoveNext If .EOF = True Then .MoveFirst End If End If End With End Sub With DataEnvironment1.rsMachine .AddNew .Fields("NumService") = "C1" .Fields("NomService") = "IT" .Update End With Private Sub Cmdvalider_Click() DataEnvironment1.rsMachine.Update SSTab1.Enabled = True End Sub Private Sub CmdAnnuler_Click() DataEnvironment1.rsMachine.CancelUpdate SSTab1.Enabled = True End Sub Private Sub cmdsupprimer_Click() If MsgBox("Voulez vous supprimer", vbYesNo + vbQuestion, "GSC") = vbNo Then Exit Sub End If DataEnvironment1.rsTCentre.Delete If DataEnvironment1.rsTCentre.RecordCount > 0 Then DataEnvironment1.rsTCentre.MovePrevious Else DataEnvironment1.rsTCentre.AddNew DataEnvironment1.rsTCentre.CancelUpdate End If End Sub
EDIT : Ajout des balises de code (la coloration syntaxique).
Explications disponibles ICI Merci d'y penser dans tes prochains messages. |
Private Sub cmdAdd_Click() On Error GoTo AddErr DataEnvironment1.rsMachine.AddNew Exit Sub AddErr: MsgBox Err.Description End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Command1_Click() With DataEnvironment1.rsrouteurs .AddNew ![Marque] = txtMarque.Text ![Modèle] = txtModèle.Text ![Emplacement] = txtEmplacement.Text ![AdresseIP] = txtAdresseIP.Text .Update End With End Sub