?
Solved

Print to a specific pdf printer and save the file to a fixed location

Posted on 2006-11-24
7
Medium Priority
?
207 Views
Last Modified: 2008-03-06
I have an event that currently opens a report in access. We then print this in pdf and save to a fixed loaction.

Can anyone advise on the code required to print this to a pdf printer (this is not my default printer) and to specify a network drive and save with date stamp.
0
Comment
Question by:Gallsey
  • 3
  • 2
5 Comments
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18008636
0
 

Author Comment

by:Gallsey
ID: 18018236
Sorry this did not help
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18019338
Here is a solution by puppydogbuddy that hinges on your requirements. How's your coding?

http://www.experts-exchange.com/Databases/MS_Access/Q_21764358.html?query=print+pdf+to+printer&topics=39
0
 

Author Comment

by:Gallsey
ID: 18083875
I tried what url but with no joy. Could you paste an example?

Thanks in advance
0
 
LVL 34

Accepted Solution

by:
jefftwilley earned 2000 total points
ID: 18084841
Are you wanting to change your printer designation at the time you print the report?
Were you not able to open the link above? Or coulen't follow the contents?

A docmd.openreport is used in VBA to open a report. The report can be opened either as a preview, or "normal..in which case it will go directly to your default printer. Below is an example of this.

DoCmd.OpenReport "rpt_exc_design_conagro_tasklist", acViewPreview, , "[Oper#WorkCenter] ='" & ctlComboBox.ItemData(i) & "'"
   
docmd.outputto is used by vba to direct where an object can be output and in what format. Below is an example of this.

    DoCmd.OutputTo acOutputReport, "rpt_exc_design_conagro_tasklist", acFormatSNP, "P:\Planning Engineers\Weekly Reports\" & ctlComboBox.ItemData(i) & ".snp", False
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

809 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