Solved

Printing Access 2003 reports to different Printers

Posted on 2008-06-19
4
373 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

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

Title # Comments Views Activity
Reading the code behind a form - via VBA 3 31
Dinamic report to Crosstab query 9 33
IIF in access query 19 23
XML Node Counting in MS Access VBA 4 31
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

809 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