I have a report that has 2 image controls. the data for the images are from a text box control that has the file path to the image on my computer.
Once the report is generated i output the report to a pdf and save it to a location on my computer so it can later be accessed and emailed if needed.
I use this vba on a button control to accomplish this:
MyFilename = FileName & ".pdf"
MyPath = "X:\Customer Files\RFQ\"
DoCmd.OutputTo acOutputReport, "rptRFQEquipDiscNoSum1", acFormatPDF, MyPath & MyFilename, True, , , acExportQualityPrint
End Sub
The problem is only one of the image controls shows up after the output to pdf. shows up fine on the report and if i print it or manually output it with the pdf button on the ribbon in the print preview view but it wont show the second image or anything else i put below that first image control when i use the above vba on a button control.
Both image controls are in a custom header grouped on the image. i have changed every option on the grouping menu and nothing helps.
Any ideas as to why this is happening?
thanks
Once the report is generated i output the report to a pdf and save it to a location on my computer so it can later be accessed and emailed if needed.
I use this vba on a button control to accomplish this:
MyFilename = FileName & ".pdf"
MyPath = "X:\Customer Files\RFQ\"
DoCmd.OutputTo acOutputReport, "rptRFQEquipDiscNoSum1", acFormatPDF, MyPath & MyFilename, True, , , acExportQualityPrint
End Sub
The problem is only one of the image controls shows up after the output to pdf. shows up fine on the report and if i print it or manually output it with the pdf button on the ribbon in the print preview view but it wont show the second image or anything else i put below that first image control when i use the above vba on a button control.
Both image controls are in a custom header grouped on the image. i have changed every option on the grouping menu and nothing helps.
Any ideas as to why this is happening?
thanks