|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Complete History | |
| TPW 3/19/2011 11:18:24 AM | Jeff, I use to use the Quick Index tool to create a "Complete History" that would allow me to view a playlist file spanning multiple calendar years. Is there a way to accomplish this task on the Starterhistory Table? Terry
| |
| jeff 3/19/2011 1:59:55 PM | Easiest best way is to discard the idea of quick index files altogether - and use the Data Window to populate a starterhistory table with data spanning multiple years: 1. Grab the c:\JCapperBuild\JCapper2.mdb file, and place a renamed copy of the file (JCapper2_MultiYear.mdb works) on the c:\JCapper\Exe folder. 2. In the Data Window, click MENU, and then connect to your new (JCapper2_MultiYear.mdb) file. 3. Kick the Data Window into playlist file mode and point it at your first target folder from a prior year. 4. Click MENU, click EXPORTS, and select StarterHistory Table Export - Clear First. Toggling the export on will clear the starterhistory table sitting in the connected to JCapper2.mdb file. 5. Run an ALL button query on the pointed to target folder. Becase the export is toggled "on" - data for all starters returned by the query will be written to the starterhistory table in the connected to JCapper2.mdb file. 6. Click MENU and run a Compact and Repair Database File routine on the connected to JCapper2_MultiYear.mdb file placed on your c:\JCapper\Exe folder from step 1 above. 7. Point the Data Window at your next target folder, click MENU - and toggle a StarterHistory Table Export "on" - but this time make sure your export is an Append. 8. Run an ALL button query on the pointed to target folder. Becase the export is toggled "on" - data for all starters returned by the query will be written to the starterhistory table in the connected to JCapper2.mdb file. 9. Click MENU and run a Compact and Repair Database File routine on the connected to JCapper2_MultiYear.mdb file placed on your c:\JCapper\Exe folder from step 1 above. Repeat steps 7, 8, and 9 above until you are out of target folders. At this point, you have data from multiple years/folders sitting in a starterhistory table -- which in my opinion, is vastly preferable to using text based quick index files. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |