Tray 3 not recognized in HP color Laserjet 4700

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dhv919401 - 20 Jun 2007 18:34 GMT

We were having HP color Laserjet 4600 before. We have a custom code
written in VBA within GreatPlains (Dynamics Version 9.0) to launch
Crystal Reports which uses Crystal Viewer control. When the users
click a button on Sales Screen to print an invoice, it gives a drop
down with values 'Prelimanary', 'Final'. When the user picks
'Prelimanary' the report has to print to the default tray (TRAY 2).
When the user picks 'Final' it has to print from 'TRAY 3'. The code
used says
If frmTray.strValue = "Preliminary" Then
'Tray 2
CRReport.PaperSource = 2

Else
'Tray 3
CRReport.PaperSource = 11
End If

This code used to work perfectly with HP Color Laserjet 4600 with PCL
5 driver.
Now we just changed the printer to HP Color Laserject 4700 with PCL 5
driver.

Suddenly it stopped functioning. It is not able to pick up from the
TRAY 3.

I pulled the HP Color Laserject 4700 Software Technical Reference and
looked for the media source commands and used the numbers assigned for
the trays.

Whatsoever I do it is not recognizing.
Any help from anybody is really appreciated.
Looking forward to get some responses....

Reply to this Message

Jonathan West - 20 Jun 2007 18:59 GMT

> We were having HP color Laserjet 4600 before. We have a custom code
> written in VBA within GreatPlains (Dynamics Version 9.0) to launch
[quoted text clipped - 28 lines]
> Any help from anybody is really appreciated.
> Looking forward to get some responses....

Its a mess. This article will help you out.

Controlling the Printer from Word VBA
Part 1: Using VBA to Select the Paper Tray
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

dhv919401 - 21 Jun 2007 21:31 GMT

Thank you for your reply.
Our problem is:
When I print a document/report....
1. If I set the Papersource = TRAY3 PaperType=Unspecified then it is
not recognizing TRAY3
2. If I set the Papersource = TRAY3 PaperType=Letterhead then it is
printing from TRAY3

But unfortunately Crystal Viewer control does not the property of
PaperType.

This is really eating my time. Any advise is appreciated. Thank you

Reply to this Message

Jonathan West - 22 Jun 2007 16:11 GMT

Ah, I hadn't read your original email as thoroughly as I might have done. I
thought you were using Microsoft Word - this group deals with VBA in
Microsoft Word. I'm afraid I have no knowledge of the Crystal Viewer control
nor of Great Plains and no means of advising you how to make it work right.

You might like to repost your question to
microsoft.public.dynamics.pg.developer.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

> Thank you for your reply.
> Our problem is:
[quoted text clipped - 8 lines]
>
> This is really eating my time. Any advise is appreciated. Thank you

Reply to this Message

dhv919401 - 22 Jun 2007 17:45 GMT

Ya.. I posted it in 4 groups. But nobody responded. But thank you
for your response and time.

Reply to this Message

Jonathan West - 22 Jun 2007 18:32 GMT

> Ya.. I posted it in 4 groups. But nobody responded. But thank you
> for your response and time.

If you must post to multiple groups, please put all the groups in the header
for a single message. That way, if the message is replied to in one group,
everyone can see, and so not need to respond elsewhere.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

dhv919401 - 25 Jun 2007 23:26 GMT

I will certainly do it next time. I did not know that though.
Everyday we learn something new.... Thank you once again...

Reply to this Message