Complex printing question

[joel]

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.

The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually re-
printing "pages n..n+5" or whatever, we do not have a way.

thanks
joel

[paii, Ron]

Open the report filtered by client or group of clients and send it to the
required printer. Do this once for each destination printer. I understand
new version of Access have a printer object that will allow you to switch
printers using VB code, someone else will need to help you with that.

"joel@" <jo***********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.

The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually re-
printing "pages n..n+5" or whatever, we do not have a way.

thanks
joel

[joel]

On May 3, 12:26 pm, "paii, Ron" <[e-mail]:

Open the report filtered by client or group of clients and send it to the
required printer. Do this once for each destination printer. I understand
new version of Access have a printer object that will allow you to switch
printers using VB code, someone else will need to help you with that.

"joel@" <[e-mail] in message

news:11**********************@y80g2000hsf.googlegr oups.com...

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.

The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually re-
printing "pages n..n+5" or whatever, we do not have a way.

thanks
joel- Hide quoted text -

- Show quoted text -

This is the way we are running it now. The problem is we have to
manually do it once for each dest. printer. We need Access to handle
this.

[paii, Ron]

"joel@" <jo***********@gmail.comwrote in message
news:11*********************@l77g2000hsb.googlegro ups.com...

On May 3, 12:26 pm, "paii, Ron" <[e-mail]:

Open the report filtered by client or group of clients and send it to

the

required printer. Do this once for each destination printer. I

understand

new version of Access have a printer object that will allow you to

switch

printers using VB code, someone else will need to help you with that.

"joel@" <[e-mail] in message

news:11**********************@y80g2000hsf.googlegr oups.com...

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.

The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually

re-

printing "pages n..n+5" or whatever, we do not have a way.

thanks
joel- Hide quoted text -

- Show quoted text -

This is the way we are running it now. The problem is we have to
manually do it once for each dest. printer. We need Access to handle
this.

Search the user group, I recall someone asking about switching printers and
settings with some replies on how to do it. I am running Access97, so one
way would be to set the report to use the default printer and change the
default using a Windows DLL before opening the report. Another is print each
client to PDF and use the shell command to send it to the printer.

[robert.waters]

On May 3, 12:37 pm, "paii, Ron" <[e-mail]:

"joel@" <[e-mail] in message

news:11*********************@l77g2000hsb.googlegro ups.com...

On May 3, 12:26 pm, "paii, Ron" <[e-mail]:

Open the report filtered by client or group of clients and send it to

the

required printer. Do this once for each destination printer. I

understand

new version of Access have a printer object that will allow you to

switch

printers using VB code, someone else will need to help you with that.

"joel@" <[e-mail] in message

>news:11**********************@y80g2000hsf.googleg roups.com...

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.

The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually

re-

printing "pages n..n+5" or whatever, we do not have a way.

thanks
joel- Hide quoted text -

- Show quoted text -

This is the way we are running it now. The problem is we have to
manually do it once for each dest. printer. We need Access to handle
this.

Search the user group, I recall someone asking about switching printers and
settings with some replies on how to do it. I am running Access97, so one
way would be to set the report to use the default printer and change the
default using a Windows DLL before opening the report. Another is print each
client to PDF and use the shell command to send it to the printer.

dim origPrinter as printer
origprinter = application.printer
set application.printer = application.printers('desired printer name')
' business logic
' set the printer N times if you like
set application.printer = origprinter