Selecting printers 2

[belgiumbob]

How do I select a printer from within my code?

I have two forms, one to be printed on a standard printer, the other (a barcode label) to be printed on the label printer.
Do I write code for this (and if so, how?) or do I have to change something (properties of the forms, ... )

Thankx, Belgiumbob

 

[bocker]

For the Form or Report that you don't want to use the default printer:

In design view (Form/Report)
File - Page Setup
Page Tab
Select Use Specific Printer
Click on Printer and set up the Printer you want to use.

 

[belgiumbob]

Message to Bocker,

Thank you for your solution. It is indeed as simple as that. However, the purpose is to install the program as an .exe and install the database itself on a server. The users will not be able to change anything to the program or the forms themselves.
Suppose that the label printer is replaced by an other printer, than the form has to be adapted so that the form will be printed on the new label printer. Does this mean that I have to re-install the program with the adapted form, or is it possible to program this, so that the user can select the correct (new) label printer?
For example: a form with: "Labels to be printed on :" and a drop-down list with available printers to choose from. Once choosen, the label form will be printed on the selected printe until the user changes it again.

I want to avoid re-installing everything only for the purpose of changing the destination printer of one form.

Thanks, Bob

 

[THoey]

Try the following site:

http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

Terry M. Hoey