Theo Todman's Web Page - Notes Pages

To see the Code, click on the procedure names above.

The first option offered is “Update / Regenerate Thesis / PID Notes”, which – if accepted – provides the following options:-

1. Open the PID_Note_Reading_Lists table: uses query PID_Note_Reading_Lists_List to open the table in reading-list order.
2. Update PID_Note_Reading_Lists table for a particular Note: opens qry_PID_Note_Reading_Lists_Note, which requests a Note ID and returns rows in in reading-list order.
3. Update PID_Note_Reading_Lists table for a particular Paper: opens qry_PID_Note_Reading_Lists_Paper, which requests a Paper ID. To check for and ensure consistency of publication date and footnote where the same paper is referenced by multiple PID Notes.
4. Update PID_Note_Reading_Lists table for a particular Book: as above, but for Books. Opens qry_PID_Note_Reading_Lists_Book.
5. Open the Thesis_Note_XRef table: Opens Thesis_Note_XRef_List.
6. Open Thesis PID Note Usage Queries: Opens the following:-
   → PID_Notes_By_Thesis_Chapter
   → PID_Notes_Unused_By_Thesis
   → PID_Notes_Used_By_Thesis_Chapter
7. Open Thesis Missing Book/Papers Queries: Opens the following:-
   → Books_Missing_By_Thesis_Chapter
   → Papers_Missing_By_Thesis_Chapter
   → IdentityPapersRead_Unreferenced
8. Regenerate Functors in Live Note(s): Runs Update_Live_Notes_Functor. This has two options – select all non-Temp PID Notes or just one. You are given the option of actually regenerating the selected Note(s), or simply updating the Note database record with its associated Archived_Note. Basically, the Function invokes all the Functors embedded in the Note(s) and performs the updates. This is also useful if you want to make a trivial

• cmdDisplayArchivedNote_Click
• cmdRegenerateArchivedNote_Click
• cmdRegenerateArchivedNoteRanges_Click