Sending Access 97 report info to a Word document

[John S. Ford, MD]

I'm not sure which group to post this question to. I'm working in Access 97
and 2000 and have created a report which I'm happy with. What I'd like to
do is transfer the information in my report (different depending on the user
and the information they are requesting) to an MS Word document. I'm
assuming (perhaps wrongly) that there is a straightforward way of doing
this.

Any ideas?

John

 

[Douglas J. Steele]

Actually, there are some problems going from Access to Word, but Stephen
Lebans has overcome most of them. Take a look at
http://www.lebans.com/ReportUtilities.htm

 

[averageguy]

John,
You may want to install a PDF writer. PDF995 costs $9.95. You can print
your Access report to the PDF writer. It will save it as a pdf document.
You can then distribute it to anyone.

 

[John S. Ford, MD]

The problem with distributing my report as a pdf is that it won't be
editable by the end user in the same way as a Word document which is a
feature I will need.

John

 

[John S. Ford, MD]

Thanks Doug,

That looks like what I need.

John

 

[Stephen Lebans]

John it may not be exactly what the doctor ordered!<grin>

While the resulting RTF file is an exact image of the original report,
it is not fully editable as is a normal Word document. You can edit the
elements but you have to right click on the individual page and select
Edit. THis will take you intot he Editing window where the individual
elements are available.

Currently, there does not exist a method to export an Access report,
complete with formatting, graphics, etc., into a fully editable Word
document. I am working with another Access developer to see if we can
come up with a viable solution.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Charlie]

The problem with distributing my report as a pdf is that it won't be
editable by the end user in the same way as a Word document which is a
feature I will need.

John

A technique I used recently when trying to generate some distributable
data from a genealogy file from Access (Cemetery Census) was to print
the report to a PDF file, then use Omnipage to OCR the PDF file
(Omnipage and ABBYY Finereader both work directly on a PDF file.... no
need to actually print to paper), then save the OCR'd file as a Word
document. It's a PITA, but it does work with no OCR errors.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[Tom Wickerath]

John,

Try this sample posted on MSDN:

January 2002
Fill in Word Forms Using Information Stored in Access
by Sean Kavanagh
Applications: Microsoft Access 97/2000/2002, Microsoft Word 97/2000/2002

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima02/html/ima0102.asp?frame=true

You can download the samples from ElementKJournals here:
http://download.elementkjournals.com/ima/jan02/


Tom
_________________________________


The problem with distributing my report as a pdf is that it won't be
editable by the end user in the same way as a Word document which is a
feature I will need.

John