Changing a report's print settings programmatically

Posted on 1999-11-09
Medium Priority
Last Modified: 2008-03-10
I need to change a report's print settings by manipulating the prtDevMode and prtDevNames properties. From the web site www.microsoft.com/AccessDev/Articles/GetzCh10.HTM I have an article by Ken Getz that explains how to do it. However I need a copy of his sample database CH10.mdb in order to be able to use his sample code.  If anyone could email me a zipped copy of this file I would be very grateful. My email address today (working from home) is "k.muntz@usa.net". Specifically I need to be able to change printers and bins (without continual user intervention each time they print the report).
Question by:kmuntz

Accepted Solution

JimMorgan earned 400 total points
ID: 2196458
If you have "Access 97 Developer's Handbook" by <Sybex>, you have the CD with the samples.  If not, I have the book and the CD and can email you the chapter.


Author Comment

ID: 2199266
Thankyou - I did not want to have to buy the book for Access 95 just to get this code. My Developer's book on Access 97 (by Leszinsky) does not address the problem of changing report printer setting programmatically.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month7 days, 8 hours left to enroll

607 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