Create macro save report as PDF
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Once a report opens we touch our PDF icon on our tool bar(I believe this was downloaded). Then it saves to PDF as if it was printing( I guess this is the norm since we have PDF printer setup.
I would like to save(pdf format) and print theses reports automatically(button) on form.
The name I would like the pdf to be is(reportname-datestamp).
I'm having issues because of the PDF format
My question is.would be it possible to override the saving part? Can you export it into Excel first then save? Users just wanna view the file in Excel without having to save the report first.
Is it possible? Can it be done using a macro of some sort
My issue - I would like to rename the report to data in an underlying query prior to it converting to a pdf and sending it off. I don't want to change the existing report, I simply want to do something like "Save as.pdf"
I'm not sure where to start. I undertsand "where conditions" and I was thinking that I might put a macro in Events prior to Opening the report?
Does anyone have an idea of how to approach this task? I'm not familiar with VB or SQL but I'm happy to do research if pointed in a direction
DoCmd.OutputTo acOutputReport, "R_RptByRevdDate", acFormatPDF, , , , , acExportQualityPrint
But I don't know how to save in a particular folder that I created on my D:\MyFolder with its report number (that may be a record number of report) and if the same report (identify with RectNo field in it) is already saved then ask for overwrite
so in a Macro I have the following. It all works just fine, but it sends the PDF name as 'InvoiceEmail' which is the report name itself. I really want it to change the name of the PDF to [Invoice No].pdf
Name that File with a project number and the Report Name Then send it to a certain File Path?
All with the click of a button.
The dB will produce many reports based on different division and branch workload. At present to send a report as a PDF file I create a macro to Send Object from MS Access ribbon. I choose Report, select report name, choose PDF format and add description for the subject line of the mail window. The macro works fine and produces the PDF file of each record as I like. In doing so I'm up to over 50 macros that send out reports as PDF files.
Question: I assume their is a much easier way. What am I doing wrong ?
For example, when I open the service report for customer Johnson, I would like when I export the report (via email or save as pdf) that the report name be Johnson Service Report, rather than Service Report. This name would also change when I open the service report for cusotmer Wilcox, the report name would then be Wilcox Service Report. Is this possible?
This way when I save the pdf to the digital file I do not have to rename it, as well as if I am sending the report via email the specific customer will be noted in the report name without having to change it manually.