Code to export report to PDF automatically?

What DoCmd code can I use to export a report directly to PDF, optimized for 
printing, and have it prompt me for a new PDF name each time? Or if that is 
complicated, always print to the same PDF name and location? Does the 
end-user system need Acrobat installed for this to work? Do they need Access 
2007? Thanks. 


0
Joseph
12/1/2009 7:36:46 PM
access.reports 4434 articles. 0 followers. Follow

2 Replies
1532 Views

Similar Articles

[PageSpeed] 24

Joseph,

Have a look at...  http://www.lebans.com/reporttopdf.htm  I have used this 
to print reports to PDF.  You can set this up to get the name of the report 
from a field on your form.

-- 
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors 
II

http://www.regina-whipp.com/index_files/TipList.htm

"Joseph Greenberg" <jjgfromnj@gmail.com> wrote in message 
news:OpoYk2rcKHA.1028@TK2MSFTNGP06.phx.gbl...
> What DoCmd code can I use to export a report directly to PDF, optimized 
> for printing, and have it prompt me for a new PDF name each time? Or if 
> that is complicated, always print to the same PDF name and location? Does 
> the end-user system need Acrobat installed for this to work? Do they need 
> Access 2007? Thanks.
> 


1
Gina
12/1/2009 8:54:15 PM
You may use docmd.output to  

You have to give the output file a name but you may do it in a loop and 
change the name  or have it prompt you for the name

Kerry

"Joseph Greenberg" wrote:

> What DoCmd code can I use to export a report directly to PDF, optimized for 
> printing, and have it prompt me for a new PDF name each time? Or if that is 
> complicated, always print to the same PDF name and location? Does the 
> end-user system need Acrobat installed for this to work? Do they need Access 
> 2007? Thanks. 
> 
> 
> .
> 
0
Utf
12/1/2009 9:01:02 PM
Reply:

Similar Artilces:

Integrate Paycodes, benefit codes and deduction codes
Has anyone used integration manager to update new pay rates, deduction amounts and benefit amounts for employees? At the beginning of each year, our company gives pay increases and we need to update the pay codes, deduction codes and benefit codes for 40 employees, which we get the information from a spreadsheet. I thought that maybe I could use integration manager to update the pay, benefit and deduction codes instead of going into each employee's card, which is time consuming. Thanks, Laura Integration Manager will allow you to do this. Use the Payroll Master Destination. one ...

custom invoices using sql server reporting services
We have 80 companies and each one wants its own unique invoice. What is the best way to go about this? I already have SSRS setup for other things - can I leverage that for this task. How would I go about doing this? Thanks in advance! GP 2010 has the ability for you to do this, but that won't help you now. There are a couple of options out there - I'm not sure of all of the functions these softwares offer, but I know they solve 'out-facing' document issues: Rockton Software's Dynamics Reports Manager: http://www.rocktonsoftware.com/products.aspx?p=3 Ac...

zip codes don't merge #2
I am trying to mail merge w/ Word 2000 the names and addresses in my worksheet. When I get to the part to choose the format for the mailing labels, I choose F1, F2, etc. to F6 (which is the zip code column). A few do get there, but the vast majority stop at the state, leaving off the entire zip code. I have gone to menu/format and selected text in the number tab. I have gone to format/cells and chosen special/zip code in the number tab. I've read Excel for Dummies. Please help me. TIA bb ...

concatenating two vendor codes
My company recently changed the vendor codes and now I end up with two separate sets of data for each vendor. Obviously I could just leave the vendor code field out. I don't want to do that so what I need to do is concatenate the two codes. Example Vendor Code Vendor Name 123 Joe's Supplies ABC Joe's Supplies what I need is this Vendor Code Vendor Name 123/ABC Joe's Supplies any ideas? Rather than create a new record for each vendor, add another field to the table -- call it NewVendorCode -- and put th...

How to automatically install S/MIME certs on PCs?
Hello, My company is about to roll-out a few hundred new PCs with Outlook 2003. One of our requirements on the new PCs is to use S/MIME to sign - but not encrypt - messages. We have a W2K3 CA so generating user certificates is relatively easy... but what's the best way to install and configure the certs on each PC? The mail profiles will be automatically generated on logon using the CIW but I can't see how to add the certs automatically. Thanks in advance for any pointers. - Alan. ...

