Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access report to MS Word (Access 2000)

    I have a data base made with Microsoft Access for my small business. I use
    >this for preparing the invoices. I do them with a report. I would like to
    >know how can I send this report to Microsoft Word with the capability of
    >making any modifications on it. When I try this I can send all the data in
    >the Invoice but not the structure of the document (lines, boxes, etc.)

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access report to MS Word (Access 2000)

    It is not clear to me what needs to be modified, however, it is my experience that much of the formatting will not transfer from an Access report to Word. Instead, have you considered doing a mail merge from Access to a Word document? Then you can pass the Access data to the the document which can be formatted in Word precisely the way you require.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access report to MS Word (Access 2000)

    I concur with Thomas's suggestion. Graphics do not transfer when publishing a report to Word/rtf format. If the graphics are important, your choices are pretty much limited to a mail merge approach or writing the report to a PDF file instead of an rtf.

    I'm not sure what you mean about making changes on it. The whole point of a report is that you *can't* make changes. Yes, it's possible to change an rtf, but don't try it on a mail merge document prior to actually producing the merged document or you may change the data in your database as well.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •