IntelliTrack Check In/Out - Manual (Page 509)

Appendix F
Microsoft Access Integration
479
3. Follow the Report Wizard to make the selections to build the report.
You can view the report in Design mode to make modifications.
Adding
Reports
To add the custom report to the Report menu complete the following
steps:
1. Select Tools > Customize > Reports from the menu bar.
2. Click the Add button.
3. Enter a name for the Report in the Title column.
4. Enter an optional description in the Description column.
5. Enter the name of the custom report exactly as named in the Access
Navigation Pane in the Name column.
6. Press Close (a value in the Query/Table name is optional).
7. Open the Reports table in Microsoft Access and find the Report ID
value for the new report.
8. Open the Modules table and find the ModuleID value for your appli-
cation.
9. Open the ModuleReports table and add a new record using the
ReportID and ModuleID values from steps 7 and 8, for the ReportID
and the ModuleID fields in the ModuleReports table, respectively.
10. In the Check In-Out application, open the Reports form by clicking
Reports > Reports. The new report should be listed as a selection in
this form.
11. The next time you open the Reports form, the report added in the previ-
ous steps will be available in the report list.
Custom Queries
Note: The use of the term Queries indicates that the Query is a form that
appears on the IntelliTrack System’s Query Database selection list. The
title you enter should be the name of a Form designed using Access. We are
referring to Query (asking and viewing) vs. the Query Objects in Access,
which have a different connotation.
Complete the following steps to create a custom form:
2283.book Page 479 Thursday, July 7, 2011 2:29 PM