Tray 3 not recognized in HP color Laserjet 4700

[dhv919401]

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....

 

[Jonathan West]

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....

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

 

[dhv919401]

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

 

[Jonathan West]

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.

 

[dhv919401]

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

 

[Jonathan West]

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.

 

[dhv919401]

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