Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2004
    Posts
    35

    Question Unanswered: Exporting Access 97 Reports

    Yes, I know, I know ... Acesss 97 Egghh ... but the client is not willing to upgrade, so I'm forced to try to find a solution.

    So ... I have a report that when exported into Word, loses some of it's formatting. The formatting that is lost is in a very detailed header section.

    I was wondering if there is a possible 3rd party solution that could allow me to export this report and keep all of it's formatting as shown in the original Access report.

    I have provided 2 attachements of examples of what the Access reports views as and the second, what the report looks like after exporting into Word.

    Any suggestions are welcome.

    Kind Regards,
    QT
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    why not just right the report in the report side of the database

    Build the header in one report and the body in an other report

    then link as one report.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Dec 2004
    Posts
    35
    Please see attachments ...

    QT

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Nope. Exports into Word do lose graphic elements and some fonts go war-wacky ... How about changing over to PDF? You could use something like CutePDF to capture the report ... Works very well.
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Dec 2004
    Posts
    35
    CutePDF ... ok, I will look into that.

    So if I run the report in Access, somehow I could export that to a PDF ??

    Cheers!
    QT

  6. #6
    Join Date
    Dec 2004
    Posts
    35
    SOLVED!

    M OWEN .. THANK YOU SOOOO MUCH for that suggestion!

    Worked WONDERS ! This will make our process soooo much easier to get quotes to customers!

    Many Thanks!
    QT = D

    Quote Originally Posted by M Owen
    Nope. Exports into Word do lose graphic elements and some fonts go war-wacky ... How about changing over to PDF? You could use something like CutePDF to capture the report ... Works very well.

  7. #7
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by QTNM
    SOLVED!

    M OWEN .. THANK YOU SOOOO MUCH for that suggestion!

    Worked WONDERS ! This will make our process soooo much easier to get quotes to customers!

    Many Thanks!
    QT = D
    You're welcome.

    I reccommend it cause I had to come up with something free to do the exact same thing and it works. Best of all: No Nag screens ...
    Back to Access ... ADO is not the way to go for speed ...

  8. #8
    Join Date
    Dec 2004
    Posts
    35
    I cannot thank you enough !!!

    I was doing research for about 1 1/2 hours ... came across a whole slew of other great threads, but nothing on this! You saved me a huge headache!

    Cheers!
    QT = )

  9. #9
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by QTNM
    I cannot thank you enough !!!

    I was doing research for about 1 1/2 hours ... came across a whole slew of other great threads, but nothing on this! You saved me a huge headache!

    Cheers!
    QT = )
    ... And I bet you NEVER thought about this: Say you were able to sent your customers a word doc with the quote ... There is NOTHING to prevent them from changing the terms and signing it. You could make it readonly and make them print and sign ... But then, they could just select the text in the doc and paste it into a new doc and do the same thing ... PDF, can't happen.
    Back to Access ... ADO is not the way to go for speed ...

  10. #10
    Join Date
    Dec 2004
    Posts
    35

    Exactly ...

    Yes, I did think of that. However they do have a good system in place to make sure that what was quoted is being charged. The estimates never change, so we would just have to rerun it to prove it. Luckily this client has never had that type of issue before, but its true ... it was the perfect solution.

    Cheers!
    QT + )

Posting Permissions

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