UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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



Posts: 100
Joined: 24-July 10



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,807
Joined: 29-September 03
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



Posts: 100
Joined: 24-July 10



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,807
Joined: 29-September 03
From: Oklahoma City, Oklahoma


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


Custom Search
RSSSearch   Top   Lo-Fi    2nd September 2015 - 09:47 AM