Select the Printer Tray for a Report

[andegre]

I want to be able to have the user select a printer tray before actually printing the report. Is this possible?

 

[assets]

Yes but you need VB code, But for the purpose of the excerise asume its a HP then it would be different for a 5m, 4050 or 4350. So you need to test for the printer driver it works in word.

Never give up never give in.

There are no short cuts to anything worth doing

 

[ZmrAbdulla]

Private Sub cmdPrint_Click()
    DoCmd.RunCommand acCmdPrint
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[andegre]

Zameer, that prints the form, not the report.

Assets, I am doing almost everything in VB Code, or do you mean Visual Basic and not Visual Basic for Applications?

 

[assets]

Yes I mean VB and not VBA. I think there was somthing about it in a google group. We had ours done as we have about 50 printers and about 8 different types. we wanted to print the first page from tray 2 and the rest from tray 1. Also there is problems with PCL5 and PCL6

Never give up never give in.

There are no short cuts to anything worth doing

 

[ZmrAbdulla]

If this is a VB6 question than VBA then please post to the appropriate forum.(forum222)

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[assets]

Then again you could look at macros. You can also search the printer forums. I remember something (other than the question I asked). Sorry I can not be of more help.

Never give up never give in.

There are no short cuts to anything worth doing

 

[ZmrAbdulla]

Access VBA

http://www.mvps.org/access/reports/rpt0009.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.