How to save/export my formatted report from Access-DB to Word-File?

[Baloo]

hi, all!

It's a simple question. I'm sorry, but I couldn'd find an answer in this forum

I have formatted several nice reports.
Could you be so kind to help me in VBA to save/export for example my Report1 from DB1.mdb to Report.DOC (I need to save format of pages too: fonts, colors, footers, etc...).

Code/example would be very much appreciated

thanks in advance!
kind regards.
Baloo.

[ganeshmoorthy]

if it is in crystal the option is already there...just check the export options...otherwise include word object into your project and create a word file but this is a tedious work...

[Estuardo]

G'd morning!!!
To export your report to ms word, you can do it in two (i guess) ways, depending on the report layout itself.
The easy one, is to add a button in your form and let the wizard to write the code to export the report to word.
The hard one is to automate ms word. To do that you will need create a .dot
document, make all the design by hand and place bookmarks for every data field.
The first one is ok if your report is doesn't need parameters and with very basic layout.
In the second, you have full control. You can have the word report just as you have it in access.
I may dare to add another "option". If the report just for reading you can send your
Access report to any pdf printer, you can find a lot of them for free.

Good luck
Estuardo

[RobDog888]

See my code examples in thi shtread.
http://www.vbforums.com/showthread.php?t=395689