Printing a form in MS Access on 7 printers simultaneously

  • Thread starter Thread starter Tahsen
  • Start date Start date
T

Tahsen

I would like to get some information on printing a form
simulataneously on 7 different printer on MS Access. I
create a database on MS Access and create couple forms and
on each form I create a commmand button to print the form
but this one only prints on a default printer. So can
anybody tell me right code to write on this icon so that i
could print on 7 printers simultaneously. Thanks and
appreciate your quick response.
 
I would like to get some information on printing a form
simulataneously on 7 different printer on MS Access. I
create a database on MS Access and create couple forms and
on each form I create a commmand button to print the form
but this one only prints on a default printer. So can
anybody tell me right code to write on this icon so that i
could print on 7 printers simultaneously. Thanks and
appreciate your quick response.
Click to expand...

I guess that you would need to have 7 versions of the report, each set up to
print to a specific one of the 7 printers (in "Page Setup..."), and your code
would need to open each report in succession. I suspect, however, that it would
be cheaper to use the photocopier. <g>
 
Multiple reports is probaly simplest, but you can always use the DEVMODE
structure and API calls to change the default printer. A search on the Web
should net you sample code to do that.
There is also a code example in the Access Delveloper's Handbook by Litwin,
Getz and Gilbert.
This is a book any serious Access developer should have.

Ragnar
 
Multiple reports is probaly simplest, but you can always use the DEVMODE
structure and API calls to change the default printer. A search on the Web
should net you sample code to do that.
There is also a code example in the Access Delveloper's Handbook by Litwin,
Getz and Gilbert.
Click to expand...

The report needs to be opened in design mode for the new settings to be applied
and then saved in order to use this approach. Modifying a report that often
might be asking for trouble and it won't work with an MDE/ADE file or under the
RunTime version of Access, either. If using Access XP, or later, one might take
a look at the "Printers" collection and "Printer" objects that can give you some
extended capabilities without the complexity of using the DevMode structures or
the API. The preferred approach, even using this method, requires opening your
report multiple times and setting the report's "Printer" each time from the
calling code. I still prefer the multiple reports or photocopier approach,
however. said:
This is a book any serious Access developer should have.
Click to expand...

No argument there. :-)
 
Hi Bruce,

I am sorry, I should jhave been more specific. I meant changing the Windows
default printer.

Ragnar
 
Back
Top