word as reporting tool for access

[joyw]

Hi,

I have a requirement to generate reports in word which will pull data from ms access 2007 database. i would need to know how can i acheive this and if it is possible.

any directions or sample code will be appreciated, also would need to know if there are any third party tools that can do this ?

Thanks for the help
Joy

 

[JoeAtWork]

You can use OLE Automation to start an instance of Word and manipulate it's loaded document. I don't have any code handy, but the first step is to reference the Word library.

 

[fneily]

You should be more specific in what you want to accomplish. Maybe you just need to do a mail merge. We can't tell. Here's some readings you might find helpful:
How do I... Dynamically fill Microsoft Word fields using Access data?

http://downloads.techrepublic.com.com/abstract.aspx?&q=word&docid=309687

How do I... fill Word form fields with Access data?

http://downloads.techrepublic.com.com/abstract.aspx?&q=word&docid=301764

How do I... Fill a Word table with Access data?

http://downloads.techrepublic.com.com/abstract.aspx?&q=word&docid=349761

 

[fneily]

Forgot to ask - Why do you have to have your reports in Word? Since you'll be using data stored in Access, just create the reports in Access. You can always export to Word like this:
DoCmd.OutputTo acreport, "report name", "RichTextFormat(*.rtf)", "report path", False,

 

[nim180]

Fneily is correct create a report with all you required fields then just export it into word using the format given by fneily