Solved

Printing Access 2003 reports to different Printers

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dsum Function for List Box Data 7 47
Modal form 11 30
ACCESS 2010 - VBA - generic Table Open Button - Code 7 24
VBA SQL statement - 2 "OR"s and 1 "And" 4 27
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…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

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