THEO TODMAN’S WEBSITE CODE PAGES

Table of Query Documentation: Query-Type = Append (130 items)

• Abstracts_Archive (Table)
• Abstracts_Archive_Temp (Table)

• cmdArchive_Click (From Line 8)

• Abstracts_Archive (Table)
• Abstracts_Archive_Temp (Table)
• Papers (Table)

• cmdArchive_Click (From Line 6)

• Actual_Hours_Temp (Table)
• Subject_Plan (Table)

• cmdRecalculate_Click (From Line 163)

• Philosophers_Index (Table)

• Import_Data (From Line 23)

• Philosophers_Index (Table)

• Aeon_Files (Table)
• Webrefs_Table (Table)

• cmdAeon_Click (From Line 5)

• Aeon_Papers_Add_Prelist (Query)
• Notes (Table)
• Papers (Table)
• Sub-Topics (Table)

• cmdRecalculate_Click (From Line 28)

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

• cmdRecalculate_Click (From Line 29)

• Author_Surnames (Table)
• Authors_Summary_Temp (Table)

• WebpageGenAuthorsSummary (From Line 30)

• Authors (Table)
• Authors_List_Authors_Table (Table)

• cmdRecalculate_Click (From Line 213)

• Authors_Cited_By_All_List (Table)
• Authors_Cited_By_All_List_Query (Query)

• cmdRecalculate_Click (From Line 47)

• Authors_List_Authors_Table (Table)
• Authors_List1 (Query)

• cmdRecalculate_Click (From Line 212)

• Authors (Table)
• Authors_List_Letter_Table (Table)

• WebpageGenAuthorsSummary (From Line 11)

• Author_Letters (Table)
• Authors_List_Letter_Table (Table)
• Authors_List2 (Query)

• WebpageGenAuthors (From Line 62)
• WebpageGenAuthorsSummary (From Line 10)

• Authors_List_Letter_Table (Table)
• Authors_Summary_Temp_Count (Table)

• WebpageGenAuthorsSummary (From Line 19)

• Author_Citation_Counts (Query)
• Authors_Summary_Temp_Count (Table)

• WebpageGenAuthorsSummary (From Line 15)

• Authors_List_Letter_Table (Table)
• Authors_Summary_Temp_Count (Table)

• WebpageGenAuthorsSummary (From Line 23)

• Author_Citation_Counts (Query)
• Authors (Table)
• Authors_Summary_Counts (Query)
• Authors_Summary_Temp (Table)

• Authors (Table)
• Authors_Summary_Temp (Table)

• WebpageGenAuthorsSummary (From Line 6)

• Author_Citation_Counts (Query)
• Authors (Table)
• Authors_Summary_Counts (Query)
• Authors_Summary_Temp (Table)

• Backup_Directory_Structure (Table)
• Backup_Directory_Structure_Temp (Table)

• Backup_Ctrl (From Line 166)

• Backup_Directory_Structure (Table)
• Backup_Directory_Structure_List (Query)
• Backup_Directory_Structure_Temp (Table)
• Backup_Directory_Structure_Zapper (Table)

• Backup_Ctrl (From Line 163)

• Backup_Site_Map (Table)
• Backup_Site_Map_Temp (Table)

• Backup_Ctrl (From Line 173)

• Backup_Directory_Structure_List (Query)
• Backup_Site_Map (Table)
• Backup_Site_Map_Zapper (Table)

• Backup_Ctrl (From Line 179)

• Backup_Directory_Structure (Table)
• Backup_Directory_Structure_List (Query)
• Backup_Site_Map (Table)
• Backup_Site_Map_Temp (Table)
• Backup_Site_Map_Zapper (Table)

• Backup_Ctrl (From Line 178)

• Book_Abstracts_Archive (Table)
• Book_Abstracts_Archive_Temp (Table)

• cmdRecalculate_Click (From Line 218)

• Book_Abstracts_Archive (Table)
• Book_Abstracts_Archive_Temp (Table)
• Books (Table)

• cmdRecalculate_Click (From Line 216)

• Book_Citings_List_New (Table)
• Book_Citings_List_New_Query (Query)

