Printing two reports.

[BillBee]

I want to print two reports using a command buttons on the same Form. The data on one is info regarding entries to a Bird Show the second is to print labels with similar data. At present I can Print the reports okay but to do so I need to remove the paper and replace this with the label page when I print each Report. This is a little clumsy so I tried setting up two printers, changed the code to produce the print preview which has its own problem, this being I cannot see the print preview unless I Move the screens covering the preview. After moving them I can then get a print dialogue screen which allows me to choose the printer but again this is time consuming. Can anyone tell me how I could easily direct the printing to the two printers from each command button or suggest a more practical method to perform this function

 

[stopher]

From what I recall, changing the default printer on the fly is a bit messy. However, you can set each report to go to its own designated printer.

For Access 2007:

• In print-preview mode, right click somewhere on the page and choose “Page Setup”.
• Click on the “Page” tab.
• Select the “Use Specific Printer” option and choose the appropriate printer for that report.
• Do the same for each report that doesn’t use the default printer

I assume this fuctionality is available in A2003 but I can't check just now.

Chris

 

[BillBee]

Thanks for reply. Am using Access 2007. I am doing what you have said. The difficulty is when I press the command for the Print Preview I cannot see the page to click on it. It is always hidden right at the back of Open forms. I have to move the forms to get at the screen to be able to click on it. I do not seem to be able to select a specific printer just the once I am having to select each time there is a new exhibitor with a new report.

 

[gemma-the-husky]

you could do these things

1. open reports in preview, and manually pick printer

2. preset, as advised above - you actually need to set the printer in report design, in in report preview - then you wont get the hidden problems you describe

3. you could also change your code to this sort of thing

open report1, preview mode
while report open, do events
when closed add a msgbox to remind user to change paper type
then open report2, preview mode

 

[BillBee]

Sorry to have taken so long to get back. Have sorted problem