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,680
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,680
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: 18th December 2014 - 01:19 PM