Convert Forms to PDF

[onlylonely]

Hi All,

Is there any method to convert forms to PDF?
I've 5 forms. These 5 forms is link by a unique number.
At the last page F5, i would like to click and it will convert all the forms to PDF. Is that possible?


Or i need to convert these 5 forms into the report and then only to PDF?

[ranman256]

if you mean a picture of the form in pdf, then you can print the screen, then print to pdf.
but if you mean convert an access form to a pdf form, then no.

if you want to print the data, then make a report, then print that to pdf,
or use : docmd.OutputTo

docmd.OutputTo acOutputReport ,"rMyRpt", acFormatPDF,vFileName

[onlylonely]

if you mean a picture of the form in pdf, then you can print the screen, then print to pdf.
but if you mean convert an access form to a pdf form, then no.

if you want to print the data, then make a report, then print that to pdf,
or use : docmd.OutputTo

docmd.OutputTo acOutputReport ,"rMyRpt", acFormatPDF,vFileName

Hi Ranman,

Thank You for the suggestion.
Your suggestion is to put all the data into the report and convert it to PDF.
I have 5 forms and each individual has it owns table but link with a unique number.
So i have to create 5 reports. May i know how can i put all the 5 report into 1 report? Meaning that i have 1 report that contains of 5 pages.
Or can i convert those 5 reports into 1 PDF?

[ranman256]

if all 5 are different reports, then you can create 1 report holding 5 subReports.
then they all print in 1` pdf with the OUTPUTto command.

[onlylonely]

if all 5 are different reports, then you can create 1 report holding 5 subReports.
then they all print in 1` pdf with the OUTPUTto command.

Hi Ranman,

I'm trying hard to figure out how to create 1 report holding 5 subreports.
I've google, youtube but i can't find any. Appreciate if you could provide me more hints on this?

[onlylonely]

Hi Ranman,

I'm trying hard to figure out how to create 1 report holding 5 subreports.
I've google, youtube but i can't find any. Appreciate if you could provide me more hints on this?

HI Ranman,

Finally i got it.... But i want to export it to PDF.
When i use Docmd.outputto ..... it will have 52 pages. Cause command outputto cannot put which unique number you want to convert to pdf.
It will export all the data from the table.

DoCmd.OutputTo acOutputReport, "F1", acFormatPDF, "C:\Tony\Project\MS Access\Good\" & [Forms]![F4EffectivenessForm]![txtscar] & " Record.pdf", False

Unlike, below code

DoCmd.OpenReport "F1", acViewReport, , "[SCAR] = '" & Forms!F4EffectivenessForm!txtscar & "'", acWindowNormal

It can viewreport and save to pdf. But how can i directly convert it to pdf?
Any idea?

[CJ_London]

in your mind - what is the difference between 'save to pdf' and 'convert it to pdf'