Private Sub Imprimer_Click() 'On Error Resume Next Cr1.DataFiles(0) = ("C:\PARFUMER\ROSH.mdb") Cr1.Formulas(0) = "TTIME='" & Text3.Text & "'" Cr1.SelectionFormula = "{VENTE.time}='" & Text3.Text & "'" Cr1.PrintReport End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Imprimer_Click() 'Placer une gestion d' erreur On Error GoTo Err_Print Cr1.DataFiles(0) = ("C:\PARFUMER\ROSH.mdb") Cr1.Formulas(0) = "TTIME='" & Text3.Text & "'" Cr1.SelectionFormula = "{VENTE.time}='" & Text3.Text & "'" Cr1.PrintReport Exit Sub Err_Print: MsgBox Err.Description End Sub[] Ce qui va sans dire. va mieux en le disant.
Private Sub Imprimer_Click() 'Placer une gestion d' erreur On Error GoTo Err_Print Cr1.DataFiles(0) = ("C:\PARFUMER\ROSH.mdb") Cr1.SelectionFormula = "{VENTE.time}='" & Text3.Text & "'" Cr1.Action=0 Exit Sub Err_Print: MsgBox Err.Description End Sub
Cr1.SelectionFormula = "{VENTE.time}=#" & Text3.Text & "#"