Improve company productivity with a Business Account.Sign Up

x
?
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
Medium Priority
?
639 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 86
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 86

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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 86
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access. The declaration statement de…

589 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