Solved when i exported to pdf it adds additional blank pages

C

camiramzi

Member
Local time
Tomorrow, 00:10
Joined
Oct 30, 2022
Messages
35
i have a subform that has scanned images (jpg) and also converted pdfs like shown here
Form.JPG

when i click to convert again the second/third time i think it includes the pdfs in subform list and adds them as blank pages because when i have like 10 pdfs and one jpg in the list it exports a pdf containing jpg(image) and 10 additional blank pages(previously converted pdfs).
i'm a beginner at access vba please help me with this issue.

this is code :
Code: 
Private Sub CommandConvertToPdf_Click()

Dim Numberofdocuments As Integer

Numberofdocuments = DCount("IDD", "QPicOfConseller01")
If Numberofdocuments = 0 Then
MsgBox "áÇÊæÌÏ ÕæÑÉ áÊÍæíáåÇ", , "ÕÝÍÉ ãÍãæÏ ÚÈÏ ÇáÛÝÇÑ"
End
Else

    SetPathOfFiles
    NumDoc = Me.IDD
  
    If Len(Dir(PathOfFile & Forms![Form1]![IDD], vbDirectory)) = 0 Then
                MkDir PathOfFile & Forms![Form1]![IDD]
            End If
    DoCmd.OpenReport "ReportToPdf", acViewPreview, , , acHidden
    DoCmd.OutputTo acReport, "ReportToPdf", "PDFFormat(*.pdf)", PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now, "d-m-yy_h-n-s") & ".pdf"
    DoCmd.Close acReport, "ReportToPdf", acSaveNo
End If


  'Deletes jpgs after convert
Dim sFile As String
If Me!OptionDeletePicAfterConvertPDF = -1 Then
    With Me!ImagesSubform.Form.RecordsetClone
        If Not (.BOF And .EOF) Then
            .MoveFirst
        End If
        Do Until .EOF
            If InStrRev(![AttchFiles] & "", ".jpg") <> 0 Then
                sFile = ![AttchFiles]
                .Delete
                On Error Resume Next
                If Len(Dir$(PathOfFile & NumDoc & "\" & sFile)) <> 0 Then
                    Kill PathOfFile & NumDoc & "\" & sFile
                End If
                 On Error GoTo 0
            End If
             .MoveNext
          Loop
    End With

Me.PicView.Requery
End If

Dim Ttb2 As Recordset
        Set Ttb2 = CurrentDb.OpenRecordset("Image")
        Ttb2.AddNew
        Ttb2![IDD] = Forms![Form1]![IDD]
        Ttb2![Path] = PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now, "d-m-yy_h-n-s") & ".pdf"
        Ttb2.Update
        Me.ImagesSubform.Requery
End Sub
 
A report is primarily a printed output on paper. A paper format used has dimensions, the printer used also requires its own minimum dimensions for margins.

So if your content needs more space there, leftovers are spent on additional pages.
 
ebs17 said:
A report is primarily a printed output on paper. A paper format used has dimensions, the printer used also requires its own minimum dimensions for margins.

So if your content needs more space there, leftovers are spent on additional pages.
Click to expand...
there is no problem with report layout
it adds the pdf file that is on the list as an additional blank page
i need to find a way to baypass or exclude the pdf when the convertion process is working
i guess the problem is here in this code:

Code: 
DoCmd.OpenReport "ReportToPdf", acViewPreview, , , acHidden
DoCmd.OutputTo acReport, "ReportToPdf", "PDFFormat(*.pdf)", PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now, "d-m-yy_h-n-s") & ".pdf"
DoCmd.Close acReport, "ReportToPdf", acSaveNo
 
you post a sample "with some records".
 
OpenReport ... does the report have blank pages? Look, don't believe.
PDF is created by a PDF printer, whether you see it or not doesn't matter. This printer may require custom margins.
So reduce the content in the report significantly and test again.

i guess the problem is here in this code
Click to expand...
A file name certainly has no bearing on blank pages.
 
when i click to convert again the second/third time i think it includes the pdfs in subform list
Click to expand...
What does re-convert mean? Did you scan the PDF? By which? Are PDFs embedded in the report and you want the whole thing to be output as a PDF again?
What do you want your pictures to explain?
i'm a beginner at access vba please help me with this issue.
Click to expand...
I think this is less of a VBA or Access problem. Think about processes, what you do with what.
 
unfortunately it didn't fix it
thank you

arnelgp & ebs17​

for your time and effort
this is the file in case you want to modify it, if you fix it please send it to me.
 

Attachments

ebs17 said:
What does re-convert mean? Did you scan the PDF? By which? Are PDFs embedded in the report and you want the whole thing to be output as a PDF again?
What do you want your pictures to explain?

I think this is less of a VBA or Access problem. Think about processes, what you do with what.
Click to expand...
i scan paper documents (archive) and export to pdf , my problem is the pdf contains additional blank pages.
 
Can you please try this version?
I have set all margins to 0 and set the printer to Microsoft Save As PDF (in the report).

Cheers,
 

Attachments

