Eric Harris
asked on
Printing Access 2003 reports to different Printers
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
thanks for you comments.
ASKER
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.