UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Export Mulitple Invoies As Pdf Files, Office 2010    
 
   
djb1000
post May 21 2011, 01:04 AM
Post #1

UtterAccess Enthusiast
Posts: 97



I am currently using lebans pdf code to export invidiual invoices as pdf files. Just wanted to know if I tweak the following code, is there a way that I can export mulitple invoices (or all of them) but save them as individual pdf files with different invoice numbers for each.
DoCmd.OpenReport "CurrentInvoice", acViewPreview, , "InvoiceNumber = " & Me.InvoiceNumber
DoCmd.OutputTo acOutputReport, "CurrentInvoice", acFormatPDF, "Database name goes here - INV" & Me.InvoiceNumber.Value & ".pdf"
DoCmd.Close acReport, "CurrentInvoice"
MsgBox "PDF Invoice created", vbInformation
At the moment it filters it and only exports the current invoice, renaming the file "Database name goes here - INV" & Me.InvoiceNumber.Value"
I've selected Access 2010 but probably would need something that could work in 97 also...
Any help would be appreciated.
Thanks in advance.
Daniel
Go to the top of the page
 
+
HiTechCoach
post May 22 2011, 11:13 PM
Post #2

UtterAccess VIP
Posts: 18,666
From: Oklahoma City, Oklahoma



I have created a cou-le of examples that should show you what you need.
ee:
Batch Printing and save a Snapshot
* Leban's tool could easily be used here to create the PDF of convert the Snaphot to a PDF.
and
Batch Printing and Save As PDF
* For Access 2007/2010 using the new built-in support for creating a PDF
Go to the top of the page
 
+
djb1000
post May 24 2011, 12:49 AM
Post #3

UtterAccess Enthusiast
Posts: 97



Perfect! Just what I was looking for <
Thanks for taking the time to offer some help
Daniel
Go to the top of the page
 
+
HiTechCoach
post May 24 2011, 01:14 AM
Post #4

UtterAccess VIP
Posts: 18,666
From: Oklahoma City, Oklahoma



Daniel,
ou're welcome.
Glad we could assist.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 30th August 2014 - 01:21 AM