Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Lines lost in report when saved as RTF (Access 2003)

    I am not hopeful of a resolution to this issue, but its worth a try.
    I email quite a few reports from my database to people each day. I prefer to send them by snapshot viewer, but the recipients wish to be able to manipulate the file when they receive it. They have valid reasons which I wont go into here.
    The problem is that the lines that are in the report in Access are not there when converted to a Word Doc. Is there anyway to get them back in Word?

    Kerry

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Lines lost in report when saved as RTF (Access

    You are right not to be hopeful.

    All graphics (including lines) are lost when you send Access reports to rtf.

    In Word you can use the Drawing toolbar to draw lines, or Format ... Borders and Shading to draw them back in again, but it is not going to be automatic.

    If it was really worth the effort, you could try to use Word automation to send the data to a Word document with lines in it, rather than exporting a report as pdf.
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Lines lost in report when saved as RTF (Access 2003)

    To make it automatic i would output the report as PDF. You could then use the Adobe version that allows editting pdf files.

  4. #4
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Lines lost in report when saved as RTF (Access

    Thanks for the response.

    Could you elaborate a little more on what you mean by Word automation? Do you mean some sort of mail merge to word?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lines lost in report when saved as RTF (Access

    John meant something different, but in fact, mail merge in Word with data from Access might be a good solution if you can create a query that returns the data you want.

    Automation means controlling one application from another one using VBA. In this case, manipulating Word from Access. It is more work than mail merge, but also more powerful, because you can control every aspect of the resulting Word document. See <!profile=WendellB>WendellB<!/profile>'s tutorial Automation 101 for an introduction to Automation, with useful links.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Lines lost in report when saved as RTF (Access

    Acrobat allows only very basic editing. It is not really 'manipulation' , which is I think what was intended.
    Regards
    John



  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Lines lost in report when saved as RTF (Access

    Thanks John, i must admit i didn't know the extent of editting allowed in Adobe.

  8. #8
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Lines lost in report when saved as RTF (Access

    Thanks for pointing me in a direction for more learning. I will plough through this and see what I come up with.

    Regards
    Kerry

Posting Permissions

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