Code: 
DoCmd.OutputTo acReport, "ReportToPdf", "PDFFormat(*.pdf)", ...
What I can see:
=> The resulting JPG files from the scan are not used in any way by this process, they have a life of their own.
=> The report contains only one ImageControl. A PDF is loaded into that (or several?) via query, and a PDF is generated from this report. The ImageControl has smaller dimensions than the A4 format.

I can't see any sense in the measure. If you want to merge PDF files, there are suitable solutions like PDFtk.
 
Last edited:
bastanu said:
Can you please try this version?
I have set all margins to 0 and set the printer to Microsoft Save As PDF (in the report).

Cheers,
Click to expand...
i tried it and it still adds an additional blank page to the second time
maybe it's because it loops through the records and incules the pdf and generates it as a blank page
 
it loops through the records
Click to expand...
Somewhere, but that has nothing, I repeat, nothing to do with the report and the PDF creation. The report has a query as the data source, and in the demo shown, it returns exactly one PDF document and nothing else. Check it out and trade belief for knowledge of reality.
 
ebs17 said:
Somewhere, but that has nothing, I repeat, nothing to do with the report and the PDF creation. The report has a query as the data source, and in the demo shown, it returns exactly one PDF document and nothing else. Check it out and trade belief for knowledge of reality.
Click to expand...
is there a way that i can use criteria that excludes the Pdfs and only selects jpgs in this code


Code: 
DoCmd.OpenReport "ReportToPdf", acViewPreview, , criteria , acHidden
DoCmd.OutputTo acReport, "ReportToPdf", "PDFFormat(*.pdf)", PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now, "d-m-yy_h-n-s") & ".pdf"
DoCmd.Close acReport, "ReportToPdf", acSaveNo
 
Not in there but in the report's record source, replace what you have with this and give it a try:

SELECT Conseller01.IDD, image.Path, IIf(IsNull([Path]),"N\A",Right([Path],4)) AS FileType
FROM Conseller01 INNER JOIN [image] ON Conseller01.IDD = image.IDD
WHERE (((Conseller01.IDD)=[Formulaires]![Form1]![IDD]) AND ((IIf(IsNull([Path]),"N\A",Right([Path],3))="jpg"));

Cheers,
 
is there a way
Click to expand...
Code: 
SELECT Conseller01.IDD, image.Path
FROM Conseller01 INNER JOIN [image] ON Conseller01.IDD = image.IDD
WHERE (((Conseller01.IDD)=[Formulaires]![Form1]![IDD]));
This query provides the data for the report - as you know and can see in your application. The images table provides full paths for files.
=> So you could filter the query for the JPG file extension.
=> You could also simply not enter a PDF in the table. A PDF is not an image.

If you edit an application (others?), you should first deal with it a little bit before you get hands on.
 
bastanu said:
Not in there but in the report's record source, replace what you have with this and give it a try:

SELECT Conseller01.IDD, image.Path, IIf(IsNull([Path]),"N\A",Right([Path],4)) AS FileType
FROM Conseller01 INNER JOIN [image] ON Conseller01.IDD = image.IDD
WHERE (((Conseller01.IDD)=[Formulaires]![Form1]![IDD]) AND ((IIf(IsNull([Path]),"N\A",Right([Path],3))="jpg"));

Cheers,
Click to expand...
It works a million thanks to you

bastanu and ebs17​

 
you also change this portion and you delete the File in the [Path] field:
Code: 
If Me!OptionDeletePicAfterConvertPDF = -1 Then
    With Me!ImagesSubform.Form.RecordsetClone
        If Not (.BOF And .EOF) Then
            .MoveFirst
        End If
        Do Until .EOF
            If InStrRev(![Path] & "", ".jpg") <> 0 Then
                sFile = ![Path]
                .Delete
                On Error Resume Next
                If Len(Dir$(sFile)) <> 0 Then
                    Kill sFile
                End If
                 On Error GoTo 0
            End If
             .MoveNext
          Loop
    End With

Me.PicView.Requery
End If

Dim Ttb2 As Recordset
        Set Ttb2 = Me!ImagesSubform.Form.RecordsetClone 'CurrentDb.OpenRecordset("Image")
        Ttb2.AddNew
        Ttb2![IDD] = NumDoc
        Ttb2![Path] = PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now, "d-m-yy_h-n-s") & ".pdf"
        Ttb2.Update
        Me.ImagesSubform.Requery
 
You must log in or register to reply here.

Similar threads

C
Solved problem with exporting to pdf
Replies
12
Views
1,349
camiramzi
C
M
VBA output report to PDF and email
Replies
18
Views
1,298
Pat Hartman
P
E
Macro in Excel to replicate Acrobat command: "Merge supported files in acrobat" (.docx, .pdf, .jpg, .jpeg, .png, .xlsx, etc.)
Replies
2
Views
1,261
561414
5
S
VBA to Print a specific page to printer or pdf
Replies
3
Views
1,537
GinnyR
G
A
ADF Scanner in Access
Replies
11
Views
1,871
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom