Hi all, kind of frustrated here trying to figure out how to solve this issue..:banghead:
I am exporting more than 100 reports (with a lot of parameters) to PDF using VBA, everything works fine excepting for one detail, in many reports some titles are tied to parameters values (start and end period for example), using a textbox with control source property = [parametername]. This was done in that way for the person who made all the reports.
If I run the report manually and export it to PDF, then titles are shown correctly, but if I run the VBA process titles in PDF files are empty.
Is there any workaround you could recommend to solve this?
I am using (inside a loop that is working fine, not relevant to this issue):
DoCmd.OpenReport CurrentRep, acViewPreview, , , acHidden
DoCmd.OutputTo objecttype:=acOutputReport, objectName:=CurrentRep, outputformat:=acFormatPDF, outputFile:=filepath
DoCmd.Close acReport, CurrentRep, acSaveNo
I would really appreciate any help.
Thanks!
I am exporting more than 100 reports (with a lot of parameters) to PDF using VBA, everything works fine excepting for one detail, in many reports some titles are tied to parameters values (start and end period for example), using a textbox with control source property = [parametername]. This was done in that way for the person who made all the reports.
If I run the report manually and export it to PDF, then titles are shown correctly, but if I run the VBA process titles in PDF files are empty.
Is there any workaround you could recommend to solve this?
I am using (inside a loop that is working fine, not relevant to this issue):
DoCmd.OpenReport CurrentRep, acViewPreview, , , acHidden
DoCmd.OutputTo objecttype:=acOutputReport, objectName:=CurrentRep, outputformat:=acFormatPDF, outputFile:=filepath
DoCmd.Close acReport, CurrentRep, acSaveNo
I would really appreciate any help.
Thanks!