Re: Bundle Reports and Send to Adobe All at Once

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Rebecca

I'm not familiar with Adobe Acrobat 9 Pro, but presumably the code below
results in a dialog box popping up which asks for the output file. Is there
any option there to append to an existing file? I can see that even this
would be a pain, because your users would need to specify the output file
for each report in the "bundle".

There is no way in Access to bundle multiple reports in a single print job.
However, you could try bundling your reports into a single report.

Create a new report named rptBundle1 and add all the component reports to
the detail section as subreports, with page breaks in between them. If you
wish, you could add an overall report header and/or footer for page
numbering across the entire document.

If you've set it up correctly, then printing this single report should have
the same result as printing all the components of the bundle one by one.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Rebecca_SUNY" <RebeccaSUNY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D976272A-AC30-455C-AB7F-3DBC20DE7218@xxxxxxxxxxxxxxxx
I am using Adobe Acrobat 9 Pro. Adobe is set up as a printer and I just
set
it as the activt printer and print to it. The Excel code is

Dim sWorksheet1 As String
Dim sWorksheet2 As String
Dim sWorksheet3 As String

sWorksheet1 = "DOB Summary"
sWorksheet2 = "DOB Function"
sWorksheet3 = "DOB Dorms"

' bundle worksheets and print
Sheets(Array(sWorksheet1, sWorksheet2, sWorksheet3)).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1

End Sub


"Graham Mandeno" wrote:

Hi Rebecca

First you need to tell us what PDF generating software you are using (PDF
creation is not native to Access 2003).

Then it would help to know the code you are using to successfully create
a
PDF from a single report.

And finally, what code did you use to achieve this from Excel?

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Rebecca_SUNY" <RebeccaSUNY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB4BFB93-295B-4C94-A991-948920CD0AA5@xxxxxxxxxxxxxxxx
Access 2003

I would like to set up a form that allows the user to select one of two
options for a series of reports (bundle1 or bundle2) and then click a
button.
When the button in clicked the reports will bundle together and print
to
Adobe as ONE PDF file. I have defined the two options and have the
form
working correctly but I can't get the code to bundle the reports and
print
to
PDF. I have done this in Excel with arrays but it will not work in
Access.

Any ideas?

Rebecca





.

Relevant Pages

  • Re: Bundle Reports and Send to Adobe All at Once
    ... There is no way in Access to bundle multiple reports in a single print job. ... you could try bundling your reports into a single report. ... Dim sWorksheet1 As String ... First you need to tell us what PDF generating software you are using (PDF ...
    (microsoft.public.access.modulesdaovba)
  • RE: send to file button
    ... Yes - this is informative but disappointing. ... review my options and see what the best way to export Access reports will be ... The only exception to this is that when you output the data in a report ... > expression with the Sum function is included in the output file. ...
    (microsoft.public.access.formscoding)
  • Re: problem with compiling under G77
    ... compiler to completely compile OR finally link). ... And it is correct on a direct compare of the 1978 report file aagainst ... my output file. ... and no sense switches or sense lights found. ...
    (comp.lang.fortran)
  • Re: Befuddled at crunch time
    ... Thanks for the guidance, this allows me to get ALL the lines required ... in my output file, but my spacing is still way off, I can't have any ... I need a header row like in a Report. ...
    (comp.databases.ms-access)
  • Re: Backup failed!
    ... When I defined a report, I got the error, now I just need to know "Why do ... SQLServer says it delete a file, ... > step and catch the error messages in the output file. ... >> Nope, there is no hint, the best hint is ...
    (microsoft.public.sqlserver.programming)