New Forum | Previous | Next | (P-PDF) Developers
Topic: Output Access Report To PDF
Conf: (P-PDF) Developers, Msg: 125272
Date: 1/12/2005 01:35 AM
I am new to the Planet PDF Forum. I am looking forward to the benefits and hope that I can make contributions as well. I am a developer and my application is developed in Microsoft Access v.02. I have created a function call that basically takes the Access Report:
Basically what my code does is it calls the report directly to a snapshot (upon what I want to change is to make it a PDF...) and then attaches to an email along with a canned message.
What I want to do is change the output from a SNP to a PDF. How can I accomplish this with the least amount of head banging!
On Error GoTo Err_btnConfirmationMailto_Click
Dim stDocName As String
Dim DocNum As String
Dim message As String
Dim MyEmail As String
Dim MesBody As String
MyEmail = Forms![Orders]![book carrier]![DispatcherEmail]
DocNum = "Load" & [Forms]![Orders]![LoadNum] & " " & [Forms]![Orders]![Dispatch]
message = "Load From Paystar Logistics. Load Number > "
MesBody = "Here is your load agreement and pickup/delivery information for the load you accepted. Paystar" _
& " requires that your driver check in with us at the following times. 1. For initial dispatch. 2. When Loaded. 3. When empty." _
& " Please print this document, sign and return directly to me. Our fax is 866-428-7555. If you have any" _
& " questions about this load or if you have any problems please contact me immediately." _
& " This document attached was created in the Snapshot Viewer Format which is similar to a PDF file. " _
& "First click on the attachment and if it is viewable, then you already have Snaphot Viewer installed on your" _
& " computer. Snapshot Viewer is a free tool from Microsoft. If you need to install the Snapshot Viewer, then click" _
& "on this link:" & vbCrLf & "http://www.paystarlogistics.com/downloads/downloads/Snpvw90.exe. you can quickly download the Snapshot Viewer from our Website" _
& "For additional load opportunities, please visit our website at http://www.paystarlogistics.com/LoadsOffered.htm"
stDocName = "xConfirmation"
DoCmd.SendObject acReport, stDocName, acFormatSNP, MyEmail, , , DocNum, MesBody, , ""