fax report

[Mike]

Good Morning all,

I have a report that has a field, [FaxNum] and I am trying to fax the report
using Microsoft Fax as my printer. Anyone know how it will get the Fax
Number from the field automatically? I don't want my users to have to
reenter it.

Thanks
Mike

 

[Rick B]

I'd suggest you read the previous posts on the topic. The easiest way I
have found is to go to
www.google.com, click the "groups" option, and enter a search string
starting with...

microsoft.public.access


I used the search microsoft.public.access "microsoft fax"

The following link seems to be the most detailed on the topic. It sites a
Microsoft KB article that shows step-by-step process to do this using the
Northwind database. Hope this helps! Post the following link (with no
spaces) into explorer...



http://groups-beta.google.com/group...microsoft+fax"&rnum=17&hl=en#9625f48a4bf35deb

 

[Mike]

Thanks. I tried to search for fax in this newsgroup but found nothing.
I'll look that up.

Mike

I'd suggest you read the previous posts on the topic. The easiest way I
have found is to go to
www.google.com, click the "groups" option, and enter a search string
starting with...

microsoft.public.access


I used the search microsoft.public.access "microsoft fax"

The following link seems to be the most detailed on the topic. It sites a
Microsoft KB article that shows step-by-step process to do this using the
Northwind database. Hope this helps! Post the following link (with no
spaces) into explorer...



http://groups-beta.google.com/group...microsoft+fax"&rnum=17&hl=en#9625f48a4bf35deb

--
Rick B

Good Morning all,

I have a report that has a field, [FaxNum] and I am trying to fax the report
using Microsoft Fax as my printer. Anyone know how it will get the Fax
Number from the field automatically? I don't want my users to have to
reenter it.

Thanks
Mike

 

[SA]

Mike:

The microsoft fax printer is also "automateable", meaning that you can use
VBA code to run the whole thing. Below is an example:
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

-----------------begin code------------------
Dim objFaxServer As Object
Dim objFax As Object
Dim dwReturn&

DoCmd.OutputTo acOutputReport, "ReportName", "Snapshot Format (*.snp)",
"c:\YourDir\ReportName.snp", False
DoEvents
Set objFaxServer = CreateObject("FaxServer.FaxServer")
dwReturn = objFaxServer.Connect(vbNullString) 'connect to the local server,
can also connect to a server on another machine
'objFaxServer.PauseServerQue True 'Fails in WinXp, Works in Win2K to pause
the fax que
Set objFax = objFaxServer.CreateDocument("c:\YourDir\ReportName.snp")
With objFax
.FaxNumber = "800-555-1212"
End With

lngJobID = objFax.Send
objFaxServer.Disconnect
Set objFaxServer = Nothing
Kill "c:\YourDir\ReportName.snp"
------------------end code--------------------------------

Thanks. I tried to search for fax in this newsgroup but found nothing.
I'll look that up.

Mike

I'd suggest you read the previous posts on the topic. The easiest way I
have found is to go to
www.google.com, click the "groups" option, and enter a search string
starting with...

microsoft.public.access


I used the search microsoft.public.access "microsoft fax"

The following link seems to be the most detailed on the topic. It sites
a
Microsoft KB article that shows step-by-step process to do this using the
Northwind database. Hope this helps! Post the following link (with no
spaces) into explorer...



http://groups-beta.google.com/group...microsoft+fax"&rnum=17&hl=en#9625f48a4bf35deb

--
Rick B

Good Morning all,

I have a report that has a field, [FaxNum] and I am trying to fax the report
using Microsoft Fax as my printer. Anyone know how it will get the Fax
Number from the field automatically? I don't want my users to have to
reenter it.

Thanks
Mike