how to produce reports in DOC file? 1

[diepblauw]

Our users would like to have the reports produced by our MS Access application in DOC format . Are there any methods to produce reports in DOC directly?

 

[GingerR]

one way is to put the PrintPreview toolbar for your users, so when they are looking at the report, they can click the toolbar and it will save to word (actually RTF rich text format which is the best you'll get in that type of doc).
another way is for you to put a button on a form, and instead of it opening the report in access, it exports it to word:

    DoCmd.OutputTo acReport, "ReportName", acFormatRTF

this will come up asking the user where they want to store it.

better yet is the format Snapshot. it makes the report exactly how it is in access (formatting and everything) also this is the only format you can use to export charts. Snapshot viewer is freely available from microsoft and easy to install. every computer in my company has it.

hope this helps..g

 

[diepblauw]

Thanks for your answer. But I hope the extension of the produced file is "doc", not "rtf". are there any methods to do so?

 

[GingerR]

part of the OutputTo command is what file name/where do you want it.

you can put

DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, "C:\NewReport.doc", True

it will output the access report "ReportName" and put it on the C:\ drive and call it NewReport.Doc. the "TRUE" (you can make it False if you want) means that right after saving, it will automatically launch MS Word (or whatever app is tied to the type of file you just exported).