"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Microsoft Access : Environment
|
|
Description:
|
Access application, ADP, and startup routines, managing the Access window, printers, ribbons, status bar, and Microsoft Visual SourceSafe
|
Module: modPrinter
Manage the printer settings and orientation on Access forms and reports
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modPrinter module
|
|
FormPrinter
|
Procedure
|
Retrieves the form's assigned printer
|
|
ReportPrinter
|
Procedure
|
Retrieves the report's assigned printer
|
|
ResetFormPrinter
|
Procedure
|
Resets a form's printer to use the default printer.
This eliminates a form having a specified printer which may not exist on someone else's machine, causing this form to crash if printing is attempted.
|
|
ResetFormPrinterAll
|
Procedure
|
Resets all Forms to use the default printer.
This eliminates form having a specified printer which may not exist on someone else's machine, causing the form to crash if printing is attempted.
Assumes all reports are closed when this starts.
|
|
ResetPrinter
|
Procedure
|
If you make a change to objects in the Application.Printers collection, they remain active as long as Application is active.
To reset changes, you must set Application.Printer to Nothing.
|
|
ResetReportPrinter
|
Procedure
|
Resets a report's printer to use the default printer.
This eliminates a report having a specified printer which may not exist on someone else's machine, causing this report to crash if printing is attempted.
|
|
ResetReportPrinterAll
|
Procedure
|
Resets all the reports in the current database to use the default printer.
This eliminates reports having a specified printer which may not exist on someone else's machine, causing the report to crash if printing is attempted.
Assumes all reports are closed when this starts.
|
|
SavePrinterSettings
|
Procedure
|
Example of changing printer settings temporarily, then resetting them.
You can create a temporary printer variable to save values of a printer before changing them.
This allows you to restore values after making changes.
|
|
SetOrientationLandscape
|
Procedure
|
Set the passed report to landscape mode. Call from the Report's open event.
|
|
SetOrientationPortrait
|
Procedure
|
Set the passed report to portrait mode. Call from the Report's open event.
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
