Solved

Printing Access 2003 reports to different Printers

Posted on 2008-06-19
4
375 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
[X]
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
  • 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

752 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