"On the Fly Printing"
for Access

One of problematic areas of Access development is giving users a way to change the printer for an Access report when the report is sent to print without having to preview the report. Veteran Access developers have relied on "On the Fly Printing" to solve this problem.
ACG Soft's "On the Fly Printing" Access code module and class modules provides a simple "drop in" solution for developers wanting to provide users a way to change between local and network printers when printing a report. Its fast and easy to use. With OTF you can:

Not only change printers but select pages to print, number of copies and collation through the standard Print Dialog to preserve the Windows application "look and feel".

Save printer setting changes with the report, or return to the default printer after the print job.

Send multiple reports to a single printer, yet retain each report's layout settings (such as landscape or portrait.)

Set Filters for each report as necessary.

Change printers for reports in MDE / ADE databases in Access 97 & 2000/2002/2003.

Print the first page of reports to alternate paper trays (Developer's version only.)

Change printers without user intervention (Developer's version only.)

Check printer status and manage printers (e.g. on-line or off-line, paused etc. Developer's version only.)

 

Why incorporating OTF is better than using a the MS common dialog control or other code options:

Smaller memory foot print requirement for your application.

No broken references on the client machine after installation; code is fully integrated in your app.

What's Easy To Use Mean? Here's an example:

For all versions of Access you can add printer changing functionality by sending your reports to print using the following code from a command button on a form: 

returnval = SetPrint(MyForm.hwnd,"MyReport", True , 1, True)
With the Developer's version of "On the Fly Printing" you get broad functionality and OTF code is provided as a "class" module as well as in standard functions. Using a class module makes OTF code easy to read and maintain; as an example: 
   Dim Printer As New PrintClass
   Dim Result as Boolean
    With Printer
        .ReportName = "Report1"
        .Copies = 1		'Default setting; user can select copies
        .FirstSpoolReport = True
        .NoSaveChange = True
        .PrintRpt		'Send it to print
    End With
        
    Result = Printer.PrintResult
Download a demo database for:
 
OTF for Access 97
OTF for Access 2000, 2002 (Xp) or 2003

See how easy it is to add this functionality to your app.

Licenses are available at the following levels:

Shareware-Personal Use. Shareware licenses limit use to a total of 5 users or less. A Shareware license offers more limited functionality (see the help file included with the demo for details) but costs only $25.00 (US).

Developer's License A Developer's license allows unlimited use of the code, and also provides additional functionality (see the help file included with the demo). Developer Licenses are $95.00 (US).

Register for "On the Fly Printing" for Access
Back to the Developer Tools