Printing Control Panel

[brixie11]

Hi.

Is it possible to set up a form named Settings where to be two combo boxes to select two printers that will be used in the project. I'm thinking of two variables that are named SelectPrt1 and SelectPrt2 As Printer. Then when I need to print report I can use SelectPrt1 and when I want to print stickers I use SelectPrt2 in the OnClick procedure?

Thanx, Brixie.

 

[DCrake]

When you create your reports you can define which printer to use to print the report or stickers. Then it will automatically use these, no need to get user responses each time.

David

 

[brixie11]

Problem is that I'm printing reports in a silence mode. Programaticly create report, print and delete report.

 

[DCrake]

Why are you doing that? Surely there is no need to do this or am I missing something?

Can you not have a standard report that is populated with an underlying record source.

David

 

[brixie11]

I have a database for packaging department. With that report I'm printing stickers for the boxes. And I thought there is no need for worker to see the report. So if I understand you correctly, I should make a permanent report and just pop it up when I want to print the sticker? When I create the report I just set the printer to that report?

 

[DCrake]

To put this into context I had, a long time ago, a system that printed out a label on a plastic bag. This was done through DDE (which is not relevant in this case) All I did was to create a report and specified which printer I wanted to use as the output device. Similar when you are producing shipping labels. My report had a large text area that printed "Bag n of y".

As I had already specified the printer to use when I created the report Access remembers this when it prints. It does not use the default printer. If you do not specify a printer it automatically uses the default printer.

My reports were based on queries which controlled the output recordsets and printed blindly. All you see is the normal Windows "Printing Report to ....." dialog box.

David

 

[gemma-the-husky]

which version of Access are you using?

there was no printer object in A97 - so setting printers in code at that time was not easy. I think the functionality ot do this was added in A2003 (maybe A2000)

 

[brixie11]

Ok, if I want to use two printers ( one is a sticker printer which uses bundle of blank stickers and other to print invoices which is a normal printer ) all I have to do is to create reports and assign the correct printer to them?

P.S. I'm using Access 2007.