Solved

Setting printer properties in Vba

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

820 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