IntelliTrack Check In/Out - Manual (Page 421)

Appendix C
Microsoft Access Integration
393
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:
1. Select Create > Forms > More Forms > Form Wizard from the
Command tab bar.
2. The Form wizard appears. Select a table or query to use as a data source
from the Select a Table/Query drop-down list.
3. Follow the wizard to create a form.
4. View the form in Design mode to make modifications (rearrange the
field order, etc.).
2283.book Page 393 Thursday, July 9, 2009 11:26 AM