Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 18th, 2007, 05:44 AM
Registered User
Join Date: Oct 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Old October 22nd, 2007, 01:45 AM
Authorized User
Join Date: Mar 2007
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access ----> MS Word anukagni Access 1 August 30th, 2006 02:15 AM
how do i convert ms word doc to access tables??? carswelljr Javascript How-To 1 August 28th, 2006 03:44 AM
How to open .DOC in MS-Word file thru a link ? sherbir Javascript 10 March 8th, 2006 06:20 AM
Need to Preview a MS Word Doc GAF General .NET 2 November 11th, 2005 03:13 PM
How to open a .DOC file with MS-Word ? sherbir Servlets 0 July 26th, 2004 02:39 AM

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