Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

access DOCmd.output report

Posted on 2007-07-26
11
Medium Priority
?
1,624 Views
Last Modified: 2013-11-28
I am so confused on this DoCmd and how to use on my report..
I basically need only 1 thing.
1.  To turn my report into a PDF document and store it on my c:\ .
I have a form which looks like this:    and my report is called "test1"    
*********************************
Manager (combo Box)
Sup      Email (hyperlink field to send to Sup and Manager)
*********************************  
So this is what I have:
1. DoCmd.OutputTo acReport , "test1", acFormat, "c:\test1"  <-- how to make it a PDF?
0
Comment
Question by:TechMonster
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 19580549
Do you have a pdf writer installed on your machine?

If so, then you have to set your report to use that printer and then open the report to print.

(If you have A2007 the situation might be different)
0
 

Author Comment

by:TechMonster
ID: 19580574
Is there a way to do this by the VB code?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 19580613
DoCmd.Openreport "Reportname",acViewnormal
opens the report.

To set the printer open the report in design view, select the printer, then save the report and close it.
You can reset the printer to the default.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:TechMonster
ID: 19580638
Can you provide an example code on how I can not open it up but just by code,,make my report into
a PDF on my c:\?
0
 

Author Comment

by:TechMonster
ID: 19580641
or maybe even save to a word doc would be good...
0
 
LVL 77

Expert Comment

by:peter57r
ID: 19580763
There is an article on changing printers  and a utility here:
http://allenbrowne.com/AppPrintMgt.html
0
 
LVL 29

Expert Comment

by:Badotz
ID: 19581296
Without a 3rd-party tool, you cannot "make" Access output a PDF file.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1500 total points
ID: 19581584
0
 

Author Comment

by:TechMonster
ID: 19582471
i saw a lot about Lebans when reading the forums on this subject.  Don't really understand how it works...Is that a plugin which i can use to convert the report over to PDF on my local hard drive..?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 19583106
TechMonster,
you download the zip file.
Unzip it to any folder.

Open the mdb file and open the forms ReadMeFirst and HowToUSe for the instructions
0
 

Author Comment

by:TechMonster
ID: 19600937
Searching through the Lebans solution...I am able to save a report to my desktop using.
DoCmd.OutputTo acOutputReport, rptName, "SnapshotFormat(*.snp)", _
'       strPathandFileName

Still having an issue with how to use but I think maybe that is going to require some extra work...
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question