Access VBA export data using ExportAsFixedFormat
Hi
In Access VBA does anyone have an example of using a SQL statement to export data as a pdf using ExportAsFixedFormat ?
Thanks
In Access VBA does anyone have an example of using a SQL statement to export data as a pdf using ExportAsFixedFormat ?
Thanks
Last Comment
ASKER
Hi. If that is the way to do it then yes. If there was a way to export data directly to pdf then that would have been good but if not then via word and save as pdf for example
You could always use a PDF printer and just print the report to it.
ASKER
Thanks John. Is there no way to do this in Office?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You can export a REPORT to PDF.
DoCmd.OutputTo acOutputReport, "YourReportName", acFormatPDF, "PathAndNameOfFile.pdf"
So you could create a report to display your data, then call it using the above syntax.
DoCmd.OutputTo acOutputReport, "YourReportName", acFormatPDF, "PathAndNameOfFile.pdf"
So you could create a report to display your data, then call it using the above syntax.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Do you mean export the query from Access and then save as a pdf?