THEO TODMAN’S WEBSITE CODE PAGES


This Page provides a jumping-off point for the VBA Code that generates my Website.

Table of Query Documentation: Query-Type = Union (42 items)

Active_Notes_UnionAuthors_ChangedAuthors_Cited_By_All_List_QueryAuthors_List_Changed1
Authors_List1Bible_Latest_Verses_Read_2Bible_Reading_SummaryBook_Citings_List
Book_Citings_List_ChangedBook_Citings_List_Changed_NewBook_Citings_List_Changed1Book_Citings_List_New_Query
Book_Papers2Book_Subject_UnionBook_SubTopic_UnionBook_Topic_Union
Books_By_SubTopicCitations_Union1Citations_Union2Earliest_Lang_Dates
Identity_Papers_SubTopic_UnionLanguage_Animadversions_List3Ling_Language_Vocab_List_All_PrelistLing_Language_Vocab_Phrase_List_All_Prelist
Ling_Lesson_CountsNotes_Archive_Files_Checker_UnionNotes_Cited_By_All_List_QueryPaper_Citings_List
Paper_Citings_List_ChangedPaper_Citings_List_Changed_NewPaper_Citings_List_Changed1Paper_Citings_List_New_Query
Paper_Subject_UnionPaper_SubTopic_UnionPaper_Topic_UnionPapers_By_SubTopic
qryAuthors1qryPlanRestOfYearqrySourcesTime_By_Language_Locations_1
Website_Regen_Latest_ListWorks_Missing_By_Thesis_Chapter_Union..

To access information, click on one of the links in the table above.

Go to top of page

