Solved

Printing Access 2003 reports to different Printers

Posted on 2008-06-19
4
374 Views
Last Modified: 2013-12-05
I have an Access 2003 ADP with SQL Server 2000 Backup.
I have about 30 user using this system. I print some word documents internally and lots of differnt Access reports.
The majority work on a Server (via thin client)
The have HP Lasejet 2430 with 2 feeder trays.
The bottom tray always contains pre printed stationary,  tray 2 always has plain paper. I can control the printing of word docs using vba so that my letters always got to tray 3. The users default tray is tray 2. So all my reports are defaulted to tray 2.
This all works a treat.
However, I have some users who sit in offices with PC's and directly connected printers. These printers do not have the extra tray. They have Manual Tray and Tray 1.
When the application is loaded for these users it interprets the tray to be manual.
This requires the user to perform a physical override for every report they run.

Is there some way to detect these users (via their default printer) and perform a tray detting manaully.
I think this would have to be done within access after it has loaded.
I therefor assum that I might need to open the report in design mode and change the tray settings before printing and change them back again afterwards.
I don't know how to code this.

does anyone have any ideas.
0
Comment
Question by:EWHTLC
  • 3
4 Comments
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 500 total points
ID: 21824466
I don't understand. If the reports are configured to use default printer, and default is tray 1, why doesn't it go to tray 1?

anyway, one way to resolve this is: add new printer, same as the default one; configure it to use the parameters you want (tray, orientation, etc.); give it some unique name, for example AccessReportsPrinter; and format the reports to print on that printer, or format to use default printer and in vba change default printer to AccessReportsPrinter before generating the report.
0
 

Author Comment

by:EWHTLC
ID: 21825128
Not too sure abount that.I think I see what you mean. I'll give it a try,

To further explain my problem.
The reports are developed on a machine which has the same printer setup and the majority of my users. On the page set up is uses tray 2 as the default.
When a user logs on who doesn't have that particular printer, it gets it's knickers in a twist. It doesn't have a tray 2 so it defaults to manual feed (for some reason). It would be great if it defaulted to tray 1 but it doesn't.
As soon as the Application is opened it seems to pick up the users default printer. If that doesn't confirm to the one set up in the access reports it ties to configure itself and gets messed up doing so.
0
 

Author Comment

by:EWHTLC
ID: 21910934
Well I gave up in the end.
My problem was that the printer sofware calls the trays differentlly than the hardware. It was the harware config that I needed to change.
Needless to say that different printer hardware adds to the problem.
I found a way to programatically change these settings but over a network it takes that long to process that it defeats the object.
AS a workarounf I have changed the users default printer. I works but defeats the object as the user has a local printer but now have to retrieve their reports from elsewhere.
0
 

Author Closing Comment

by:EWHTLC
ID: 31468891
thanks for you comments.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

756 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