IntelliTrack Inventory Management - Manual (Page 341)

Appendix F
Microsoft Access Integration
315
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 Inventory 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 usage 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.
2287.book Page 315 Thursday, July 7, 2011 4:45 PM