Request "select * FROM FACTURE where order order ;" Set rs = db.OpenRecordset(Request) rs.MoveLast If rs.RecordCount <> 0 Then 'ce n° d'order existe déjà Order = "" MsgBox "Erreur, ce n° d'order existe déjà", vbCritical rs.Close db.Close Exit Sub End If
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub BoutonOK_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim Request As String Set db = CurrentDb Request "SELECT * FROM FACTURE WHERE [Order] " & CInt(Order) Set rs = db.OpenRecordset(Request) 'ce n° d'order existe déjà If rs.RecordCount <> 0 Then Order = "" MsgBox "Erreur, ce n° d'order existe déjà", vbCritical rs.Close db.Close Exit Sub End If rs.Close Request = "select * FROM FACTURE" Set rs = db.OpenRecordset(Request) 'ajoute une nouvelle facture vierge: rs.AddNew 'remplit les champs des textbox: rs("Devis") = Devis rs.Fields("order") = Order rs.Fields("DateEcheance") = DateEcheance rs.Fields("encharge") = Employe rs.Fields("client") = Client rs.Fields("description") = Description rs.Fields("livre") = Livre rs.Fields("factureredigee") = FactureRedigee rs.Fields("factureverifiee") = FactureVerifiee rs.Fields("factureenvoyee") = FactureEnvoyee rs.Fields("Reclamations") = Reclamations rs.Fields("paye1") = Paye1 rs.Fields("rappel") = Rappel rs.Fields("paye2") = Paye2 rs.Update rs.Close db.Close End Sub