Solved

Setting printer properties in Vba

Posted on 2013-11-19
3
882 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
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

822 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