Results 1 to 13 of 13
  1. #1
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Unanswered: 2000 Report to Word question ...

    Ok ... I need some help here (hopefully) ...

    I have some reports that I generate in Print Preview mode that I'd like (love) to be able to export (thru code it looks like at this time) to a Word document. Any thoughts of how I can do this?

    SendObject won't work. There is no .Doc type to export as ...


    ... And I'm not picky about how either ...

    - Mike

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    UK
    Posts
    246
    Mike,
    Seems wrong for noob to tell a guru how to do things, but can't you use the "Publish with Word" command button or adapt it?

    Regards
    John

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by Sticker
    Mike,
    Seems wrong for noob to tell a guru how to do things, but can't you use the "Publish with Word" command button or adapt it?

    Regards
    John
    In Access 2000? Where do you find it?

  4. #4
    Join Date
    Feb 2004
    Location
    UK
    Posts
    246
    Sorry Mike I'm using XP and I did a quick search to see what was in XP that wasn't in 2000 and the "publish with" wasn't mentioned. Therefore I assumed that it was in 2000. Sorry

    Regards
    John

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Ok ... If you have the Print Preview up and goto Tools->Office Links->Publish it with MS Word

    You'll get a .RTF file that pops up in Word ... Problem: I need a .Doc AND the report in question (actually a couple of them) has lines in it that get stripped out using the RTF format ...

    So John, nice try but it's a no-go ...

    The snapshot Viewer works but, I'm looking for something a bit more portable (i.e. send to clients) ...

  6. #6
    Join Date
    Feb 2004
    Location
    UK
    Posts
    246
    I know my place, I'll go back to asking the questions not answering them

  7. #7
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    All righty ... Well I did a search on this topic and lo there are a bunch of frustrated people out there with the exact same issue ... Looks like it'll be this way until MS gets off their collective hinies and makes something that'll work ...

  8. #8
    Join Date
    Nov 2003
    Posts
    267
    Since it doesn't need to be editable (reference to SnapShot) why not download a free PDF writer (like CutePDF Writer) and create a PDF of your report and email the pdf?

    There many even be other PDF writers that you could intergrate into the Application (I haven't looked)

    S-

    Update CutePDF Writer has a purchaseable version the you can distribute it ROYALTY FREE. It costs about $499 for programmatic access. Maybe to much $ if not used alot.


    S-
    Last edited by sbaxter; 03-25-04 at 14:54.

  9. #9
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by sbaxter
    Since it doesn't need to be editable (reference to SnapShot) why not download a free PDF writer (like CutePDF Writer) and create a PDF of your report and email the pdf?

    There many even be other PDF writers that you could intergrate into the Application (I haven't looked)

    S-

    Update CutePDF Writer has a purchaseable version the you can distribute it ROYALTY FREE. It costs about $499 for programmatic access. Maybe to much $ if not used alot.


    S-
    AWESOME!!!! ABSOLUTELY AWESOME! Perfect solution all the way around ... CutePDF creates a print spooler that pops up a redirect dialog to name the pdf file ...

    3 thumbs up ...

  10. #10
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    So...

    How did you get it to export to CutePDF or as a PDF file?

    I'd like to give this a shot myself.

  11. #11
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    actually Owen, i posted a tutorial on how to export to PDF without buying extra software through code;

    if you want to look at that, give a shout;

    that would only work if you had the Adobe Acrobat Suite

  12. #12
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81
    Got CutePDF to work and it's awesome.

    And Jerrie, I personally wouldn't mind seeing your tutorial.

    The Cutepdf program works pretty well and is easy to use.

  13. #13
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    here's the link:
    http://www.dbforums.com/showthread.php?threadid=988939

    follow the instructions;
    the file that i put there for download is a *.rar file and needs
    win rar.


    enjoy!

Posting Permissions

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