Using one report and exporting to individual PDF files
The report contains expenditures which are grouped by Approver.
What I need to do is create multiple PDF files (could be some other format) that can be emailed to each approver.
I have seen this question on multiple forums, but no answers.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
but it ends up exporting the entire report for each of the individual BFR Names rather than just the individual section of the report.
The question is this - she wants to be able to save each tech's individual report in the following way: tech_A-07062012.pdf, tech_B-07062012.pdf, tech_C-07062012.pdf etc.
I know VBScript but do not know all the ins and outs of Access to know where to start with this.
The report needs to be exported with a certain filename. 2 parts of the filename need to be derived from a form.
The query behind the report contains 194 lines and raltes to call records. I want to output 194 pdf files with each pdf the report just for the related row in the query, not 194 copies of the entire report.
Private Sub Command0_Click() Dim rs As DAO.Recordset, pdfName As String, MyFilter As String, MyFilename As String, MyPath As String Set rs = CurrentDb.OpenRecordset("qryCalls") rs.MoveFirst Do Until rs.EOF pdfName = rs("REF") & ".pdf" 'MyFilter = "Unique_Programs_Distinct.Program = '" & rs("program") & "'" MyPath = rs("MyPath") DoCmd.OutputTo acOutputReport, "RepCalls", acFormatPDF, MyPath & pdfName rs.MoveNext Loop rs.Close Exit_Create_PDF: Exit Sub End Sub
How can I make it so that when I click export to pdf/xps, the default file name is named after a text box called PROGRAM?
For example, let's say that the group is "Plan ID" and has the values: 101, 102, 204, 405 and in the report there is a variable called: service month (example: 201101). I want to be able to create a report for each Plan ID, save 101 in folder name 101 and so on and in the name it has the month and plan id like: "this_is_thereport_101_201101.pdf
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
In present scenario it is taking the report name as the DEFAULT name. for example my report name is SALES and when I print the report its coming default as SALES.pdf. But I need Alan Bakes.pdf where Alan Bakes is the organisation name which is there inside the report as a textbox.
For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and then link the pdf files.
I started but am having problems with Access not opening the pdf file, it will open word files but not pdf,
I am experiencing a similar issue, but mine has nothing to do with any printer issue. I have a report that can be pushed out to PDF or RTF. The PDF push runs just fine (i.e., the PDF file does not truncate any fields), but the RTF file truncates some memo fields (especially ones that might run on to another page via the can grow property).
Why does this happen? Is there something I can do to prevent my memo fields from being truncated with I push the report out in an RTF word doc