Print to File?

[RxBill]

Is there anyway to get Access, under code control, to print a report to a file? Would like the code to name the file so the user does not have to deal with a dialog box (our app can print up to 7,000 reports at a time so this could get tedious).

Thanks,

Bill Richardson
RxAmerica, LLC
Salt Lake City, Utah

 

[billt]

Try this
DoCmd.OutputTo acOutputReport
, MyRpt, [outputformat][, outputfile][, autostart][, templatefile]
I have not been able to output a report to a MsDos file without extraneous rows. Think the culprit is the Graphic Device Interface which introduces a layer of abstraction so programmers can write to any screen or printer. e-mail me if anyone knows how to go directly to a dos file.