Planet PDF Forum Archive

Planet PDF ForumWowsers! This is page is old, head to the LIVE Planet PDF Forum. It features more than 10 conferences, covering everything from beginner to in-depth developer and pre-press discussions. If you wish to continue... one & two archive covers 1999-2011 (160,000 pages).

New Forum | Previous | Next | (P-PDF) Developers

Topic: Output Access Report To PDF
Conf: (P-PDF) Developers, Msg: 125272
From: DonPayseur
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 & " you can quickly download the Snapshot Viewer from our Website" _
& "For additional load opportunities, please visit our website at"

stDocName = "xConfirmation"
DoCmd.SendObject acReport, stDocName, acFormatSNP, MyEmail, , , DocNum, MesBody, , ""

Exit Sub

MsgBox Err.Description
Resume Exit_btnConfirmationMailto_Click

End Sub

PDF In-Depth Free Product Trials Ubiquitous PDF

Debenu Aerialist

The ultimate plug-in for Adobe Acrobat. Advanced splitting, merging, stamping, bookmarking, and link...

Download free demo

Debenu PDF Tools Pro

It's simple to use and will let you preview and edit PDF files, it's a Windows application that makes...

Download free demo

Five visions of a PDF Day

In the world of PDFs or as we like to say Planet (of) PDF, a year isn't a real PDF year without an intense few days of industry knowledge sharing.

May 15, 2018
Platinum Sponsor

Search Planet PDF
more searching options...
Planet PDF Newsletter
Most Popular Articles
Featured Product

Debenu PDF Aerialist

The ultimate plug-in for Adobe Acrobat. Advanced splitting, merging, stamping, bookmarking, and link control. Take Acrobat to the next level.


Adding a PDF Stamp Comment

OK, so you want to stamp your document. Maybe you need to give reviewers some advice about the document's status or sensitivity. This tip from author Ted Padova demonstrates how to add stamps with the Stamp Tool along with related comments.