Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Faxing (2003 SP3)

    I am trying to fax from Reports and Forms. I used to use WinFax, which did work OK when faxing from Reports & Forms, but it continually stuffed up my computer, so now it's gone.
    Now I am using Microsoft Fax. It receives and sends faxes OK, except via Outlook using SendObject.
    Using DoCmd.SendObject acSendReport, txtRptName, acFormatRTF, "[Fax: " & txtFaxNum & "]", , , , , False , first converts the Form/Report to a Word .rtf doc and therein lies the disaster. The conversion totally stuffs up the document. If I simply print the Report / Form to the Fax printer driver, the result is great. So it is the conversion to a Word doc that is messing it up.
    Is there any way of getting around this?
    Regards,
    Peter

  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: Faxing (2003 SP3)

    I have no experience of Faxing reports from within Access, but it is acFormatRTF that tells it to convert to Word rtf. Have you tried using acFormatSNP which is Snapshot format. Snapshots preserve the appearance of the original.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faxing (2003 SP3)

    Thanks for that John.
    Works a treat with reports, they fax as they should. However the SNP format doesn't appear to work with Forms.
    Is your team in the finals. Mine (Melbourne) sure isn't.
    Regards,
    Peter

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

    Re: Faxing (2003 SP3)

    Yes Snapshot only works with Reports.

    The problem is that Forms are not really intended for printing or sending. So I think you need to make a Report version of any Form you want to send, and fax the Report instead of the Form.

    I am not a great follower of the footy, but the season is over for me too.

    John
    Regards
    John



  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faxing (2003 SP3)

    Bummer!
    Would be really handy if MS put the ability for reports to contain buttons! But I guess they have never really been accused of being handy.
    Thanks anyway.
    Regards,
    Peter

  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: Faxing (2003 SP3)

    You can Save a form as a Report, and the result would look the same as form.
    Of course there are plenty of complications that could arise, if the situation is not simple.
    Regards
    John



  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faxing (2003 SP3)

    Getting a bit too complicated. I think I will look at third party software.
    thanks anyway.
    Regards,
    Peter

Posting Permissions

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