Results 1 to 8 of 8
  1. #1
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105

    is there a way to export a report to a MS Word document?

    Maybe a silly a question, but I want to know if there's an easy way to export my report to Word in an almost identical copy.



    I know how to open word and such, but is there a command that will basically paste my report into a word document?

    thanks

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    export as .rtf then rename to .doc

  3. #3
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105
    thanks, but how do i do it in vba code attached to a button click event?

    i want to just click a button and the report gets opened up in word, or saved in word...either or

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    DoCmd.OutputTo acReport, reportName, acFormatRTF, outputfile

  5. #5
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105
    thanks!

    that works for the most part. But I have a form that is sort of a questionairre. I created lines for people to write on when the form is printed. Everything exported to word except the lines.

    also, is there a way for the user to select where the file is saved when the button is clicked and to possibly name it as well? Maybe that's asking to much. I didn't have any trouble finding the file as it was saved in my documents, but if its not too difficult it would be cool to be able to save to a specific location.

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you may do it as using a browse button to get the path and file name, store them in 2 varibales,then use this 2 variables in the outputTo parameters.

    I didn't test but I think it would work.

  7. #7
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    ---Disregard, didnt see new posts-------

  8. #8
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105
    thanks man! my online help isn't working right now for some reason...normally i would just press F1 on the command i'm not sure about.

    The format is perfect for all of the detail stuff, but the report header doesn't get exported. Also, the report format doesn't get transferred either. For instance, on my report I have labels that are all blue with an off white text. When the report gets transferred to Word, I can barely see my labels anymore. Can i use VBA to set the font color of all items to black before exporting?

    lol...i appreciate your help thus far regardless...sorry to be a pain

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-16-2010, 10:12 AM
  2. Export single records to new Word Document
    By karmaimages in forum Import/Export Data
    Replies: 0
    Last Post: 11-19-2009, 03:37 PM
  3. Replies: 0
    Last Post: 01-18-2009, 09:18 PM
  4. Word document INTO Access form
    By jonathonhicks in forum Forms
    Replies: 0
    Last Post: 04-30-2007, 05:59 PM
  5. Replies: 1
    Last Post: 12-21-2005, 12:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums