Recent content by platypus

Great, the code from the Microsoft site works a treat after I worked out our printer's tray codes :) Thank you!

The simple question is, why is the query not executed from within the TwoTrayPrinting function? DoCmd.OpenReport ReportName, acViewDesign, "qryReviewLetter" I just don't understand. Surely, someone here must understand the vagaries of MS Access better than me...no?

I have a form with a button that runs this code: Private Sub Command645_Click() On Error GoTo Err_Command645_Click Dim stDocName As String stDocName = "myLetter" 'Calling TwoTrayPrinting function from SelectPrinterTray Module ' to select letter head tray for first page of report plain...