Converting to PDF
I am designing a resume that will need to be emailed. I have tried several formats, including HTLM and Jpeg, but these seem not to display all the pages! What is the best format for emailing to end readers without publisher? and how to do it? Thanks!!! Your subject line answered your question: Convert to .pdf. If you can afford it, use Adobe Acrobat. If you can't there are several low cost/free alternatives available. -- JoAnn Paules MVP Microsoft [Publisher] "LJD Texas" <LJD Texas@discussions.microsoft.com> wrote in message news:EFCD18CC-2FA2-4B55-B467-B04592B5...

Can MS EXCEL remove duplicates and separate by color coded items ?
Can MS EXCEL remove duplicates and separate by color coded items ? I am NOT technical and have just started using MS EXCEL. Can anyone PLEASE HELP me: 1. How can I automatically remove duplicates using EXCEL ? ie the same info input more than once on different lines. Can EXCEL do this ? 2, I have color coded the text in the certain lines in terms of priority. can Excel rearrange the data by color ? If yes, How do I do it ? I think I have EXCEL '97 Thanks for your help in advance. Hi 1. You can extract the unique items to a new list using menu Data > Filter > Advanced fil...

How do i export a pivot chart as a static chart object?
I am trying to paste a pivot charts into Word. I am using pivot charts to create several charts of the same type from a block of data. Unfortunately when I pivot the chart, the pasted version in Word also changes, thereby making all the charts I am pasting change to be the same one as the currently pivoted one. I want the paste to be the Office Graphic Object rather than a picture file as I prefer the look and scalability of the graphic object. Is there any way to remove the link to the source Excel file when pasted into Word but retain the chart format? I am using Office 2007. Hi, As...

16 bit code
Hello, I have a 16 bit code to maintain. (It is too complex to copile it to 32 bit) so all we are doing is support. Now they want to add a small feature, where I need to copy long file names in the project. I know we can not do long file name copies in vc++ (1.52). So I wrote a program in VC++(6.0) which does directory copy. My questions are 1. How can I call a 32 bit exe (I guess WinExec should work)? 2. How can I make the 16 bit to wait till the 32 bit code completes? 3. Is there any other better way to do this? (other than converting to 32 bit) Thanks. I actually do this in an old 16-bi...

Z report not printing
All other receipts are printing and I can print a X report but cannot print a Z report. Have I missed something? Thanks guys. ...

area codes is auto filling my own 9 digit ph# vs just area code
When I enter a phone number for a contact it autofills with my personal area code and phone number instead of just the area code. How to I change this to just autofil the area code? I am using Outlook 2007 on an ACER laptop. Make sure you have your area code entered correctly in "Dialing Properties". "Computer Dummy" wrote: > When I enter a phone number for a contact it autofills with my personal area > code and phone number instead of just the area code. How to I change this to > just autofil the area code? I am using Outlook 2007 on an ACER ...

Non Delivery Reports- where do I change the FROM address.
Currently, all our NDRs have a FROM address which is the previous sys admin's name. But where do I change this so that NDR's FROM address is my name? So if I send an email to Jeff, who is not in the Active Directory, I get a NDR from JoeBlow who used to work here years ago.. Exchange 2003 -- | +-- JDMils | Does joeblow's account still exist? If so check his SMTP addresses and see if he has the postmaster address listed as a secondary address. If so remove it and add it to your account. James Chong MCSE + Messaging, MCTP msexchangetips.blogspot.com JDMils wrote: > C...

VBA Code for Pasting Sheets
I would like a spreadhseet that pastes the contents of one sheet into another sheet. I like like to do this for 7 different sheets For example: I would like paste the contents form sheet titled "sheet1" into a sheet titled "data1". Continue to process for pasting "sheet2" into "data2" and "sheet3" into "data3" all way until "sheet7" and "data7". thanks, Curt Subject: Automated Copy Paste Subject: Copy/Paste Import/Export Data VBA Code On Apr 27, 10:49=A0am, Curt <C...@discussions.mi...

How to disable Automatic Background Compaction?
Hi Folks, Hoping somebody can tell me whether there is any way at all (reg hack, third-party utility, etc ) to disable Automatic Background Compaction in Outlook 2003? Have googled extensively and also searched the registry for every appearance of the string "compact", all with no resulting joy. TIA Frank Frank Denman Denman Systems news@denmansystemsx.com [Please delete the "x" from my email address] Why would you want to, just out of curiosity? --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail se...

MC/VISA joint code
Isn't there any way to combine the blocks (4* & 5*) for MC/VISA credit cards? It's a pain to have them separate because my bank posts them together. It is the same company afterall. It would save me a lot of time adding separate entries together to reconcile the statement! I do not know of a way to do what you are asking, but I have found that using the # symbol as follows works better than using the * symbol: 4############### 5############### If you use the * symbol it is a wild card with no determined length. The # symbol requires that the characters after the first d...

