Printing to a Fax Printer

[Guest]

I am trying to print to a fax printer. I open the report with acNormal and
everything runs fine, until the fax program needs the fax number. I have the
fax number in a table and I have attempted to use "Sendkeys" and even the
Wscript Sendkeys, but it does not work.

The printer in a Brother 7820N - Multifuncttion printer that will send faxes
from the PC.

As far as I can tell, once the Print function starts, the VB module is
suspended and there is no way to Sendkeys or anything else.

I also checked, and there is no DDE, OLE, SDK, etc. for the printer that I
could find.

Any ideas? Thank yoU!!

 

[Guest]

Here is way to try. Write a spearate vb script program that is launched from
Access VB module. Create the actual script in your VB program inserting the
fax number as part of the sendkeys method in the wscript shell. You will
probably have to insert some time loops as well. The script will run even
when Access is waiting for the printer.

You should launch the report in preview mode and then use the script to
print, insert the fax number and send the document to the fax printer. Once
finished you can close the preview report!