• cmdRecalculate_Click (From Line 45)

• Book_Location_Stats_Temp (Table)
• Books (Table)

• cmdBooksMove_Click (From Line 4)
• cmdNotesTableAuto_Click (From Line 4)

• Book_Paper_Solitons (Table)
• Book_Papers_Full (Table)

• cmdRecalculate_Click (From Line 222)

• Book_Paper_Solitons (Table)
• Book_Paper_Solitons_Zapper (Table)
• Book_Papers_Full (Table)

• cmdRecalculate_Click (From Line 225)

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

• CreatePapersToBooksWebPages (From Line 370)

• BookPaperLinks_Ranges (Table)
• Books (Table)
• Books_To_Regen (Table)
• Current_ID (Table)

• CreatePapersToBooksWebPages (From Line 237)

• Book_Summary (Table)
• Book_Summary_Temp (Table)

• cmdArchivePaperSummaries_Click (From Line 13)

• Book_Summary (Table)
• Book_Summary_Temp (Table)
• Books (Table)

• cmdArchivePaperSummaries_Click (From Line 11)
• CreateBookSummariesWebPages (From Line 65)

• Book_Summary_Ranges (Table)
• Book_Summary_Temp (Table)
• Books (Table)
• Current_ID (Table)

• CreateBookSummariesWebPages (From Line 155)

• BookPaperAbstracts_List (Table)
• BookPaperAbstracts_List_Query (Query)

• cmdRecalculate_Click (From Line 51)

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

• Book_Location_Refs (Query)
• Book_Summary (Table)
• Books (Table)
• Books_Locations_Table (Table)
• Locations (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• WebpageGenBooksLocation (From Line 8)

• Papers (Table)
• qryBooks (Query)
• Sub-Topics (Table)
• Topics (Table)

• cmdRecalculate_Click (From Line 153)

• Cross_Reference (Table)
• Cross_Reference_Prelims (Table)

• BooksToNotes_Prelims (From Line 5)

• Cross_Reference (Table)
• Cross_Reference_Changes (Table)
• Cross_Reference_Latest (Query)
• Cross_Reference_Zapper (Table)

• CreateAbstractWebPages (From Line 398)
• CreateAuthorsWebPages (From Line 280)
• CreateBookPaperAbstractsWebPages (From Line 552)
• Notes_Text_Format (From Line 513)

• Cross_Reference (Table)
• Cross_Reference_Changes (Table)
• Cross_Reference_Zapper (Table)

• CreateAbstractWebPages (From Line 389)
• CreateAuthorsWebPages (From Line 279)
• CreateBookPaperAbstractsWebPages (From Line 551)
• Notes_Text_Format (From Line 505)

• Actual_Hours_Temp (Table)
• Next_Reporting_Month (Table)
• Paper_Actuals (Table)
• qryPapers (Query)

• cmdRecalculate_Click (From Line 164)

• Directory_Structure (Table)
• Directory_Structure_Temp (Table)

• Spider_Copy (From Line 29)

• Duplicate_Papers_Prelist (Query)
• Duplicate_Papers_Temp (Table)
• Papers (Table)

• Full_Backup_Directory_Structure (Table)
• Full_Backup_Directory_Structure_Temp (Table)

• Full_Backup_Directory_Structure (Table)
• Full_Backup_Directory_Structure_Backup_Dates (Table)

• Full_Backup_Site_Map (Table)
• Full_Backup_Site_Map_Temp (Table)

• Full_Backup_Site_Map_Dups_Temp (Table)
• Full_Backup_Site_Map_Temp (Table)

• Code_Table (Table)
• Functor_Descriptions (Table)

• Functor_22 (From Line 109)

• Hits_Bots (Table)
• Hits_Bots_By_URL_Key (Table)

• Page_Hits_Import_Control (From Line 165)

• Hits_Bots_By_URL_Key (Table)
• Hits_Bots_Total (Table)

• Page_Hits_Import_Control (From Line 167)

• Hits_Pages (Table)
• Hits_Pages_Total (Table)

• Page_Hits_Import_Control (From Line 169)

• Books (Table)
• Notes (Table)
• PID_Note_Reading_Lists (Table)
• PID_Note_Reading_Lists_Books (Query)
• Sub-Topics (Table)

• Functor_21 (From Line 103)
• Functor_22 (From Line 52)

• Book_Paper_Solitons (Table)
• IdentityPapersRead (Query)
• Notes (Table)
• PID_Note_Reading_Lists (Table)
• PID_Note_Reading_Lists_Books (Query)
• PID_Note_Reading_Lists_Papers (Query)

• Functor_21 (From Line 93)
• Functor_22 (From Line 53)

• Language_Location_Primer (Table)
• Ling_Dialogue_English (Table)
• Ling_Dialogue_Language (Table)

• Ling_English_Category_Extras (Table)
• Ling_Vocabulary_English (Table)

• Language_Location_Primer (Table)
• Ling_Vocabulary_English (Table)
• Ling_Vocabulary_Langauge (Table)

• Cross_Reference (Table)
• Maintainable_Archived_Objects (Table)
• Maintenance_Dates (Table)

• Convert_Webrefs (From Line 26)

• Cross_Reference (Table)
• Maintainable_Objects (Table)
• Maintenance_Dates (Table)

• Convert_Webrefs (From Line 29)

• Philosophers_Index (Table)
• Philosophers_Index_Identity (Table)

• Cross_Reference (Table)
• Missing_Webref_DisplayText_List_Editable (Table)
• Papers (Table)
• PID_Note_Reading_Lists (Table)
• Webrefs_Table (Table)

• New_Year_Crosstab_Prime_NewYear_SubList (Query)
• Reporting_Months (Table)
• Year_Crosstab_Prime (Table)

• Change_Of_Year (From Line 15)

• Timesheet_Old (Table)
• Year_Crosstab_Prime (Table)

• Change_Of_Year (From Line 14)

• Note_Alternates (Table)
• Notes (Table)

• cmdRecalculate_Click (From Line 125)

• Note_Book_Links (Table)
• Notes_Archive_Latest_Time (Query)

• Note_Book_Link_Latest_Add2 (Query)
• Note_Book_Links (Table)

• Note_Paper_Links (Table)
• Notes_Archive_Latest_Time (Query)

• Note_Paper_Link_Latest_Add2 (Query)
• Note_Paper_Links (Table)

• Note_Usage_Temp (Table)
• Note_Usage_Temp_MinLevel (Query)
• Note_Usage_Temp_Zapper (Table)

• NoteForPrinting (From Lines 174, 190)

• Note_Usage_Temp (Table)
• Note_Usage_Temp_MinLevel_Dups (Query)
• Note_Usage_Temp_Zapper (Table)

• NoteForPrinting (From Lines 177, 193)

• Notes_Archive (Table)
• Notes_Archive_Temp (Table)

• Archive_Notes (From Line 36)

• Notes_Cited_By_All_List (Table)
• Notes_Cited_By_All_List_Query (Query)

• cmdRecalculate_Click (From Line 49)

• Notes_to_Print (Table)
• Notes_to_Print_Add1 (Query)
• Useful_Lists (Table)

• cmdRecalculate_Click (From Line 187)

• Book_Papers_Full (Table)
• Cross_Reference (Table)
• Cross_Reference_Prelims (Table)

• Oboe_Latest_Lesson (Table)
• Oboe_Timesheet (Table)

• cmdRecalculate_Click (From Line 72)
• Oboe_Practice_Test (From Line 4)

• Oboe_Practice_Hours (Table)
• Oboe_Practice_Hours_Temp (Table)

• cmdRecalculate_Click (From Line 77)
• Oboe_Practice_Test (From Line 9)

• Oboe_Latest_Lesson (Table)
• Oboe_Practice_Hours_Temp_Dated (Table)
• Timesheet_20210930 (Table)

• cmdRecalculate_Click (From Line 84)
• Oboe_Practice_Test (From Line 16)

• Oboe_Latest_Lesson (Table)
• Oboe_Practice_Hours_Temp_Dated (Table)
• Timesheet (Table)

• cmdRecalculate_Click (From Lines 75, 83)
• Oboe_Practice_Test (From Lines 7, 15)

• Oboe_Latest_Lesson (Table)
• Oboe_Practice_Hours_Temp_Dated (Table)
• Timesheet_Last Year (Table)

• cmdRecalculate_Click (From Line 85)
• Oboe_Practice_Test (From Line 17)

• Oboe_Practice_Hours_Temp (Table)
• Oboe_Practice_Hours_Temp_Dated (Table)

• cmdRecalculate_Click (From Lines 76, 87)
• Oboe_Practice_Test (From Lines 8, 19)

• Cross_Reference_Changes (Table)
• Page_Regen (Table)

• cmdRecalculate_Click (From Line 230)

• Paper_Books (Table)
• Papers (Table)
• qryBooks (Query)

• cmdRecalculate_Click (From Line 200)

• Paper_Citings_List_New (Table)
• Paper_Citings_List_New_Query (Query)

• cmdRecalculate_Click (From Line 43)

• Paper_Summary (Table)
• Paper_Summary_Temp (Table)

• cmdArchivePaperSummaries_Click (From Line 8)

• Paper_Summary (Table)
• Paper_Summary_Temp (Table)
• Papers (Table)

• cmdArchivePaperSummaries_Click (From Line 6)
• CreatePaperSummariesWebPages (From Line 64)

• Current_ID (Table)
• Paper_Summary_Ranges (Table)
• Paper_Summary_Temp (Table)
• Papers (Table)

• CreatePaperSummariesWebPages (From Line 154)

• Paper_Summary_Temp (Table)
• Papers (Table)

• Paper_Summary_Temp (Table)
• Papers (Table)

• Paper_SubTopic_All (Query)
• Papers (Table)
• Papers - All - Categorised - Sub_Table (Table)
• Sub-Topics (Table)

• Cross_Reference_Prelims (Table)
• PapersToNotes_Prelims_GEN_List (Query)

• PapersToNotes_Prelims (From Line 5)

• Papers (Table)
• Philosophy Papers - All (Query)
• Philosophy Papers - All - Categorised (Query)
• Philosophy Papers - All - Categorised (Titles) (Query)
• Philosophy Papers - All - Categorised (Titles) - Solitons_Table (Table)
• Philosophy Papers - All - Categorised (Titles) - Solitons1 (Query)
• Philosophy Papers - All - Categorised (Titles)1 (Query)

• Papers (Table)
• Philosophy Papers - All (Query)
• Philosophy Papers - All - Categorised (Query)
• Philosophy Papers - All - Categorised (Titles) (Query)
• Philosophy Papers - All - Categorised (Titles) - Counter (Query)
• Philosophy Papers - All - Categorised (Titles) - Solitons (Query)
• Philosophy Papers - All - Categorised (Titles) - Top_Table (Table)
• Philosophy Papers - All - Categorised (Titles) - Top1 (Query)

• Papers (Table)
• Philosophy Papers - All (Query)
• Philosophy Papers - All - Categorised (Query)
• Philosophy Papers - All - Categorised (Titles) (Query)
• Philosophy Papers - All - Categorised (Titles) - Solitons (Query)
• Philosophy Papers - All - Categorised (Titles)_Table (Table)
• Philosophy Papers - All - Categorised (Titles)1 (Query)

• Paper_Subject_Topic_Subtopic_List (Query)
• Papers (Table)
• Philosophy Papers - All (Query)
• Philosophy Papers - All - Categorised_Table (Table)
• Subjects (Table)
• Sub-Topics (Table)
• Topics (Table)

• Photo_Raw_Excluded_Link_Keys (Table)
• Photos_Raw (Table)

• cmdTimelines_Click (From Line 47)
• Photo_Preparation (From Line 132)

• Photo_Raw_Excluded_Link_Keys (Table)
• Photos_Raw (Table)

• Photo_Preparation (From Line 146)

• Photo_Raw_Excluded_Link_Keys (Table)
• Photo_Type_Goup_Counts (Query)
• Photos_Raw (Table)

• cmdTimelines_Click (From Line 52)
• Photo_Preparation (From Line 123)

• Books (Table)
• Books_To_Regen (Table)

• Functor_21 (From Line 223)

• Papers (Table)
• PID_Missing_Online_Papers (Table)
• PID_Note_Reading_Lists (Table)
• Sub-Topics (Table)

• cmdRecalculate_Click (From Line 156)

• Notes (Table)
• PID_Missing_Online_Papers (Table)
• PID_Note_Reading_Lists (Table)

• Books (Table)
• Cross_Reference (Table)
• Notes (Table)
• PID_Note_Reading_Lists (Table)

• Functor_22 (From Line 50)

• Cross_Reference (Table)
• Notes (Table)
• Papers (Table)
• PID_Note_Reading_Lists (Table)

• Functor_22 (From Line 51)

• Next_Reporting_Month (Table)
• Project_Plans (Table)

• Change_Of_Year (From Line 16)

• Query_Definitions (Table)
• Query_Definitions_Historic (Table)

• Documentation_Generator (From Line 20)

• Raw_Links_Temp (Table)
• Raw_Links_Temp_Temp (Table)

• Notes_To_Regen (Table)
• Thesis_Note_XRef (Table)

• Raw_Broken_Links (Table)
• Raw_Broken_Links_Old (Table)

• Spider_Copy (From Line 105)

• Raw_Links (Table)
• Raw_Links_Temp (Table)

• Spider_Copy (From Line 56)

• Raw_Links (Table)
• Raw_Links_Temp (Table)
• Site_Map (Table)

• Spider_Copy (From Line 60)

• Site_Map (Table)
• Site_Map_Temp (Table)

• Spider_Copy (From Line 39)

• Raw_Broken_Links (Table)
• Raw_Links (Table)
• Site_Map (Table)

• Spider_Copy (From Line 108)

• Raw_Links (Table)
• WebLinkCheck (Table)

• Spider_WebLinks_Tester_Page_Gen (From Line 45)

• Language_Location_Primer (Table)
• Temp_Lang_Date_Last_Study (Table)
• Timesheet (Table)

• Functor_21 (From Line 74)

• Next_Reporting_Month (Table)
• PlanVsActual (Table)
• Time_By_Weekday_Prelist (Table)

• cmdRecalculate_Click (From Line 123)

• Next_Reporting_Month (Table)
• Time_This_Month_List (Table)
• Time_This_Month_List_Temp (Table)

• cmdMonthSummary_Click (From Line 49)

• Time_This_Month_List_Temp (Table)
• Timesheet (Table)

• cmdMonthSummary_Click (From Lines 31, 44)

• Next_Reporting_Month (Table)
• Time_This_Month_List (Table)
• Time_This_Month_List_Temp (Table)

• cmdMonthSummary_Click (From Line 36)

• Time_This_Month_Grand_Tots_New (Query)
• Time_This_Month_New (Table)
• Time_This_Month_Prelist1_New (Query)
• Time_This_Month_Tots_New (Query)

• Monthly_Report_Note975_Update (From Line 96)

• Timesheet (Table)
• Timesheet_Time_Outstanding (Table)

• Monthly_Report_Note980_Update (From Line 88)

• WebLinkCheck (Table)
• Webrefs_Table (Table)

• Webrefs_Table (Table)
• WebRefs_Translation (Table)

• Translate_Webrefs (From Line 16)

• Year_Crosstab (Table)
• Year_Crosstab_List (Table)

• Monthly_Reporting (From Line 11)

• Year_Crosstab (Table)
• Year_Crosstab_Prime (Table)

• Monthly_Reporting (From Line 10)

• Timesheet (Table)
• Year_Crosstab_List (Table)

• Monthly_Reporting (From Line 8)

• Year_Crosstab_List (Table)
• Year_Crosstab_List_Prime (Table)

• Monthly_Reporting (From Line 7)

• Year_Crosstab (Table)
• Year_Crosstab_Old (Table)

• Change_Of_Year (From Line 12)

• Year_Crosstab_Prime (Table)
• Year_Crosstab_Prime_Task_Periods (Query)