Choose Printer Tray with a VBA Code

[vinchi1974]

I need a VBA code to let me choose to which tray i would like the report to print.

[June7]

Google: Access VBA select printer destination tray

Review the links in http://answers.microsoft.com/en-us/o...f-7c8e15f3bcd2

The information is focused on Word but much of it will also apply to Access.

Example code from my db:

'open report in preview mode because is only way to change bin and/or printer destinations
DoCmd.OpenReport strReport, acViewPreview, , "Submit.LabNum='" & strLabNum & "'", acWindowNormal
If Application.Printer.DeviceName Like "*HP4K*" Then
    'Set the report destination paper bin to Tray 2
    'Use number not name, cannot exceed 250
    Reports(strReport).Printer.PaperBin = 2
End If
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, strReport, acSaveNo