Saving a report to pdf

[tommy93]

Hello,

What i am looking for is an easier way to save my reports on a drive. At current i am using the code -

DoCmd.OutputTo acOutputReport, "Custinvoice", ".pdf", "C:\Users\jason\Shared\Transcon Logistics\Invoices\TL" & strFileName & " invoice.pdf", True

This works fine. The only issue is, i want the database to save the pdf straight to the directory for the database. Thus removing the whole "C\Users|\...." so i can move the folders at will an its still work without recoding it.

Im pretty sure there is a way to do this, however it was a while a go i did it and i cannot find a solution online.

[aytee111]

The folder where your front-end database resides is:

CurrentProject.Path

[tommy93]

The folder where your front-end database resides is:

CurrentProject.Path

How would i put that into that code?

I need it to go to a folder in that location. I have 3 sets of pdfs, booking confirmations, invoices and jobsheets, and need them saved in different folders as follows -

*CurrentProject.Path*/Booking Confirmations
*CurrentProject.Path*/Invoices
*CurrentProject.Path*/Jobsheets

[aytee111]

Dim PathName as string
PathName=CurrentProject.Path
DoCmd.OutputTo acOutputReport, "Custinvoice", ".pdf", PathName & "\Invoices\TL" & strFileName & " invoice.pdf", True

etc

[tommy93]

Dim PathName as string
PathName=CurrentProject.Path
DoCmd.OutputTo acOutputReport, "Custinvoice", ".pdf", PathName & "\Invoices\TL" & strFileName & " invoice.pdf", True

etc

Thankyou so much, seemed to work first time.

Knew it'd be something simple haha.

[Lowell]

I have been needing this info, but is this also possible in a macro?

What do you enter for OutputTo\Output File?

Dolittle.accdb.Path?