J
Jonathan
Hi, using Access 2003. I want to allow users for each report to select a
printer (for example a HP laser printer) and printer bins. These settings are
saved in a table and is retrieved when printing.
ptr.PaperBin = rsRptPtr!rptrTray
Setting the printer this way works. Unfortunitely when the printer tray/bin
has an internal number greater than 255 it generates a system error. It seems
that this is a known error and is supposedly resolved by article id 919941.
I've downloaded and installed this hotfix. Unfortunitely the problem still
persists.
The knowledgebase article, How to programmatically change paper bins when
you print reports in Access 2002 by using Visual Basic for Applications...
http://support.microsoft.com/default.aspx?scid=kb;en-us;279506
.... is useful, however does not resolve this problem - How to consistently
allow users to select printer bin/tray for a report, even when the printer
driver has a number greater than 255 to reference a specific tray/bin.
Any ideas or suggestions appreciated
Many thanks
Jonathan
printer (for example a HP laser printer) and printer bins. These settings are
saved in a table and is retrieved when printing.
ptr.PaperBin = rsRptPtr!rptrTray
Setting the printer this way works. Unfortunitely when the printer tray/bin
has an internal number greater than 255 it generates a system error. It seems
that this is a known error and is supposedly resolved by article id 919941.
I've downloaded and installed this hotfix. Unfortunitely the problem still
persists.
The knowledgebase article, How to programmatically change paper bins when
you print reports in Access 2002 by using Visual Basic for Applications...
http://support.microsoft.com/default.aspx?scid=kb;en-us;279506
.... is useful, however does not resolve this problem - How to consistently
allow users to select printer bin/tray for a report, even when the printer
driver has a number greater than 255 to reference a specific tray/bin.
Any ideas or suggestions appreciated
Many thanks
Jonathan