Creating a report in Word format programatically.

[BrazilTechie]

Is there any way I can create a report using Access straight to a Word format? What I have done is create the report using the "DoCmd.OpenReport" command and then converting it to a Word Format.
Please help!

 

[danvlas]

Use Automation.
Basically, from Access:

Set myWrdApp=CreateObject("Word.Application&quot
'here you have full control over Word
'check the VBA for Word terminology, objects and methods

Set rst = CurrentDb.OpenRecordset("UnderlyingTableOrQuery&quot
'do whatever you need to do with data in the recordset

Set myWrdApp = Nothing

If you encounter errors, set a reference to Microsoft Word Object library.

It's much more work to do...but you can create the document exactly as you want it.

Good luck,

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[BrazilTechie]

Thanks for the hint.