Save report as pdf.

[sams]

I have built a customer-order db that Works just fine. I want to add some features to it. I have a customer order form with a button that turns the order into a report (invoice)via a query. I was wondering if there is a possibility that I can add another button to the form that saves the report (invoice) as PDF to a location on the computer(or network) with a specific name (date+invoicenr.) can anyone help me out with this? Any help and/or advice is appreciated

Regards,



Sam

[pbaldy]

Start by checking out OutputTo in VBA help. You can include data from the form in the name with things like:

"C:\Whatever\" & Me.CustomerName & ".PDF"

[Access_Blaster]

Here is a great source:

http://www.lebans.com/reporttopdf.htm

[pbaldy]

Lebans is a great tool that I use myself, but PDF capability is built into 2007, so it's not really necessary.

[Access_Blaster]

Yes it is, I use it also.
Thank you for the correction.

Richard

[sams]

thanks a lot for the info, i will look in to it.
and when i got the right code ill post it here.

Sam

[sams]

befor you can export to pdf in access 2007 you need to download an ad-in called: SaveAsPDFandXPS.exe from the office online site!

[pbaldy]

The PDF capability was included in one of the service packs or patches, so if your version is up-to-date, no further download should be required.