Avatar of mlcktmguy
mlcktmguy
Flag for United States of America asked on

Reports To Different Trays

I have developed an application for a client that has the one option to print a cover letter and account statement for a given client.  These will be done one client at a time.  Both of the outputs are on 8.5 x 11.  The account statement prints on a pre-printed form.

The would like the client letter to be sent to tray 1 and the statement to tray 2.  How can this be done generically on a report?  The only options I see on page set up are
Automatic,  Manual Paper Feed and Cassete.  I guess setting the statement to Manual would at least pause so they could change the paper but a smoother process is obviously preferable.
Microsoft Access

Avatar of undefined
Last Comment
mbizup

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

<The account statement prints on a pre-printed form.
The would like the client letter to be sent to tray 1 and the statement to tray 2. >
So the "Account Statement" and the "Client Letter' are two separate "Reports"?
If so, you may be able to do this by setting the default printer in the Report's Page Setup and select the needed tray in the Properties...

Another option would be to recreate the "Account Statement" with an Access report. (by scanning the original and inserting it as a graphic on an Access Report.)
Then you could even connect the two reports (use one as the Report or Page Header) and print them out at the same time on the same printer.
mlcktmguy

ASKER
Sorry for the delay, I haven't had a chance to evaluate/try any of the suggestions.
mbizup

Okay - The solution I posted is tried and true, so I'm confident that it will work for you.

That said, if you have any issues with it, I am still subscribed to the question and you can either post here with any follow up problems or use the Request Attention button to have the question reopened.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy