THEO TODMAN’S WEBSITE CODE PAGES

Table of Query Documentation: Query-Type = Select (644 items)

• Books (Table)

• Papers (Table)

• PaperSummaries_Changed_List

• Abstracts_Changed_List1 (Query)
• Papers (Table)

• cmdChangedAbstracts_Click (From Line 2)
• CreateAbstractWebPages (From Line 72)

• Papers (Table)

• Abstracts_Changed_List3 (Query)
• Papers (Table)

• CreateAbstractWebPages (From Line 68)

• Abstracts_Changed_List2 (Query)
• Papers (Table)

• CreateAbstractWebPages (From Line 66)

• Abstracts_Archive (Table)
• Papers (Table)

• Abstracts_Changed_List

• Abstracts_Archive (Table)
• Notes (Table)
• Papers (Table)

• Abstracts_Changed_List_Plus+TempNotes

• Abstracts_Archive (Table)
• Notes (Table)
• Papers (Table)

• Abstracts_Changed_List_Plus+Notes

• Papers (Table)

• CreateAbstractWebPages (From Line 147)

• Abstracts_Archive (Table)
• Papers (Table)

• JumpTableTitles_Recent_Control (From Line 125)

• Notes_Archive_Temp (Table)
• Notes_List_Auto (Query)

• Active_Notes_Union

• Note_Links (Table)
• Notes_Archive_Temp (Table)

• Active_Notes_Union

• Active_Notes_Union (Query)

• CreateNotesWebPages (From Line 29)

• Papers (Table)

• Papers (Table)
• PID_Note_Reading_Lists (Table)

• cmdRecalculate_Click (From Line 33)
• Update_Live_Notes_Functor (From Line 23)

• Aeon_Files (Table)

• cmdAeon_Click (From Line 21)

• Aeon_Files (Table)

• Aeon_Files (Table)
• Notes (Table)

• Aeon_Papers_Add
• Aeon_Papers_LastYearHours_Add
• Aeon_Papers_LastYearHours_Total
• Aeon_Papers_PaperID_Updt

• cmdRecalculate_Click (From Lines 21, 27)

• Aeon_Papers_Add_Prelist (Query)
• Paper_Actuals (Table)
• Papers (Table)
• Timesheet_Last Year (Table)

• cmdRecalculate_Click (From Line 30)

• Aeon_Files (Table)
• Papers (Table)

• Aeon_Papers_Task_List_Count

• Functor_22 (From Line 165)

• Aeon_Papers_Task_List (Query)

• Functor_23 (From Line 125)

• Next_Reporting_Month (Table)

• cmdRecalculate_Click (From Lines 24, 36)

• Aeon_Files (Table)

• cmdAeon_Click (From Line 13)

• Aeon_Files (Table)

• cmdAeon_Click (From Line 9)

• Aeon_Files (Table)

• cmdAeon_Click (From Line 17)

• Papers (Table)
• PID_Note_Reading_Lists (Table)

• Aeon_Timesheet_Updates_Prelist (Query)
• Timesheet (Table)

• cmdRecalculate_Click (From Line 34)

• Aeon_Files (Table)
• Papers (Table)

• Aeon_Timesheet_Updates

• Code_Table (Table)
• Query_Definitions (Table)
• Table_Definitions (Table)

• Documentation_Generator (From Lines 80, 82)

• Notes_Archive (Table)

• Spider_Archived_Notes_Import (From Line 75)

• Authors (Table)
• Authors_Cited_By_All_List (Table)

• Authors_Summary_Temp_Count_Gen_Citations
• Authors_Summary_Temp_Count_Gen2
• Authors_Summary_Temp_Gen2

• Author_Letters (Table)

• Website_Regen_Latest_List

• Authors (Table)

• cmdSearchAuthorNarrs_Click (From Line 12)

• Authors (Table)
• Cross_Reference (Table)

• Authors_Cited_By_All_List_Query

• Books (Table)
• Cross_Reference (Table)
• Quality_Markers (Table)

• Authors_Cited_By_All_List_Query

• Cross_Reference (Table)
• Notes (Table)

• Authors_Cited_By_All_List_Query

• Cross_Reference (Table)
• Papers (Table)
• Quality_Markers (Table)

• Authors_Cited_By_All_List_Query

• Authors_List1 (Query)

• Authors_List_Authors_Table (Table)

• Monthly_Report_Note1010_Update (From Line 279)

• Authors_List_Changed1 (Query)

• cmdChangedPaperSummaries_Click (From Line 4)
• WebpageGenAuthors (From Line 20)

• Authors_List1 (Query)
• Books (Table)
• Papers (Table)

• cmdBooksMove_Click (From Line 11)
• cmdNotesTableAuto_Click (From Line 11)

• Authors_List_Letter_Table (Table)

• cmdWebsiteRegen_Click (From Line 386)
• WebpageGenAuthors (From Line 60)

• Author_Parameter (Table)
• Authors_List1 (Query)

• Aeon_Authors_Add (From Line 97)
• cmdAuthorNarrUpdt_Click (From Line 26)
• WebpageGenAuthors (From Line 87)

• Authors_List1 (Query)

• Authors_List_Letter_Table_GEN

• Authors (Table)

• WebpageGenAuthorsSummary (From Lines 33, 34, 37)

• Author_Letters (Table)

• Auto_Reference_Notes_Actions (Table)
• Note_Alternates (Table)

• Functor_21 (From Line 52)

• Auto_Reference_Notes_Actions (Table)
• Note_Alternates (Table)

• Functor_21 (From Line 65)

• Auto_Reference_Notes_Actions (Table)

• Functor_21 (From Line 68)

• Auto_Reference_Notes_Actions (Table)
• Note_Alternates (Table)

• Functor_21 (From Line 48)

• Auto_Translate_Reference_Notes_Actions (Table)

• Auto_Translate_Reference_Notes (From Line 239)

• Next_Qtr_Plans (Query)
• Reporting_Periods (Query)
• This_Qtr_Plans (Query)
• Year_Plans (Query)
• YTD_Plans (Query)

• Query15
• Query18
• Query4
• Query5

• Backup_Control (Table)
• Backup_Directory_Structure (Table)

• Backup_Directory_Structure_Zapper_GEN
• Backup_Site_Map_Zapper_DirectoryGone_GEN
• Backup_Site_Map_Zapper_GEN

• Backup_Site_Map (Table)

• Backup_Ctrl (From Line 223)

• Backup_Site_Map (Table)

• cmdBackup_Click (From Line 28)

• Webrefs_Table (Table)

• Functor_22 (From Line 174)

• Bible_Completion_Dates_Aim (Table)
• Bible_Reading_Summary (Query)

• Bible_Reading_Progress1

• Bible_Completion_Dates_Aim (Table)
• Bible_Reading_Control (Table)

• Bible_Latest_Prelist_2

• Bible_Latest_Prelist_1 (Query)
• Bible_Reading_Control (Table)

• Bible_Latest_Verses_Read_1

• Bible_Latest_Verses_Read_2 (Query)

• Bible_Reading_Progress1

• Bible_Latest_Prelist_2 (Query)
• Bible_Reading_Control (Table)

• Bible_Latest_Verses_Read_2

• Bible_Reading_Control (Table)

• cmdBible_Click (From Lines 4, 7)

• Bible_Reading_Progress1 (Query)

• cmdBible_Click (From Lines 2, 5)
• Functor_21 (From Line 248)

• Bible_Completion_Dates_Aim (Table)
• Bible_Completion_Elapsed_Days (Query)
• Bible_Latest_Verses_Read (Query)
• Bible_Reading_Summary (Query)

• Bible_Reading_Progress

• Bible_Completion_Dates_Aim (Table)
• Bible_Reading_Control (Table)

• Bible_Reading_Summary

• Site_Map (Table)

• cmdSpider_Click (From Lines 2, 12)

• Books (Table)
• Quality_Markers (Table)

• Book_Location_Refs
• Book_Summary_Refs

• Book_Abstracts_Archive (Table)

• JumpTableTitles_Recent_Control (From Line 141)

• Author_Book_Links (Table)
• Books (Table)
• Quality_Markers (Table)

• Authors_List1
• Book_Author_List_Changed

• Authors_Changed (Query)
• Book_Author_List (Query)

• Authors_List_Changed1

• Author_Book_Links (Table)
• System_Parameters (Table)

• Authors_Changed

• Book_Book_Links (Table)
• Books (Table)
• Quality_Markers (Table)

• Book_Book_List_Changed
• Book_Book_List_Changed1
• Book_Citings_List

• Book_Book_List (Query)
• Book_Citings_List_Changed1 (Query)

• Book_Citings_List_Changed

• Book_Book_List_New (Query)
• Book_Citings_List_Changed1 (Query)

• Book_Citings_List_Changed_New

• Book_Book_List (Query)
• Book_Summary_Changed_List (Query)

• Book_Citings_List_Changed1

• Books (Table)
• Cross_Reference (Table)
• Quality_Markers (Table)

• Book_Book_List_Changed_New
• Book_Citings_List_New_Query

• Book_Citings_List_New (Table)
• Books (Table)

• WebpageGenBookCitings (From Line 29)

• Book_Citings_List_New (Table)
• Books (Table)

• Book_Citings_Page_List (Letters)

• WebpageGenBookCitingsPage (From Lines 2, 6)

• Book_Citings_Page_List (Query)

• Books (Table)

• Book_Abstract_Quality_List (Query)
• Book_Summary (Table)
• Books (Table)

• Books_Locations_Table_GEN

• Note_Book_Links (Table)

• BookSummaries_Changed_List

• CreateBookPaperAbstractsWebPages (From Line 439)

• Books (Table)
• Cross_Reference (Table)
• Cross_Reference_Prelims (Table)
• Note_Groups (Table)
• Notes (Table)
• Notes_Archive (Table)

• WebpageGenBooksToNotes (From Line 6)

• Books (Table)
• Cross_Reference (Table)
• Note_Groups (Table)
• Notes (Table)
• Notes_Archive (Table)
• Notes_Archive_Latest_Time (Query)

• Books (Table)

• Note_Book_Links_List

• Books (Table)
• Locations (Table)
• Papers (Table)

• cmdBooksMove_Click (From Line 10)
• cmdNotesTableAuto_Click (From Line 10)

• Paper_Book_Links (Table)
• Papers (Table)
• Quality_Markers (Table)

• Book_Citings_List
• Book_Paper_List_Changed
• Book_Paper_List_Changed1

• Book_Citings_List_Changed1 (Query)
• Book_Paper_List (Query)

• Book_Citings_List_Changed

• Book_Citings_List_Changed1 (Query)
• Book_Paper_List_New (Query)

• Book_Citings_List_Changed_New

• Book_Paper_List (Query)
• Paper_Summary_Changed_List (Query)

• Book_Citings_List_Changed1

• Cross_Reference (Table)
• Papers (Table)
• Quality_Markers (Table)

• Book_Citings_List_New_Query
• Book_Paper_List_Changed_New

• Book_Papers_Full (Table)
• Book_Papers3 (Query)
• Books (Table)
• Papers (Table)

• BookPaperAbstracts_List_Changed
• Books_Versus_Papers_List

• Books (Table)

• Paper_Books (Table)

• Book_Papers2

• Book_Papers2 (Query)

• Book_Papers_Changed
• Book_Papers4
• Book_Papers6
• BookPaperAbstracts_List_Query
• Books_Versus_Papers_List
• Books_Versus_Papers_List_Regen

• Book_Papers3 (Query)
• Papers (Table)

• Book_Papers5

• Book_Papers4 (Query)

• BookPaperAbstracts_List_Query
• Books_Versus_Papers_List
• Books_Versus_Papers_List_Regen

• Book_Papers3 (Query)
• Papers (Table)

• Book_Papers7

• Book_Papers6 (Query)

• BookPaperAbstracts_List_Query
• Books_Versus_Papers_List
• Books_Versus_Papers_List_Regen

• Book_Subject_Union (Query)

• Book_Subject_Topic_Subtopic_List

• Book_Subject_All (Query)
• Book_SubTopic_All (Query)
• Book_Topic_All (Query)
• TopicEqualsSubTopic (Query)

• Books - All - Categorised_Table_GEN
• Books - Recent - Categorised

• Books (Table)

• Book_Subject_Union

• Books (Table)

• Book_Subject_Union

• Books (Table)

• Book_Subject_Union

• Book_SubTopic_Union (Query)

• Book_Subject_Topic_Subtopic_List

• Books (Table)

• Book_SubTopic_Union

• Books (Table)

• Book_SubTopic_Union

• Books (Table)

• Book_SubTopic_Union

• Book_Summary (Table)
• Books (Table)

• Book_Book_List_Changed1
• Paper_Book_List_Changed1

• cmdChangedPaperSummaries_Click (From Line 3)

• Book_Summary_Ranges (Table)

• Website_Regen_Latest_List

• Book_Abstract_Quality_List (Query)
• Book_Summary (Table)
• Books (Table)

• Books - All
• Books - All - Categorised_Table_GEN
• Books - Recent
• Books - Recent - Categorised
• Dud_Abstracts_Books

• Book_Topic_Union (Query)

• Book_Subject_Topic_Subtopic_List

• Books (Table)

• Book_Topic_Union

• Books (Table)

• Book_Topic_Union

• Books (Table)

• Book_Topic_Union

• Books (Table)

• cmdBooksOrdered_Click (From Line 2)

• Books (Table)

• BookPaperAbstract_Ranges (Table)

• Website_Regen_Latest_List

• Book_Papers_Changed (Query)
• BookPaperAbstracts_List (Table)

• Book_Papers3 (Query)
• Book_Papers5 (Query)
• Book_Papers7 (Query)
• Books (Table)
• Papers (Table)
• Pseudo_Books (Table)
• Quality_Markers (Table)

• BookPaperAbstracts_List_Gen
• BookPaperAbstracts_List_Regen_Old_List

• BookPaperAbstract_Ranges (Table)
• BookPaperAbstracts_List (Table)
• Current_ID (Table)

• BookPaperAbstracts_List (Table)
• Books_To_Regen (Table)

• BookPaperAbstracts_List_Regen_Old_List (Query)
• Books_To_Regen (Table)

• BookPaperAbstracts_List_Query (Query)

• BookPaperAbstracts_List_Regen_Old

• BookPaperControl (Table)

• Website_Regen_Latest_List

• BookPaperControl (Table)

• Functor_21 (From Line 263)

• BookPaperLinks_Ranges (Table)

• Website_Regen_Latest_List

• Book_Summary (Table)
• Book_Summary_Refs (Query)
• Books (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• Books - All - Categorised
• Books - All - Categorised (Titles)
• Books - All - Categorised (Titles) - Counter
• Books - All - Categorised (Titles) - Prelist
• Books - All - Categorised (Titles) - Prelist - Top
• Books - All - Categorised (Titles) - Top
• Books - All - Categorised (Titles) - Top1
• Books - All - Categorised_Table_GEN

• WebpageGenBooks (From Line 6)

• Books (Table)
• Books - All (Query)
• Books - All - Categorised_Table (Table)

• Books - All - Categorised (Titles)
• Books - All - Categorised (Titles) - Counter
• Books - All - Categorised (Titles) - Prelist
• Books - All - Categorised (Titles) - Prelist - Top
• Books - All - Categorised (Titles) - Top
• Books - All - Categorised (Titles) - Top1

• WebpageGenBooksCategorised (From Line 6)

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)
• Books - All - Categorised (Titles) (Query)
• Books - All - Categorised (Titles) - Prelist (Query)

• Books - All - Categorised (Titles)
• Books - All - Categorised (Titles) - Counter
• Books - All - Categorised (Titles) - Top
• Books - All - Categorised (Titles) - Top1

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)
• Books - All - Categorised (Titles) (Query)

• Books - All - Categorised (Titles) - Top

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)

• Books - All - Categorised (Titles)
• Books - All - Categorised (Titles) - Top1

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)

• Books - All - Categorised (Titles) - Top1

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)
• Books - All - Categorised (Titles) (Query)
• Books - All - Categorised (Titles) - Counter (Query)
• Books - All - Categorised (Titles) - Top1 (Query)

• Books (Table)
• Books - All (Query)
• Books - All - Categorised (Query)
• Books - All - Categorised (Titles) (Query)
• Books - All - Categorised (Titles) - Prelist (Query)
• Books - All - Categorised (Titles) - Prelist - Top (Query)

• Books - All - Categorised (Titles) - Top

• Books (Table)

• Books (Table)

• Books - Papers Uncatalogued

• Books (Table)
• Locations (Table)

• cmdBooksMove_Click (From Line 8)
• cmdNotesTableAuto_Click (From Line 8)

• Papers (Table)
• qryBooks (Query)

• Books - Papers Uncatalogued
• Identity Sources - By Author (Summary)
• Identity Sources - By Author Within Priority (Summary)

• Books (Table)
• Books - Collections of Papers (Query)
• Books - Papers Catalogued (Query)
• Papers (Table)

• Books (Table)

• Book_Summary (Table)
• Book_Summary_Refs (Query)
• Books (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• Books - Recent - Categorised (Titles)
• Books - Recent - Categorised (Titles) - Prelist
• Books - Recent (Letters)

• WebpageGenBooksRecent (From Line 15)

• Book_Subject_Topic_Subtopic_List (Query)
• Book_Summary (Table)
• Book_Summary_Refs (Query)
• Books (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• Books - Recent - Categorised (Titles)
• Books - Recent - Categorised (Titles) - Prelist

• WebpageGenBooksRecentCategorised (From Line 15)

• Books (Table)
• Books - Recent (Query)
• Books - Recent - Categorised (Query)
• Books - Recent - Categorised (Titles) (Query)
• Books - Recent - Categorised (Titles) - Prelist (Query)

• Books - Recent - Categorised (Titles)

• Books (Table)
• Books - Recent (Query)
• Books - Recent - Categorised (Query)

• Books - Recent - Categorised (Titles)

• Books (Table)
• Books - Recent (Query)

• Books (Table)

• cmdLRB_Update_Click (From Line 4)
• cmdSearchBooks_Click (From Line 2)

• Books (Table)
• Books_Cited (Query)
• Citations_Note_Group (Query)
• Note_Usage_Temp (Table)
• Notes (Table)
• Sub-Topics (Table)

• Books_By_SubTopic

• Books (Table)
• Books_Cited (Query)
• Citations_Note_Group (Query)
• Note_Usage_Temp (Table)
• Notes (Table)
• Sub-Topics (Table)

• Books_By_SubTopic

• Books (Table)
• Books_Cited (Query)
• Citations_Note_Group (Query)
• Note_Usage_Temp (Table)
• Notes (Table)
• Sub-Topics (Table)

• Books_By_SubTopic

• Books (Table)
• Citations_Note_Group (Query)
• Note_Book_Links (Table)
• Note_Usage_Temp (Table)
• Notes (Table)

• Books_By_SubTopic1
• Books_By_SubTopic2
• Books_By_SubTopic3
• Books_from_Papers_By_Subtopic
• Books_from_Papers_Cited
• Citations_Union1
• Citations_Union2

• Books (Table)
• Books_By_SubTopic (Query)
• Books_Cited (Query)
• Papers_By_SubTopic (Query)

• Citations_Union1

• Books (Table)
• Books_By_SubTopic (Query)
• Books_Cited (Query)
• Papers_Cited (Query)

• Citations_Union1
• Citations_Union2

• Books_Locations_Table (Table)

• Books_Locations (Titles)
• Books_Locations (Titles) - Counter
• Books_Locations (Titles) - Prelist
• Books_Locations (Titles) - Top
• Books_Locations (Titles) - Top1

• WebpageGenBooksLocation (From Line 6)

• Books_Locations (Query)
• Books_Locations (Titles) (Query)
• Books_Locations (Titles) - Prelist (Query)
• Location_Group_IDs (Query)
• Locations (Table)

• Books_Locations (Titles)
• Books_Locations (Titles) - Counter
• Books_Locations (Titles) - Top
• Books_Locations (Titles) - Top1

• Books_Locations (Query)
• Books_Locations (Titles) (Query)

• Books_Locations (Titles) - Top

• Books_Locations (Query)

• Books_Locations (Titles)
• Books_Locations (Titles) - Top1

• Books_Locations_Table (Table)
• Location_Group_IDs (Query)
• Locations (Table)

• Books_Locations (Titles) - Top1

• Books_Locations (Query)
• Books_Locations (Titles) (Query)
• Books_Locations (Titles) - Counter (Query)
• Books_Locations (Titles) - Top1 (Query)

• Books_Locations (Query)
• Books_Locations (Titles) (Query)
• Books_Locations (Titles) - Prelist (Query)
• Books_Locations (Titles) - Prelist - Top (Query)

• Books_Locations (Titles) - Top

• Books (Table)
• Cross_Reference (Table)
• Notes (Table)
• Thesis_Reading_Lists_Books (Query)

• Works_Missing_By_Thesis_Chapter_Union

• cmdNotes_Click (From Line 68)

• Books (Table)
• Subjects (Table)
• Sub-Topics (Table)

• cmdNearlyReadBooks_Click (From Line 2)

• Books (Table)
• Papers (Table)
• qryBooks (Query)

• Book_Papers_Changed (Query)
• Book_Papers3 (Query)
• Book_Papers5 (Query)
• Book_Papers7 (Query)
• Books (Table)
• Papers (Table)
• Quality_Markers (Table)

• cmdWebsiteRegen_Click (From Line 426)
• WebpageGenBooksToPapers (From Line 7)

• Book_Papers3 (Query)
• Book_Papers5 (Query)
• Book_Papers7 (Query)
• Books (Table)
• Books_To_Regen (Table)
• Papers (Table)
• Quality_Markers (Table)

• PID_Papers_Filed
• PID_Papers_Filed_Not_Referenced

• Book_Note_Counts (Query)
• Book_Summary_Temp (Table)
• Books (Table)
• Notes (Table)
• Papers (Table)
• Quality_Markers (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• CreateBookSummariesWebPages (From Lines 119, 156)

• Locations (Table)

• cmdBooksMove_Click (From Line 7)
• cmdNotesTableAuto_Click (From Line 7)

• Citations_List (Query)

• AddCitations_List (From Lines 20, 37, 40)
• CreateConcatenatedNoteGroupWebPages (From Line 108)

• Books (Table)
• Citations_Union1 (Query)
• Papers (Table)
• Sub-Topics (Table)

• Citations_Count

• AddReading_List (From Line 22)

• Books (Table)
• Citations_Union2 (Query)
• Papers (Table)
• Sub-Topics (Table)

• AddReading_List (From Line 20)

• Note_Groups (Table)
• Note_Usage_Temp (Table)
• Notes (Table)

• Books_By_SubTopic1
• Books_By_SubTopic2
• Books_By_SubTopic3
• Books_Cited
• Papers_By_SubTopic1
• Papers_By_SubTopic2
• Papers_By_SubTopic3
• Papers_Cited

• Code_Archive_Table (Table)

• Code_Archive (From Line 5)

• Photos_Raw (Table)

• cmdTimelines_Click (From Line 105)
• Functor_16 (From Line 48)

• Backup_Site_Map (Table)

• Photo_Copy2 (From Line 28)

• Photos_Raw (Table)

• cmdTimelines_Click (From Line 99)
• Functor_16 (From Line 46)

• Photos_Raw (Table)

• cmdTimelines_Click (From Line 93)
• Functor_16 (From Line 44)

• Cross_Reference (Table)

• Functor_22 (From Line 103)

• Cross_Reference_Changes (Table)

• Functor_22 (From Line 113)

• Cross_Reference_Changes (Table)