Query_Name: Active_Notes_Union
Query_Type: Union
Query_DateCreated: 22/02/2009 20:12:55
Query_DateChanged: 22/02/2009 20:15:33
Query_SQL: SELECT * from Active_Notes UNION ALL Select * from Active_Notes_Associations;
Link To Column Definitions: Active_Notes_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Authors_Changed
Query_Type: Union
Query_DateCreated: 28/06/2011 10:28:09
Query_DateChanged: 28/06/2011 10:31:08
Query_SQL: SELECT [Author_Name] from Book_Author_List_Changed1 UNION ALL Select [Author_Name] from Paper_Author_List_Changed1 GROUP BY [Author_Name] ORDER BY [Author_Name];
Link To Column Definitions: Authors_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Authors_Cited_By_All_List_Query
Query_Type: Union
Query_DateCreated: 09/09/2015 00:04:29
Query_DateChanged: 13/04/2020 15:12:03
Query_SQL: SELECT * FROM Authors_Cited_By_Papers_List UNION ALL SELECT * FROM Authors_Cited_By_Books_List UNION ALL SELECT * FROM Authors_Cited_By_Authors_List UNION ALL SELECT * FROM Authors_Cited_By_Notes_List;
Link To Column Definitions: Authors_Cited_By_All_List_Query

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Authors_List_Changed1
Query_Type: Union
Query_DateCreated: 26/06/2011 18:21:40
Query_DateChanged: 02/07/2011 13:55:29
Query_SQL: SELECT * from Book_Author_List_Changed UNION ALL Select * from Paper_Author_List_Changed ORDER BY [Author_Name], [Title], [Medium];
Link To Column Definitions: Authors_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Authors_List1
Query_Type: Union
Query_DateCreated: 25/06/2011 21:13:15
Query_DateChanged: 02/07/2011 13:55:13
Query_SQL: SELECT * from Book_Author_List UNION ALL Select * from Paper_Author_List ORDER BY [Author_Name], [Title], [Medium];
Link To Column Definitions: Authors_List1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Bible_Latest_Verses_Read_2
Query_Type: Union
Query_DateCreated: 14/11/2022 13:18:53
Query_DateChanged: 14/11/2022 13:21:27
Query_SQL: SELECT * FROM Bible_Latest_Verses_Read_1 UNION ALL SELECT * FROM Koran_Latest_Verses_Read;
Link To Column Definitions: Bible_Latest_Verses_Read_2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Bible_Reading_Summary
Query_Type: Union
Query_DateCreated: 14/11/2022 13:37:55
Query_DateChanged: 14/11/2022 13:37:55
Query_SQL: SELECT * FROM Bible_Reading_Summary_1 UNION ALL SELECT * FROM Koran_Reading_Summary;
Link To Column Definitions: Bible_Reading_Summary

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Citings_List
Query_Type: Union
Query_DateCreated: 26/06/2011 23:05:44
Query_DateChanged: 26/06/2011 23:07:42
Query_SQL: SELECT * from Book_Book_List UNION ALL Select * from Book_Paper_List ORDER BY [Book_ID], [Author], [Title], [Medium];
Link To Column Definitions: Book_Citings_List

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Citings_List_Changed
Query_Type: Union
Query_DateCreated: 27/06/2011 11:49:04
Query_DateChanged: 19/10/2013 18:18:03
Query_SQL: SELECT * from Book_Book_List_Changed UNION ALL Select * from Book_Paper_List_Changed ORDER BY [Book_ID], [Author], [Title], [Medium];
Link To Column Definitions: Book_Citings_List_Changed

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Citings_List_Changed_New
Query_Type: Union
Query_DateCreated: 28/08/2015 18:55:27
Query_DateChanged: 28/08/2015 18:56:57
Query_SQL: SELECT * from Book_Book_List_Changed_New UNION ALL Select * from Book_Paper_List_Changed_New ORDER BY [Book_ID], [Author], [Title], [Medium], [Calling_NameRef];
Link To Column Definitions: Book_Citings_List_Changed_New

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Citings_List_Changed1
Query_Type: Union
Query_DateCreated: 28/06/2011 11:57:34
Query_DateChanged: 28/06/2011 12:02:20
Query_SQL: SELECT [Book_ID] from Book_Book_List_Changed1 UNION ALL Select [Book_ID] from Book_Paper_List_Changed1 GROUP BY [Book_ID] ORDER BY [Book_ID];
Link To Column Definitions: Book_Citings_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Citings_List_New_Query
Query_Type: Union
Query_DateCreated: 28/08/2015 16:19:24
Query_DateChanged: 12/04/2020 19:31:22
Query_SQL: SELECT * from Book_Book_List_New UNION ALL Select * from Book_Paper_List_New ORDER BY [Book_ID], [Author], [Title], [Medium], [Calling_NameRef];
Link To Column Definitions: Book_Citings_List_New_Query

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Papers2
Query_Type: Union
Query_DateCreated: 26/01/2009 19:54:23
Query_DateChanged: 26/01/2009 19:54:40
Query_SQL: SELECT * from Book_Papers UNION ALL Select * from Book_Papers1;
Link To Column Definitions: Book_Papers2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Subject_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 14:45:07
Query_DateChanged: 12/04/2009 14:46:16
Query_SQL: SELECT * from Book_Subject1 UNION ALL Select * from Book_Subject2 UNION ALL Select * from Book_Subject3;
Link To Column Definitions: Book_Subject_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_SubTopic_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 16:30:15
Query_DateChanged: 12/04/2009 16:30:43
Query_SQL: SELECT * from Book_SubTopic1 UNION ALL Select * from Book_SubTopic2 UNION ALL Select * from Book_SubTopic3;
Link To Column Definitions: Book_SubTopic_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Book_Topic_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 14:52:02
Query_DateChanged: 12/04/2009 14:52:51
Query_SQL: SELECT * from Book_Topic1 UNION ALL Select * from Book_Topic2 UNION ALL Select * from Book_Topic3;
Link To Column Definitions: Book_Topic_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Books_By_SubTopic
Query_Type: Union
Query_DateCreated: 27/07/2009 11:29:51
Query_DateChanged: 27/07/2009 11:29:51
Query_SQL: SELECT * from Books_By_SubTopic1 UNION ALL Select * from Books_By_SubTopic2 UNION ALL Select * from Books_By_SubTopic3;
Link To Column Definitions: Books_By_SubTopic

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Citations_Union1
Query_Type: Union
Query_DateCreated: 01/11/2007 10:23:15
Query_DateChanged: 12/11/2007 17:09:25
Query_SQL: SELECT * from Books_Cited UNION ALL Select * from Papers_Cited UNION ALL Select * from Papers_By_SubTopic UNION ALL Select * from Books_By_SubTopic UNION ALL Select * from Books_from_Papers_By_Subtopic UNION ALL Select * from Books_from_Papers_Cited;
Link To Column Definitions: Citations_Union1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Citations_Union2
Query_Type: Union
Query_DateCreated: 10/09/2009 22:54:53
Query_DateChanged: 10/09/2009 22:55:25
Query_SQL: SELECT * from Books_Cited UNION ALL Select * from Papers_Cited UNION ALL Select * from Books_from_Papers_Cited;
Link To Column Definitions: Citations_Union2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Earliest_Lang_Dates
Query_Type: Union
Query_DateCreated: 11/12/2020 12:53:12
Query_DateChanged: 02/03/2022 19:51:50
Query_SQL: SELECT * from Earliest_Lang_Dates_Ling UNION ALL Select * from Earliest_Lang_Dates_Non_Ling ORDER BY [Category], [Priority], [Date], [Language];
Link To Column Definitions: Earliest_Lang_Dates

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Identity_Papers_SubTopic_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 18:39:31
Query_DateChanged: 12/04/2009 18:40:41
Query_SQL: SELECT * from Identity_Papers_SubTopic1 UNION ALL Select * from Identity_Papers_SubTopic2 UNION ALL Select * from Identity_Papers_SubTopic3;
Link To Column Definitions: Identity_Papers_SubTopic_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Language_Animadversions_List3
Query_Type: Union
Query_DateCreated: 28/10/2020 21:14:17
Query_DateChanged: 28/10/2020 23:31:39
Query_SQL: SELECT * from Language_Animadversions_List1 UNION ALL Select * from Language_Animadversions_List2 ORDER BY [Language], [Date Raised];
Link To Column Definitions: Language_Animadversions_List3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Ling_Language_Vocab_List_All_Prelist
Query_Type: Union
Query_DateCreated: 03/06/2021 17:35:18
Query_DateChanged: 03/06/2021 17:39:15
Query_SQL: SELECT * FROM Ling_Language_Vocab_List_All_Prelist_1 UNION ALL SELECT * FROM Ling_Language_Vocab_List_All_Prelist_2;
Link To Column Definitions: Ling_Language_Vocab_List_All_Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Ling_Language_Vocab_Phrase_List_All_Prelist
Query_Type: Union
Query_DateCreated: 03/06/2021 18:29:21
Query_DateChanged: 11/06/2021 23:49:28
Query_SQL: SELECT * FROM Ling_Language_Vocab_Phrase_List_All_Prelist_1 UNION ALL SELECT * FROM Ling_Language_Vocab_Phrase_List_All_Prelist_2;
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Ling_Lesson_Counts
Query_Type: Union
Query_DateCreated: 13/04/2021 23:45:26
Query_DateChanged: 13/04/2021 23:45:55
Query_SQL: SELECT * FROM Ling_Vocab_Lesson_Counts UNION ALL SELECT * FROM Ling_Dialogue_Lesson_Counts;
Link To Column Definitions: Ling_Lesson_Counts

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Notes_Archive_Files_Checker_Union
Query_Type: Union
Query_DateCreated: 10/07/2015 13:16:23
Query_DateChanged: 10/07/2015 13:18:01
Query_SQL: SELECT * FROM Notes_Archive_Files_Checker_1 UNION ALL Select * FROM Notes_Archive_Files_Checker_2;
Link To Column Definitions: Notes_Archive_Files_Checker_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Notes_Cited_By_All_List_Query
Query_Type: Union
Query_DateCreated: 05/09/2015 10:01:03
Query_DateChanged: 13/04/2020 15:56:19
Query_SQL: SELECT * FROM Notes_Cited_By_Papers_List UNION ALL SELECT * FROM Notes_Cited_By_Books_List UNION ALL SELECT * FROM Notes_Cited_By_Authors_List;
Link To Column Definitions: Notes_Cited_By_All_List_Query

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Citings_List
Query_Type: Union
Query_DateCreated: 27/06/2011 13:12:52
Query_DateChanged: 27/06/2011 13:13:24
Query_SQL: SELECT * from Paper_Book_List UNION ALL Select * from Paper_Paper_List ORDER BY [Paper_ID], [Author], [Title], [Medium];
Link To Column Definitions: Paper_Citings_List

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Citings_List_Changed
Query_Type: Union
Query_DateCreated: 27/06/2011 13:13:51
Query_DateChanged: 27/06/2011 13:14:07
Query_SQL: SELECT * from Paper_Book_List_Changed UNION ALL Select * from Paper_Paper_List_Changed ORDER BY [Paper_ID], [Author], [Title], [Medium];
Link To Column Definitions: Paper_Citings_List_Changed

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Citings_List_Changed_New
Query_Type: Union
Query_DateCreated: 30/08/2015 16:39:14
Query_DateChanged: 30/08/2015 16:40:52
Query_SQL: SELECT * from Paper_Book_List_Changed_New UNION ALL Select * from Paper_Paper_List_Changed_New ORDER BY [Paper_ID], [Author], [Title], [Medium], [Calling_NameRef];
Link To Column Definitions: Paper_Citings_List_Changed_New

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Citings_List_Changed1
Query_Type: Union
Query_DateCreated: 28/06/2011 14:39:39
Query_DateChanged: 28/06/2011 14:40:24
Query_SQL: SELECT [Paper_ID] from Paper_Book_List_Changed1 UNION ALL Select [Paper_ID] from Paper_Paper_List_Changed1 GROUP BY [Paper_ID] ORDER BY [Paper_ID];
Link To Column Definitions: Paper_Citings_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Citings_List_New_Query
Query_Type: Union
Query_DateCreated: 30/08/2015 16:38:57
Query_DateChanged: 12/04/2020 15:01:04
Query_SQL: SELECT * from Paper_Book_List_New UNION ALL Select * from Paper_Paper_List_New ORDER BY [Paper_ID], [Author], [Title], [Medium], [Calling_NameRef];
Link To Column Definitions: Paper_Citings_List_New_Query

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Subject_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 16:54:29
Query_DateChanged: 12/04/2009 16:54:44
Query_SQL: SELECT * from Paper_Subject1 UNION ALL Select * from Paper_Subject2 UNION ALL Select * from Paper_Subject3;
Link To Column Definitions: Paper_Subject_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_SubTopic_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 17:06:28
Query_DateChanged: 04/12/2011 18:39:08
Query_SQL: SELECT * from Paper_SubTopic1 UNION ALL Select * from Paper_SubTopic2 UNION ALL Select * from Paper_SubTopic3 UNION ALL Select * from SubTopic_From_Topic1 UNION ALL Select * from SubTopic_From_Topic2 UNION ALL Select * from SubTopic_From_Topic3;
Link To Column Definitions: Paper_SubTopic_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Paper_Topic_Union
Query_Type: Union
Query_DateCreated: 12/04/2009 16:58:08
Query_DateChanged: 12/04/2009 16:58:19
Query_SQL: SELECT * from Paper_Topic1 UNION ALL Select * from Paper_Topic2 UNION ALL Select * from Paper_Topic3;
Link To Column Definitions: Paper_Topic_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Papers_By_SubTopic
Query_Type: Union
Query_DateCreated: 27/07/2009 11:30:11
Query_DateChanged: 27/07/2009 11:30:26
Query_SQL: SELECT * from Papers_By_SubTopic1 UNION ALL Select * from Papers_By_SubTopic2 UNION ALL Select * from Papers_By_SubTopic3;
Link To Column Definitions: Papers_By_SubTopic

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: qryAuthors1
Query_Type: Union
Query_DateCreated: 30/05/2005 18:11:18
Query_DateChanged: 13/06/2005 21:54:40
Query_SQL: SELECT [Author] from qryAuthorsBooks UNION ALL Select [Author] from qryAuthorsPapers GROUP BY [Author] ORDER BY [Author];
Link To Column Definitions: qryAuthors1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: qryPlanRestOfYear
Query_Type: Union
Query_DateCreated: 05/07/2013 23:10:35
Query_DateChanged: 05/07/2013 23:10:36
Query_SQL: SELECT * FROM qryPlanRestOfYear1 UNION ALL SELECT * FROM qryPlanRestOfYear2;
Link To Column Definitions: qryPlanRestOfYear

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: qrySources
Query_Type: Union
Query_DateCreated: 30/05/2005 17:55:00
Query_DateChanged: 31/05/2005 07:13:06
Query_SQL: SELECT * from qryBooks UNION ALL Select * from qryPapers WHERE [A+T] <> " - " ORDER BY [A+T];
Link To Column Definitions: qrySources

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Time_By_Language_Locations_1
Query_Type: Union
Query_DateCreated: 30/10/2009 11:03:34
Query_DateChanged: 30/10/2009 11:04:43
Query_SQL: SELECT * from Time_By_Language_Locations_Current UNION ALL Select * from Language_Location_Primer;
Link To Column Definitions: Time_By_Language_Locations_1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Website_Regen_Latest_List
Query_Type: Union
Query_DateCreated: 19/05/2018 21:44:00
Query_DateChanged: 20/05/2018 00:13:58
Query_SQL: SELECT * from BookPaperControl_Latest UNION ALL Select * from Author_Letters_Latest UNION ALL Select * from Book_Summary_Ranges_Latest UNION ALL Select * from Paper_Summary_Ranges_Latest UNION ALL Select * from BookPaperLinks_Ranges_Latest UNION ALL Select * from BookPaperAbstract_Ranges_Latest UNION ALL Select * from Paper_Abstract_Ranges_Latest UNION ALL Select * from Note_Regen_Ranges_Latest UNION ALL Select * from Note_Archive_Regen_Ranges_Latest;
Link To Column Definitions: Website_Regen_Latest_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page

Query_Name: Works_Missing_By_Thesis_Chapter_Union
Query_Type: Union
Query_DateCreated: 11/03/2021 20:03:11
Query_DateChanged: 11/03/2021 20:15:50
Query_SQL: SELECT * FROM Papers_Missing_By_Thesis_Chapter UNION ALL SELECT * FROM Books_Missing_By_Thesis_Chapter;
Link To Column Definitions: Works_Missing_By_Thesis_Chapter_Union

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page



© Theo Todman, June 2007 - March 2026. Please address any comments on this page to theo@theotodman.com. File output:
Website Maintenance Dashboard
Return to Top of this Page Return to Theo Todman's Philosophy Page Return to Theo Todman's Home Page