By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,239 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

Can OutputTo append?

P: n/a
Short version: is it possible to set OutputTo so that it will append
to an existing RTF document instead of creating a new document each
time? (I'm using Access XP)
Full scenario: I generate 11 related reports every two weeks (bowling
league stats), from various and sundry recordsets. These reports must
be combined into a single document, which is then sent on its way as
an e-mail attachment.

I believe my only feasible route for automating the combining part is
to export each separate report, then automate the document merge on
the Word side, as I don't see an OutputTo argument that would
accommodate this. But I figure if such a thing exists, one of you
folks will know of it.

Or perhaps there's a different angle I should be looking at this from?

Any direction you can offer me will be greatly appreciated.

Thank you!
Kelly
Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
It cannot.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Kelly Sellers" <ke***********@hotmail.com> wrote in message
news:76**************************@posting.google.c om...
Short version: is it possible to set OutputTo so that it will append
to an existing RTF document instead of creating a new document each
time? (I'm using Access XP)
Full scenario: I generate 11 related reports every two weeks (bowling
league stats), from various and sundry recordsets. These reports must
be combined into a single document, which is then sent on its way as
an e-mail attachment.

I believe my only feasible route for automating the combining part is
to export each separate report, then automate the document merge on
the Word side, as I don't see an OutputTo argument that would
accommodate this. But I figure if such a thing exists, one of you
folks will know of it.

Or perhaps there's a different angle I should be looking at this from?

Any direction you can offer me will be greatly appreciated.

Thank you!
Kelly

Nov 12 '05 #2

P: n/a
DFS
You can write some VBA code to append the multiple docs into a single file,
after OutputTo generates them.

"Kelly Sellers" <ke***********@hotmail.com> wrote in message
news:76**************************@posting.google.c om...
Short version: is it possible to set OutputTo so that it will append
to an existing RTF document instead of creating a new document each
time? (I'm using Access XP)
Full scenario: I generate 11 related reports every two weeks (bowling
league stats), from various and sundry recordsets. These reports must
be combined into a single document, which is then sent on its way as
an e-mail attachment.

I believe my only feasible route for automating the combining part is
to export each separate report, then automate the document merge on
the Word side, as I don't see an OutputTo argument that would
accommodate this. But I figure if such a thing exists, one of you
folks will know of it.

Or perhaps there's a different angle I should be looking at this from?

Any direction you can offer me will be greatly appreciated.

Thank you!
Kelly

Nov 12 '05 #3

P: n/a
DFS
You can write some VBA code to append the multiple docs into a single file,
after OutputTo generates them.

"Kelly Sellers" <ke***********@hotmail.com> wrote in message
news:76**************************@posting.google.c om...
Short version: is it possible to set OutputTo so that it will append
to an existing RTF document instead of creating a new document each
time? (I'm using Access XP)
Full scenario: I generate 11 related reports every two weeks (bowling
league stats), from various and sundry recordsets. These reports must
be combined into a single document, which is then sent on its way as
an e-mail attachment.

I believe my only feasible route for automating the combining part is
to export each separate report, then automate the document merge on
the Word side, as I don't see an OutputTo argument that would
accommodate this. But I figure if such a thing exists, one of you
folks will know of it.

Or perhaps there's a different angle I should be looking at this from?

Any direction you can offer me will be greatly appreciated.

Thank you!
Kelly

Nov 12 '05 #4

P: n/a
you should consider how to consolidate your DATA . . and then create a fresh
report with all the relevent data printed.

cheers
paul g

"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:3f******@news.microsoft.com...
It cannot.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Kelly Sellers" <ke***********@hotmail.com> wrote in message
news:76**************************@posting.google.c om...
Short version: is it possible to set OutputTo so that it will append
to an existing RTF document instead of creating a new document each
time? (I'm using Access XP)
Full scenario: I generate 11 related reports every two weeks (bowling
league stats), from various and sundry recordsets. These reports must
be combined into a single document, which is then sent on its way as
an e-mail attachment.

I believe my only feasible route for automating the combining part is
to export each separate report, then automate the document merge on
the Word side, as I don't see an OutputTo argument that would
accommodate this. But I figure if such a thing exists, one of you
folks will know of it.

Or perhaps there's a different angle I should be looking at this from?

Any direction you can offer me will be greatly appreciated.

Thank you!
Kelly


Nov 12 '05 #5

P: n/a
Thank you for your replies! I think I know what I need to do next.

Kelly
Nov 12 '05 #6

P: n/a
"Kinetic - Paul G" <ki*****@alwaysonline.net.au> wrote in message news:<3f********@alwaysonline.net.au>...
you should consider how to consolidate your DATA . . and then create a fresh
report with all the relevent data printed.

cheers
paul g


Yes, that would be ideal... I guess I've assumed that I can't
consolidate the data due to the mix of statistics I run (individual &
team, male & female, by date and overall) and the various scenarios
that feed into those stats (absent, substitute, first-timer, etc).
Frankly, I've been grateful just to get the math to work! *giggle*

But maybe with some more serious noggin work I can figure out a way to
make all those recordsets work and play well together. :)

Thank you!
Kelly
Nov 12 '05 #7

P: n/a
How about one main (unbound) report with separate, unrelated subreports?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Kelly Sellers" <ke***********@hotmail.com> wrote in message
news:76**************************@posting.google.c om...
"Kinetic - Paul G" <ki*****@alwaysonline.net.au> wrote in message

news:<3f********@alwaysonline.net.au>...
you should consider how to consolidate your DATA . . and then create a fresh report with all the relevent data printed.

cheers
paul g


Yes, that would be ideal... I guess I've assumed that I can't
consolidate the data due to the mix of statistics I run (individual &
team, male & female, by date and overall) and the various scenarios
that feed into those stats (absent, substitute, first-timer, etc).
Frankly, I've been grateful just to get the math to work! *giggle*

But maybe with some more serious noggin work I can figure out a way to
make all those recordsets work and play well together. :)

Thank you!
Kelly

Nov 12 '05 #8

P: n/a
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:<3f******@news.microsoft.com>...
How about one main (unbound) report with separate, unrelated subreports?

Oooh, now there's an angle I hadn't considered. An unbound main form
never crossed my mind. Yet another lesson in how easily one's thought
processes can get trapped by habit...

I just did a "quick and dirty" test run and it looks like this will
give me exactly what I need. And what a delightfully straightforward
solution! Thank you so much!

Kelly
Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.