1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Private Sub Ajouter_Click()
DoCmd.SetWarnings False
Dim SQL As String
SQL = "INSERT INTO Distributeur(Numero_pays,NomDistributeur,adresseDistributeur,CodePostalDistributeur,villeDistributeur,Numero_tel,Numero_fax,Remarques,idLisa)"
SQL = SQL & " VALUES (" & Nz(Me.Pays, "") & ",'"
SQL = SQL & Me.NomDistributeur & "','"
SQL = SQL & Replace(Nz(Me.Adresse, " "), "'", "''") & "','"
SQL = SQL & Nz(Me.CP, " ") & "','" & Nz(Me.Ville, " ") & "','"
SQL = SQL & Nz(Me.Numero_tel, " ") & "','" & Nz(Me.Numero_fax, " ") & "','"
SQL = SQL & Replace(Nz(Me.Remarques, " "), "'", "''") & "','" & Nz(Me.idLisa, " ") & "')"
DoCmd.RunSQL (SQL)
DoCmd.Close
DoCmd.SetWarnings True
End Sub |
Partager