Generating an Access Report that's "editable".

[John S. Ford, MD]

Is there a way of generating an Access report as a text file or Word
document? In other words, that can be e-mailed and edited? I know that an
Access report can be printed as a pdf, but a pdf print file is not generally
editable.

John

--
-------------------------------------------------------
John S. Ford, MD, MPH
Assistant Professor of Medicine
David Geffen School of Medicine at UCLA
Harbor-UCLA Medical Center
(e-mail address removed)
http://califmedicineman.blogspot.com

 

[tina]

yes, if i recall correctly, you can Output a report object to a .rtf doc
(Rich Text File) which can be opened and edited in Word. .rtf docs generally
look okay, but spacing may be off, and some formatting controls, such as
lines, may not be "carried over".

hth

 

[Mr B]

The short answer to your question is, Yes. :>)

From within Access, using Automation, you could merge your data with a Word
template, save the document and then attach the document to an email.

Albert Kallal has a very helpful utility "MergeToWord" that will do the
merge. Follow this link:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
and scroll down the page to the "Super Ease Word Merge" for a download.

As for attaching the document to an email. Just search these newsgroups for
"Email" or "Attachments" and you should find plenty of help.

If you still have questions, just post back here and someone will be glad to
assist.

 

[Arvin Meyer [MVP]]

You can use OutputTo either from the menu: Tools >>> Office Links >>>
Publish with Word, or using VBA code, you can also use a merge, which is
generated from Word to get the data and put it in a Word.doc, or use
automation:

http://www.datastrat.com/Code/WordMerge.txt

 

[John S. Ford, MD]

Thanks all. You've given me much to think about!

John

 

[John S. Ford, MD]

Tina,

I don't see an "OutputTo" (or equivalent) parameter to the OpenReport
method. How would I do this?

John

 

[Douglas J. Steele]

Tina's talk about the OutputTo method, not a parameter for the OpenReport
method.

http://msdn2.microsoft.com/en-us/library/aa220433(office.11).aspx

 

[(PeteCresswell)]

Per John S. Ford, MD:

Is there a way of generating an Access report as a text file or Word
document? In other words, that can be e-mailed and edited? I know that an
Access report can be printed as a pdf, but a pdf print file is not generally
editable.

What's the rationale for being editable?

If it's just "because", that's on thing and any one of several
document types will do.

But if it's to enable the user to mark up the document and then
send it back to somebody for importing back into the system;
that's a different set of requirements - and my money would be on
generating an Excel spreadsheet.

 

[(PeteCresswell)]

Per (PeteCresswell):

... that's on thing ....

SB "that's one thing"

----------------------------------------
Eye halve a spelling chequer
It came with my pea sea
It plainly marques four my revue
Miss steaks eye kin knot sea.

Eye strike a key and type a word
And weight four it two say
Weather eye am wrong oar write
It shows me strait a weigh.

As soon as a mist ache is maid
It nose bee fore two long
And eye can put the error rite
Its rare lea ever wrong.

Eye have run this poem threw it
I am shore your pleased two no
Its letter perfect awl the weigh
My chequer tolled me sew.

 

[tina]

LOL <bg>

Per (PeteCresswell):

SB "that's one thing"

----------------------------------------
Eye halve a spelling chequer
It came with my pea sea
It plainly marques four my revue
Miss steaks eye kin knot sea.

Eye strike a key and type a word
And weight four it two say
Weather eye am wrong oar write
It shows me strait a weigh.

As soon as a mist ache is maid
It nose bee fore two long
And eye can put the error rite
Its rare lea ever wrong.

Eye have run this poem threw it
I am shore your pleased two no
Its letter perfect awl the weigh
My chequer tolled me sew.