Bundle Reports and Send to Adobe All at Once

  • Thread starter Thread starter Rebecca_SUNY
  • Start date Start date
R

Rebecca_SUNY

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
 
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?
 
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?
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
That was my second choice :-( and probably the easier way, although it
doesn't help me learn additional VBA programming tricks!! Thanks for your
help. I will try it today.

Graham Mandeno said:
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 said:
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 said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
That was my second choice :-( and probably the easier way, although it
doesn't help me learn additional VBA programming tricks!! Thanks for your
help. I will try it today.

Graham Mandeno said:
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 said:
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 said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top