Tente de remplacer tes quotes par des doubles quotes
1 2 3 4 5 6 7 8 9 10 11
|
Private Sub Imprimer_Click()
On Error Resume Next
CR1.DataFiles(0) = ("c:\Travaux Publics\MARAVER.MDB")
CR1.Formulas(0) = "numero='" & replace(NATTA.Text,"'","''") & "'"
CR1.Formulas(1) = "numeroMarche='" & replace(NMARCHE.Text,"'","''") & "'"
CR1.Formulas(2) = "datemarche='" & replace(DMARCHE.Text,"'","''") & "'"
cr1.Formulas(3) = "objet='" & replace(objet.Text,"'","''") & "'"
CR1.SelectionFormula = "{ATTACHEMENT.N_ATTA}='" & replace(NATTA.Text,"'","''") & "'"
CR1.PrintReport
End Sub |
et si ça ne marche pas , remplaçe les par des espace
replace(NATTA.Text,"'"," " )
Partager