Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Publishing Reports to Word/Publisher etc (Access 97)

    Anyone know why when I try to Publish an Access report to Word, i lose certain objects off the report? Check boxes, OLE objects (ie Photos and bitmaps), Lines and Boxes all disappear when I click "Publish it with Word"...... Is there a way round this or is there some way of getting Access reports into a Publishing-type of software whilst retaining things like Check Boxes? Most of the other formatting and layout are fine in the output created by Word, but where these objects (eg Check boxes, photos etc) were is simply blank space.

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

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    When you publish to Word, you are actually creating an rtf file, which drops all graphic elements of the report. You can create a snapshot, which is a graphic format but is not editable and is only readable with the snapshot viewer as far as I know, or you can use something like Acrobat to generate a PDF file. Perhaps if you explain further about what you're trying to accomplish someone can come up with additional suggestions.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Aug 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    I'm not really familiar with this "snapshot" viewer stuff- what's the deal with that? Is it similar to Acrobat?

    Being able to edit the report after it's been exported from Access is important for me, so it probably isn't ideal. The main issue is loss of graphic elements- I want an exported report in some word processing or publishing format that maintains things like photos and check boxes but also has editable text. I have a feeling that no export formats are suitable for this and no word processing/publishing software packages can do it either.......

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

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    Since the whole point of a report is that it is a snapshot of data, making it editable seems like a contradiction to me. I don't know of any way to do what you're trying to do.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    The snapshot viewer is an app that accompanies Access. If you scroll the options for export format all the way to the very bottom, there it is.

    But as Charlotte says, the file is manifestly uneditable.

    Rather than export a report, how about exporting the data, or using Word as an Automation object? (not that I have ever done that, but several texts make it look fairly easy)

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Duesseldorf, Germany
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    I have the same problem with the graphical elements, but I don't need to change the data (cheers to Chalotte <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>). What we would need is an export in .doc format. That office Automation stuff needs to much effort for chreating a now-and-then report for people that don't own Access.
    I tried export in HTML, but sometimes the colums are i

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

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    We actually have a case where it turns out to make sense. We create a 150+ page report with lots of narrative text in Access, but the people who use it need to be able to search for various text strings in the report. Local people have a facility so they can filter records in the database and get to what they need pretty quickly. In addition, it gets mailed out to hundreds of people who presumably don't have Access, or even Word. So we create an RTF document in Word (originally by mail merge, now by Automation) which can be used with any functional Word Processor - if you are using notepad or equivalet it dies however. Much too large.
    Wendell

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

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    But you aren't trying to exort graphics into the document.
    Charlotte

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

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    In this specific case that is true - the report doesn't contain any graphics. However, with the automation approach we can insert any graphics elements we want into the Word document and it works like a champ. One of the things that you can do only with great pain and effort is to simulate a subreport - and List Boxes and Option Groups are darn near impossible. The bottom line is that it's really hard to make a hammer that saws or vice versa.
    Wendell

  10. #10
    New Lounger
    Join Date
    Aug 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Publishing Reports to Word/Publisher etc (Access 97)

    Thanks everyone for your comments and suggestions. The main thing that I need in exported reports are graphical elements such as check boxes, lines, OLE objects etc. Edit-ability of the exported report is not so important. I agree that having the capability to export in .doc format would be great, as that would theoretically allow graphical elements to be retained. One day maybe......!

Posting Permissions

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