Hi,
I have installed a 60-trial of Office 2007 to see if I can resolve a problem I currently have with Acc2000 :
I currently use the "outputto" command in the Report_Page event of the report to output an RTF file, which is then converted to a PDF and then e-mailed to customers.
i.e. DoCmd.OutputTo acOutputReport, "Quote2", acFormatRTF, FPath
I have experienced formatting problems with this method (that are OK if previewed in Access) in that large gaps appears in the report data when the report is longer than 3 pages.
After installing Office 2007, I downloaded and installed the "SaveAsPDFAndXPS.exe" add-in.
I have tried to use the outputto method as follows :
DoCmd.OutputTo acOutputReport, "Quote2", acFormatPDF, FPath
Where FPath is the full path to a network share.
(Nothing else has changed other than the output format)
I was hoping to cut out the middle part of the process and go straight to a PDF output, which can then be e-mailed, however, even though Access tells me it is outputting the report, there is nothing in the network folder when I go to find it!!
I have tried outputting the report to a local directory, but get the same (non)result.
Can anyone tell me what I have missed / needs to be added to get this to work???
I have installed a 60-trial of Office 2007 to see if I can resolve a problem I currently have with Acc2000 :
I currently use the "outputto" command in the Report_Page event of the report to output an RTF file, which is then converted to a PDF and then e-mailed to customers.
i.e. DoCmd.OutputTo acOutputReport, "Quote2", acFormatRTF, FPath
I have experienced formatting problems with this method (that are OK if previewed in Access) in that large gaps appears in the report data when the report is longer than 3 pages.
After installing Office 2007, I downloaded and installed the "SaveAsPDFAndXPS.exe" add-in.
I have tried to use the outputto method as follows :
DoCmd.OutputTo acOutputReport, "Quote2", acFormatPDF, FPath
Where FPath is the full path to a network share.
(Nothing else has changed other than the output format)
I was hoping to cut out the middle part of the process and go straight to a PDF output, which can then be e-mailed, however, even though Access tells me it is outputting the report, there is nothing in the network folder when I go to find it!!
I have tried outputting the report to a local directory, but get the same (non)result.
Can anyone tell me what I have missed / needs to be added to get this to work???
