Access 2007 using Microsoft Fax - as printer

Question

After a thorough review of this thread (http://support.microsoft.com/kb/231797), I am still unable to fax directly from Access.

I have a small Access applications installed at numerous remote sites (gas stations).  The sites do NOT have internet connectivity.  Monday through Saturday they use a simple fax modem to transmit sales data to our centralized server/office.  However, on Sunday, I need them to send information to another facility (gas hauler dispatch yard: "Yard").  The yard doesn't have the ability to receive the Mon-Sat data.  The yard DOES have a fax machine.  The idea here is that on Sunday morning, the manager simply press a button in the Access application at the station to fax to the yard.

1)  Laptop Operating System is Windows 7 Professional
2)  Windows Fax & Scan is installed and working.  To verify this, from Access, if I acPreview the report, the CTRL-P to open the printer dialog and print to the 'FAX' device, the subsequent dialogs walk me through faxing - which can be completed manually.
3)  The report "rpt Sunday GB Report" has the 'Specific Printer' set to Fax.

Images included just so you can 'see' my screen and perhaps diagnose what's wrong.

Printers:

Report:

Tries to email:

Can Fax Manually:

Code:

Every attempt to 'force' it to fax has failed.  I suppose I could train 50+ gas station attendants to put in the phone number, but that seems absurd.

I assume there's something very basic and massive that I've missed.

Isn't there a way to simply have them press a button, and it will fax the report with a single button push?

Darryl May
http:\\mcfiveohone.tumblr.com
[e-mail]
[phone] cell/text

Answer 1

Hi Darryl,

You may try using the Outlook Object for sending out your Fax.

See below thread on how to accomplish this (VBA code):

http://www.vbusers.com/code/codeget.asp?ThreadID=436&PostID=1&NumReplies=0

Hope this helps,

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

Answer 2

Hummm, this could be totally irrelevant, but I'll try anyway.  The only time I've seen that message is when I was trying to automate Access to send emails via Outlook.  There is a nice little 3rd party app called 'click yes' that disables those annoying messages.  You could try that.

http://www.contextmagic.com/express-clickyes/

http://www.contextmagic.com/express-clickyes/free-version.htm

It's free and super-easy to setup.  May as well try it.

---

Ryan Shuell

Answer 3

It seems that the fax is going through Outlook.

Look into http://www.everythingaccess.com/vbMAPI.htm

I've been using it for about a year and a half for emails and it works great.

Everything gets included in your application. Nothing else to install on client's machines. And support is supurb. It is well worth the price.

You can contact Wayne via the website with your problem and he can propably tell you if it would work.