Managing Microsoft Access reports to design, preview, print, report view, output to PDF, etc.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modReports module
|
|
CurrentReportView
|
Procedure
|
Retrieve the current view of the specified report, if it's open
|
|
GetActiveReport
|
Procedure
|
Returns the name of the currently active report
|
|
IsReportOpen
|
Procedure
|
Determines if a report is open
|
|
IsReportOpenInDesignView
|
Procedure
|
Determines if a report is open in design view
|
|
IsReportOpenInLayoutView
|
Procedure
|
Determines if a report is in report view mode
|
|
IsReportOpenInMode
|
Procedure
|
Determines if a report is open in a particular view
|
|
IsReportOpenInPrintPreview
|
Procedure
|
Determines if a report is in print preview mode
|
|
IsReportOpenInReportView
|
Procedure
|
Determines if a report is in report view mode
|
|
ReportClose
|
Procedure
|
Closes the named report without errors by first checking if the report isn open, and closing it if so.
This function is useful when closing a report in code, and that report may not be open.
|
|
ReportCloseAll
|
Procedure
|
Closes all open reports that can be closed
|
|
ReportControlPropertiesChange
|
Procedure
|
Sets a property to a value on all controls of a report.
Opens a Report in design view, sets the specified property to the specified value on all controls, and optionally saves the Report.
|
|
ReportControlsToArray
|
Procedure
|
Populates the passed array with control names of a Report.
The passed array must be 0-based. The procedure will expand the array as needed, so you do not need to pre-allocate array storage before calling the procedure.
If the report specified is not open, the procedure opens it in design view, fills the array and then closes the report.
If the report specified is already open, this procedure does not re-open or close the report.
|
|
ReportControlsToString
|
Procedure
|
Populates the passed string with control names of a Report.
Use the chrDelimit parameter to specify the character or characters to use as the delimiter between control names.
The procedure places the resulting string in the strIn parameter.
|
|
ReportNamesToArray
|
Procedure
|
Loads an array with the names of all the reports in the current database
|
|
ReportNamesToString
|
Procedure
|
Populates a string with the names of all the reports in the current database
|
|
ReportOpen
|
Procedure
|
Opens or set focus to the named Report
|
|
ReportOpenDesign
|
Procedure
|
Opens a report in design mode. If it's already open, change the current view to design view
|
|
ReportOpenDesignAll
|
Procedure
|
Opens all the reports in design view and minimizes them on the workspace. Skips reports that are already open
|
|
ReportOpenPreview
|
Procedure
|
Open report in preview mode and maximizes it(useful if user doesn't have tab view)
|
|
ReportOpenReportView
|
Procedure
|
Open report in report view mode, maximized (useful if user doesn't have tab view)
|
|
ReportOutput
|
Procedure
|
Export a report to a file such as a PDF, XPS, HTML, Snapshot, etc.
|
|
ReportOutputPDF
|
Procedure
|
Export a report to a file in PDF format
|
|
ReportPrint
|
Procedure
|
Print an entire report
|
|
ReportPrintPages
|
Procedure
|
Print a range of pages from a report
|
|
ReportPropertyChange
|
Procedure
|
Changes the value of the named property on a Report
|
|
ReportsOpen
|
Procedure
|
Determines if any Reports are open
|
|
WaitUntilReportClose
|
Procedure
|
Waits for the named report to close as an alternative to opening the report in dialog mode.
Uses Sleep command rather than DoEvents which eats up CPU processing resources.
|
All Our Microsoft Access Products
(885K)
