If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to close a *.PDF report in VBA
I am working on an application which is to send ACCESS reports to suppliers
(Monthly Supplier Performance Report cards). I am using the VBA code from the references which I was directed to, from this forum. I use the Stephan Labans code to convert the ACCESS report to a PDF format. I send a MS Outlook message with 2 attachments (a snapshot {snp} and PDF version of the report). Currently the code works if I close the open PDF version of the report before the code increments to the next supplier (next recordset record). If I do not manually close the displayed PDF file I get an error message (permission denied) when I try to execute the Kill (“C:\SupplierReportCard.PDF”) and loop to the next supplier. I am thinking I need to close the open PDF file after sending the Email and before looping to the next supplier in the recordset. I currently do not know how to do this. I use a DoCmd.Close acReport to close the ACCESS version of the report but this does nothing for the PDF version. So my question is, is my assumption correct that I need to close the report before looping and if so how do I do this? -- frank-a |
Thread Tools | |
Display Modes | |
|
|