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,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
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?
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?
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.
Unlike, below codeCode:DoCmd.OutputTo acOutputReport, "F1", acFormatPDF, "C:\Tony\Project\MS Access\Good\" & [Forms]![F4EffectivenessForm]![txtscar] & " Record.pdf", False
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?
in your mind - what is the difference between 'save to pdf' and 'convert it to pdf'