Results 1 to 14 of 14
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fax Report (A2k)

    Has any-one any knowledge on Faxing a report from Access, Is this possible ?

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

    Re: Fax Report (A2k)

    Dave,

    I have no experience with this myself, but perhaps HOW TO: Fax from Microsoft Access Using SendObject Command in Access 2000 helps.

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    Thanks Hans
    I'll have to study the article.
    It incorporates "Outlook" and a fax modem.
    We are using routers and ADSL and I dont have a dialup configoration, so this may prove difficult.

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

    Re: Fax Report (A2k)

    Do you want to send the report to somebody on ADSL? In that case, you don't need to fax, you can e-mail it.

    Do you want to send the report to somebody with a fax machine? In that case, it'll have to be sent through a standard phone line at some point. There are combined printers/fax machines that can do that, or dedicated fax servers such as ZetaFax from Equisys (but that is expensive).

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    Thanks for the additional info Hans.

    My thoughts were for the database to be able to "Fax" parts orders to designated suppliers.

    Although E:Mail, would be far easier to implement, many suppliers don't check there Mail as often as the fax machine.

    Most suppliers don't even know how to use E:Mail.

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

    Re: Fax Report (A2k)

    Well, a fax machine is connected to an ordinary phone line, so if you want to fax, you'll have to send the fax through a phone line. So your options are those I mentioned in my previous reply, plus of course a fax modem in your PC. The ADSL and routers don't come into this.

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

    Re: Fax Report (A2k)

    I've automated faxes from Access using WinFax and Word in the past, although I haven't done it directly from Access. The key to remember is that you must be able to dial a telephone number to reach the receiving fax machine. If you don't have that capability, then you can't send a direct fax. There are some internet fax services that allow you to fax indirectly by uploading the document to the service and having them send the fax, but there is a fee for that kind of service.
    Charlotte

  8. #8
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    Thanks all for the advise.

    Have a good weekend

  9. #9
    Star Lounger
    Join Date
    Mar 2002
    Location
    Decatur, AL
    Posts
    53
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    I had this same dilemna some time ago. Although I thought the Auto Dialer would work, I had no success with it. Instead I duplicated the report that I wanted to FAX as a separate report with the Page Setup set to use a my FAX as a Specific Printer. On the form I used a Print Command Button and it automatically launched the default FAX program and I selected the FAX number from that application's address book.

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    There were three articles recently in Woodys Access Watch about faxing directly from Access using Winfax.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  11. #11
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    Thanks.
    I'll check it out.

  12. #12
    New Lounger
    Join Date
    Jul 2001
    Location
    Scottsdale, Arizona, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    You could also check to see whether a service such as eFax might help. It allows you to send/receive faxes via email.

    - eric

  13. #13
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    HI Dave

    Did you ever get a sloution to your fax from access question?

    "Has any-one any knowledge on Faxing a report from Access, Is this possible" ?

    I have WinFax on my computer, when I print a report in Access, I select File, Print then WinFax as the printer.

    I would be interested in the approach you came uo with.

    John

  14. #14
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fax Report (A2k)

    John
    I never got around to finishing this, mainly because I use ADSL and don't have a modem for dial up connection.
    It is part of an on-going list which at a later date, I shall try to address.

    Any way, if you do come up with a solution, I would be very greatful if you added it to this post.

    Good Luck

Posting Permissions

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