p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Convert Ms Access report to MS Word doc (http://p2p.wrox.com/showthread.php?t=63007)

kite October 18th, 2007 05:44 AM

Convert Ms Access report to MS Word doc
Can anybody help me. I need to conver Ms Access report to Ms Word format

Thanks in advance.

darrenb October 22nd, 2007 01:45 AM

Hi Kite

There is a few options you have here, 1) if the report is is preview mode on your screen then you can simply go to Tools - Office Links - Publish it with MS Word or 2) if you wish to program this to a command button or simular then use something along the lines of
    Dim stDocName As String
    stDocName = "Report name goes here"
    DoCmd.OutputTo acReport, stDocName

This code will give you the coice of output methods, ie word, excel etc etc
If you like you can further customise this code to specify file name / path etc

Hope this helps

All times are GMT -4. The time now is 07:14 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.