Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you fax a report with RightFAX

Status
Not open for further replies.

jeep2001

Programmer
Dec 15, 2005
134
US
My company has RightFAX installed. I am trying to get a report to fax out via clicking a button...how would it be done?

Thanks
 
I'm not familiar with RightFax... but presumably it appears as a print queue? If so, you just need to change your printer to the fax queue, print the report and then reset your printer back to default. In VBA, something like this completely untested code maybe?:
Code:
'Capture current default printer
Dim prt As Printer
Set prt = Application.Printer
'Set printer queue to fax
Set Application.Printer = FaxQueueHere
'Open and print report
DoCmd.OpenReport "ReportNameHere"
DoCmd.PrintOut
'Restore original print queue
Set Application.Printer = prt
The more I look at this the more it doesn't seem right, but the sequence of events is on the right lines, even if the syntax isn't. Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top