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
Solved

Microsoft Access 2010 - Can I turn off the auto-detection of printers when testing printing on a development computer?

Posted on 2013-01-23
7
627 Views
Last Modified: 2013-01-23
When I modify a Microsoft Access 2010 application and print on my test system, Access automatically changes the printer settings to my printer. When I install the application on the client system, they have to reconfigure printer settings. How can I solve this problem. Thanks!
0
Comment
Question by:pabrann
  • 3
  • 3
7 Comments
 
LVL 84
ID: 38809743
Make sure you've set the reports to use the Default printer:

http://www.devhut.net/2011/05/26/ms-access-vba-set-report-to-use-default-printer/
0
 

Author Comment

by:pabrann
ID: 38809797
Thanks for your note. That's the issue, my client has to set certain reports to specific printers. Some double sided, some not, etc. If I print a test report on my development system, I've had to let it print on my default printer. Then, they have to reconfigure the report for their printers.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38809880
The only real fix for that is to store the "ReportPrinter" in the database somewhere (perhaps build a table to store them), and then run a routine like above and set the Report's Printer object to the user's stored values.

So I'd have a table like this:


USysReportPrinters
--------------------------------------
ID (AutoNumber, PK)
Reportname
PrinterName

I'd add the name of each Report and the printer to be associated, then use code to find that value in USysReportPrinters and set the Printer as defined.

This link shows how to set the report printer, but be aware that you cannot do this if you deploy a .accde file:

http://support.microsoft.com/kb/319317?wa=wsignin1.0

If you can't do that, and need to give the end user more control, you can use the techniques described here:

http://www.access-programmers.co.uk/forums/showthread.php?t=204210

Basically, that posting sets the Application.Printer object when a report is opened, and then resets it to the default when the report is closed.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38809939
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38810294
@LSM
are you coming to the 2013 mvp summit ?
rey
0
 
LVL 84
ID: 38810588
cap: I'm signed up, but it depends on money. I hope to make it, but we'll have to see ...
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38810615
@LSM, hope to see you there.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Outlook Free & Paid Tools
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

808 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