Hello all,
Thank you for taking time out to read this
Before I start investigating was wondering if anyone can assist in telling me if it is possible and advise on what route i should take to accomplish my aim.
Basically i'm trying to get a Access Report to export to PDF but would like the report to be split based on a distinct table called cost centres. So basically the output is a seperate report for each cost centre saved with the filename as the costcentre.pdf
But don't think the code does what i want it to do :/ is it possible and any tips on what i should look and read on to assist me in completing it...
currently the process done is literally have a report setup and one by one type in the cost centre, preview and print to PDF (process can take upwards of an hour!!)
Thanks in advance for taking time to read this much appreciated
mEsh
Thank you for taking time out to read this
Before I start investigating was wondering if anyone can assist in telling me if it is possible and advise on what route i should take to accomplish my aim.
Basically i'm trying to get a Access Report to export to PDF but would like the report to be split based on a distinct table called cost centres. So basically the output is a seperate report for each cost centre saved with the filename as the costcentre.pdf
Code:
Private Sub Create_PDF_Click()
Dim myPath As String
Dim strReportName As String
DoCmd.OpenReport "NominalRollCC", acViewPreview
myPath = "C:\Documents and Settings\"
strReportName = NominalRollCC.[CostCentre] + ".pdf"
DoCmd.OutputTo acOutputReport, "", acFormatPDF, myPath + strReportName, True
DoCmd.Close acReport, "NominalRollCC"
End Sub
But don't think the code does what i want it to do :/ is it possible and any tips on what i should look and read on to assist me in completing it...
currently the process done is literally have a report setup and one by one type in the cost centre, preview and print to PDF (process can take upwards of an hour!!)
Thanks in advance for taking time to read this much appreciated
mEsh