Solved

Setting printer properties in Vba

Posted on 2013-11-19
3
941 Views
Last Modified: 2013-12-09
I have an Access application that prints pdf files by using the command line switches for adobe reader.  This works fine except that when I change the papersize for a printer using the printer object:
 
     Application.Printer.PaperSize = acPRPS11x17)

and then print the drawing using Adobe reader:

     c:\program files (x86)\adobe\reader9.0\reader\acrord32.exe /t <drawingpath>

it does not use the new paper size settings.
Is this because I am calling an application outside of Access?
0
Comment
Question by:dsoderstrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 27

Accepted Solution

by:
jjafferr earned 250 total points
ID: 39661766
I searched, and all I got was:
the command line does not support selection of paper format or other advanced options.

However, The following switches are available:
/t <filename> <printername> <drivername> <portname> - Print the file the specified printer.

so what I assume you can do is, copy the adobe pdf printer to another name, change the paper size, and save it.
Then you can call this printer for your specific paper size.

jaffer
0
 
LVL 12

Assisted Solution

by:pdebaets
pdebaets earned 250 total points
ID: 39661792
Well, you are saying Application.Printer.Papersize =

Then when you print, you are running a different application - "acrord32.exe"
0
 

Author Closing Comment

by:dsoderstrom
ID: 39706980
solutons presented did not solve the problem but need to close the question
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

690 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