1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
| Private Sub PdfUnParUnWhere_Click()
Call TraceChaqueW
End Sub
Private Sub TraceChaqueW()
Dim db As dao.Database
Dim rec As dao.Recordset
Dim Champs As Fields
Dim Buffer As Variant
Dim Buffer2 As Variant
Dim Nompdf As String
Dim SqlStr As String
Set db = CurrentDb
Set rec = db.OpenRecordset("Source_principale", dao.dbOpenForwardOnly)
DoCmd.SetWarnings False
Do While Not rec.EOF
Set Champs = rec.Fields
Buffer = Trim(Champs("ID")) '
'tracePdfUnParUnW (Buffer)
Buffer2 = Trim(Champs("Type_Ouvrage")) '
Nompdf = Buffer2 & "_" & Buffer
tracePdfUnParUnW Buffer
rec.MoveNext
Loop
DoCmd.SetWarnings True
Set rec = Nothing
Set db = Nothing
End Sub
Public Sub tracePdfUnParUnW(ByVal stJustOne As String)
Dim sWhere As String
Dim MyMe As Report_A4_portrait
'ci desous au cas ou le critère est une chaine
'sWhere = "[ID]=" & Chr(34) & stJustOne & Chr(34)
sWhere = "[id]=" & stJustOne
DoCmd.OpenReport "A4_Portrait", acViewPreview, "", sWhere, acWindowNormal
DoCmd.SelectObject acReport, "A4_Portrait" 'apparament cette ligne devrait résoudre mon problème, mais non ...
DoCmd.OutputTo acOutputReport, "A4_Portrait", acFormatPDF, "E:\Fiches_regard\Labo\" & "Nompdf" & stJustOne & ".pdf", False
DoCmd.Close acReport, "A4_Portrait", acSaveNo
End Sub |
Partager