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

Exporting Report To MS Word

P: n/a
I'm having trouble with exporting reports to Word in the rtf format and
I'm hoping someone has a solution. The reports are losing their
formats. Not all the formating is lost but some is and of course it's
the really important parts that are lost. In one report the grouping is
lost and everything gets repeated.
I've created several reports that pull data from various tables then
they get exported to Word when they're run so the user can modify them
if needed. The users need to add some objective data that is not
collected. Is there any way to not lose this either by exporting in a
different format (tried html and had the same results) or going about
this in an entirely different route?

Thanks

mike

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
You need to build a Word template with all the formatting you want and
bookmarks where you want data. Then you need to export the Access data to
the bookmarks via VBA. The pther alternative is to create PDF documents.

BTW, I am 90 miles north of you in Clarion! My niece and her husband work at
Pitt; Kris and Matt Schonder. Do you know them?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<mi***@pitt.edu> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
I'm having trouble with exporting reports to Word in the rtf format and
I'm hoping someone has a solution. The reports are losing their
formats. Not all the formating is lost but some is and of course it's
the really important parts that are lost. In one report the grouping is
lost and everything gets repeated.
I've created several reports that pull data from various tables then
they get exported to Word when they're run so the user can modify them
if needed. The users need to add some objective data that is not
collected. Is there any way to not lose this either by exporting in a
different format (tried html and had the same results) or going about
this in an entirely different route?

Thanks

mike

Nov 13 '05 #2

P: n/a
I actually grew up just south of Clarion. A Karns City native. I should
know Kris since we work in the same department (Pharmacy and
Therapeutics) but in different buidlings. I can't put a face to the
name though. Small world. If I see them I'll have to let them know that
you helped me on google.

Thanks for the tip. I've never tried the template method before so I'll
probably be posting follow-up questions.

thanks again

mike

Nov 13 '05 #3

P: n/a
If there are a lot of fields to export or more than a few duplicates of
the same field in the template, I suggest the DocVariable method
instead -- it's faster.

Nov 13 '05 #4

P: n/a
Mike,

Yes, it is a small world! And Yes, if you see Kris or Matt (He's the head of
Pharmacy at UPMC at Braddock I think) tell them I said Hello. Re: using a
Word template, start by looking up in Word how to create and use a template
and bookmarks. Next, look up (in Access) how to run Word from Access using
automation. You will be then ready to tackle using the template method. I am
in business to provide customers with a resource for help with Access, Excel
and Word. Email me at my email address below if you would like my help.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

<mi***@pitt.edu> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I actually grew up just south of Clarion. A Karns City native. I should
know Kris since we work in the same department (Pharmacy and
Therapeutics) but in different buidlings. I can't put a face to the
name though. Small world. If I see them I'll have to let them know that
you helped me on google.

Thanks for the tip. I've never tried the template method before so I'll
probably be posting follow-up questions.

thanks again

mike

Nov 13 '05 #5

P: n/a
Nichole and Steve.

Thank you both for the input. I have another programmer here looking
into both these methods and we should have this hammered out by this
afternoon. If we can't figure out how to do this we may be getting in
touch with you.

Thanks again

mike

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.