MS exchange reports "0x80070005" You do not have apparent permissi
In exchange we accidentally through the wizard diabled the exchange features in a single account. We need to access the mailbox to retrieve users email. When we went add the exchange features back using the wizard to the single email account, exchange created a new mailbox same name and we are no longer able to connect to the previous email account through our outlook client. We recieve an error message MS exchange reports "0x80070005" You do not have apparent permissions" Any thought how to connect to the existing users email again? Thanks, Run cleanup agent on the ...

Excel Report Builder Security Issue
We are using GP 10 and I have someone who created a report in Excel Report builder but is not able to see it. When looking at his security, he has all the tasks under Excel Report builder including the one that says "Publish Report". Is there something else he would need to be able to see his report? Any input is appreciated. Thanks Barb ...

Money 2004 - Experian Offer
I just loaded Money 2004 Deluxe and converted my 2003 files with no problem. I decided to give the free year of credit monitoring from Experian a try but after filling everything out I get an error that the provided code has expired. I neither had nor provided any code for this offer, I only used the link from Money 2004. Now Experian was more than willing to set up a $79 account if I wanted to proceed. Any solution out there? I have the same problem... I am looking for a FREE way to contact Microsoft about this problem. >-----Original Message----- >I just loaded Money 2004 ...

Bug in Exporting Recurring Appointment from Outlook 2007?
When a recurring event is manually moved from Day 1 to Day 2, where Day 1 fits the recurrence pattern and Day 2 doesn't, the exported data doesn't pick up on this exception, so the exported data not matching what is displayed in the Outlook calendar view. The export process used is "File/Import-Export...", to Excel 2007. What are you trying to export to Excel - the moved meeting or the original? The moved meeting is no longer a part of the recurrence (if I recall correctly, you are warned when you move the meeting that the link will be broken). It is expec...

Analytical Accounting
Hi, One of my Client's is considering to go down AA path with approx 300,000 AA dimension codes. I would like to hear whether such data set is manageable from Query wizard etc. appreciate your thoughts. Good Morning PR, I found that the issue isn't the number of AA Trx Dim Codes it is the size of the AAG30000 and AAG40000 tables the more entries the longer it takes to product the report. I had one client that started having a cached SSRS report with AA information as a management level report and a different SSRS report with a more restrictive dataset for reporting ...

Cancel Report
On Open of a report I run code to open a form for the user to select filters for the report and it works great. However, my users want a cancel button on this form to cancel the report. I added the cancel button to the form and can close the form with no problem, but I can not figure out how to cancel the report itself. What makes this a little tricky is that this form is called by many reports so I would need a way to capture the name of the report to cancel! Please Help Thanks DDBeards You can use the OpenArgs argument when you open the form from the report to pass the reports n...

Change code with code?
Hi All..... I've got 31 Excel .xlsm files to modify the "Change Event" macro in. Is it possible to open and perform this with code, or must I do each one by hand? TIA Vaya con Dios, Chuck, CABGx3 If it is the same change in each sheet, it would probably be just as easy to go into the VBE, double click on the first sheet, make the correction, then copy that correction and double click the second sheet, delete and paste. Repeat the process 30 times. Takes less time than writing the code to do it. "CLR" <CLR@discussions.microsoft.com> wr...

Creation of New Database and Exporting Tables from an existing Dat
I am splitting 10 existing tables statewise. Each such split table will have a distinct name. Eg: In case of Family table, it will have the name of the Tables as, Family Karnataka, FamilyAndhrapradesh etc. I have opened 25 new / different Databases with the respective names of the states - such as Karnataka, Andhra Pradesh etc. Now, I want to copy these split tables to the respective databases. Such as FamilyKarnataka to the database of Karnataka and FamilyAndhraPradesh to the database Andhra Pradesh. Please duide me... S Haresha Babu Sr Manager (IT) Syndicate Bank ...

vlookup is reporting 0 when I want it to show a blank cell
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, <br><br>My vlookup formula is giving 0s when it encounters cells I've left blank my table. I'd like to know how I can get it to provide blank cells when it encounters blank cells. <br><br>Here's my formula string: <br><br>=VLOOKUP($C506,'Threats &amp; Conservation Actions'!$B$3:$N$42,6,0) <br><br>Thanks! The simple way might be to set the Sheet not to show 0 values. See the Excel help topic "Control how zero values are displaye...

Customization Report
How can I find: (i) The customizations that I haven't published yet? (ii) The cutsomizations that I have alread published and when? ...