View Single Post
Old October 22nd, 2007, 01:45 AM
darrenb darrenb is offline
Authorized User
Join Date: Mar 2007
Location: Sydney, NSW, Australia.
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