Hi,
I just create a new report and use the following code to print in pdf. The problem is the pdf file show me 11 pages when I just need 1. For the record the 11 pages are the same page information repeated 11 times. I have 250 records in the database
MyFileName = Me.AssemblyPartCode & "-GESNAcontrolsheet" & ".pdf"
DoCmd.OpenReport "GESNAcontrolsheet", acPreview, , strWhere
DoCmd.OutputTo acOutputReport, "GESNAcontrolsheet", acFormatPDF, MyPath & MyFileName, False
DoCmd.Close acReport, "GESNAcontrolsheet"
any suggestions? the program print other files at the same time without this issue.
I just create a new report and use the following code to print in pdf. The problem is the pdf file show me 11 pages when I just need 1. For the record the 11 pages are the same page information repeated 11 times. I have 250 records in the database
MyFileName = Me.AssemblyPartCode & "-GESNAcontrolsheet" & ".pdf"
DoCmd.OpenReport "GESNAcontrolsheet", acPreview, , strWhere
DoCmd.OutputTo acOutputReport, "GESNAcontrolsheet", acFormatPDF, MyPath & MyFileName, False
DoCmd.Close acReport, "GESNAcontrolsheet"
any suggestions? the program print other files at the same time without this issue.