Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy report (XP)

    How do you copy an Access report exactly as it looks in Access. When I try to export it to word, I lose all the extra lines I added to my table. If I export it to excel, it spreads out all over the worksheet. The only thing that copies it exactly is snapshot viewer but the person I am sending it to can't open it then. I don't want to send the whole database, just this one report.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy report (XP)

    Laura,

    Exporting it to WORD doesn't keep graphics. you would think the MS products would be compatable that way. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> I now send mine to a PDF file and then mail that.

    Don
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

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

    Re: copy report (XP)

    The person you want to send the report to can download the snapshot viewer from Microsoft Office Developer Forum or <!mskb=175274>Microsoft Knowledge Base Article 175274<!/mskb>.

    A PDF file as suggested by Don is probably the only other solution that will preserve the formatting of the report.

  4. #4
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy report (XP)

    I went on and reformatted it in word with my graphics. I don't want to tell a client to download snapshot viewer so I'm intrigued by the .pdf option. Call me stupid <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> but how do you send it to a pdf file?

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

    Re: copy report (XP)

    PDF = portable document format, developed by Adobe, is a file format that contains a platform-independent version of a file looking the way it does when printed. To view PDF files, you also need software: the free Adobe Reader. Many people have this reader, since a lot of software comes with documentation in PDF format nowadays.

    To create PDF files, you need other software. The "official" Acrobat series of software from Adobe is good but pricy. There are cheaper, even free alternatives, see for example <post#=314690>post 314690</post#>. A search for free pdf in the Software Finds and Wants forum will turn up other possibilities.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: copy report (XP)

    I don't know how frequently you do this, but if you do it on a regular basis, you might also consider creating the report in Word using Automation from Access, or by doing a mail merge in Word using Access as your data source. Either can involve quite a bit of effort, but if you really want a Word document, there are some alternatives.
    Wendell

Posting Permissions

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