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 = Delete (40 items)

Abstracts_Archive_Temp_ZapAbstracts_Archive_ZapActual_Hours_Temp_ZapAuthors_List_Authors_Table_Zap
Authors_List_Letter_Table_ZapBackup_Directory_Structure_PruneBackup_Site_Map_PruneBook_Abstracts_Archive_Temp_Zap
Book_Abstracts_Archive_ZapBook_Location_Stats_Temp_ZapBook_Paper_Solitons_PruneBook_Paper_Solitons_Zap
Book_Paper_Solitons_Zapper_ZapBook_Papers_Full_ZapBook_Summary_Temp_ZapBook_Summary_Zap
Cross_Reference_Idempotency_ZapDirectory_Structure_PruneHits_Bots_By_URL_Key_ZapHits_Bots_Total_Zap
Hits_Pages_Total_ZapNew_Year_Crosstab_Prime_ZapNote_Usage_Temp_ZapNote_Usage_Temp_Zapper_Zap
Notes_Archive_Temp_ZapOboe_Latest_Lesson_ZapOboe_Practice_Hours_Temp_Dated_Last_Lesson_PruneOboe_Practice_Hours_Temp_Dated_Zap
Oboe_Practice_Hours_Temp_ZapPaper_Books_ZapPaper_Summary_Temp_ZapPaper_Summary_Zap
Raw_Broken_Links_Old_ZapRaw_Broken_Links_ZapRaw_Links_ZapTime_This_Month_List_Temp_Zap
Time_This_Month_List_ZapYear_Crosstab_List_ZapYear_Crosstab_Old_ZapYear_Crosstab_Zap

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

Go to top of page

Query_Name: Abstracts_Archive_Temp_Zap
Query_Type: Delete
Query_DateCreated: 18/05/2007 00:13:09
Query_DateChanged: 18/05/2007 00:13:09
Query_SQL: DELETE Abstracts_Archive_Temp.* FROM Abstracts_Archive_Temp;
Link To Column Definitions: Abstracts_Archive_Temp_Zap

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


Query_Name: Abstracts_Archive_Zap
Query_Type: Delete
Query_DateCreated: 17/05/2007 20:47:22
Query_DateChanged: 17/05/2007 20:47:22
Query_SQL: DELETE Abstracts_Archive.* FROM Abstracts_Archive INNER JOIN Abstracts_Archive_Temp ON Abstracts_Archive.ID = Abstracts_Archive_Temp.ID;
Link To Column Definitions: Abstracts_Archive_Zap

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


Query_Name: Actual_Hours_Temp_Zap
Query_Type: Delete
Query_DateCreated: 15/07/2013 22:13:21
Query_DateChanged: 15/07/2013 22:13:21
Query_SQL: DELETE Actual_Hours_Temp.* FROM Actual_Hours_Temp;
Link To Column Definitions: Actual_Hours_Temp_Zap

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


Query_Name: Authors_List_Authors_Table_Zap
Query_Type: Delete
Query_DateCreated: 13/05/2014 22:44:55
Query_DateChanged: 13/05/2014 22:44:55
Query_SQL: DELETE Authors_List_Authors_Table.* FROM Authors_List_Authors_Table;
Link To Column Definitions: Authors_List_Authors_Table_Zap

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


Query_Name: Authors_List_Letter_Table_Zap
Query_Type: Delete
Query_DateCreated: 13/05/2014 20:20:30
Query_DateChanged: 13/05/2014 20:20:30
Query_SQL: DELETE Authors_List_Letter_Table.* FROM Authors_List_Letter_Table;
Link To Column Definitions: Authors_List_Letter_Table_Zap

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


Query_Name: Backup_Directory_Structure_Prune
Query_Type: Delete
Query_DateCreated: 16/05/2014 19:36:41
Query_DateChanged: 07/06/2014 10:16:56
Query_SQL: DELETE Backup_Directory_Structure.* FROM Backup_Directory_Structure INNER JOIN Backup_Directory_Structure_Zapper ON Backup_Directory_Structure.Directory = Backup_Directory_Structure_Zapper.Directory;
Link To Column Definitions: Backup_Directory_Structure_Prune

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


Query_Name: Backup_Site_Map_Prune
Query_Type: Delete
Query_DateCreated: 18/05/2014 10:04:57
Query_DateChanged: 23/05/2014 18:23:45
Query_SQL: DELETE Backup_Site_Map.* FROM Backup_Site_Map INNER JOIN Backup_Site_Map_Zapper ON (Backup_Site_Map.FIle_Name = Backup_Site_Map_Zapper.FIle_Name) AND (Backup_Site_Map.Directory = Backup_Site_Map_Zapper.Directory);
Link To Column Definitions: Backup_Site_Map_Prune

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


Query_Name: Book_Abstracts_Archive_Temp_Zap
Query_Type: Delete
Query_DateCreated: 23/05/2014 13:16:39
Query_DateChanged: 23/05/2014 13:19:45
Query_SQL: DELETE Book_Abstracts_Archive_Temp.* FROM Book_Abstracts_Archive_Temp;
Link To Column Definitions: Book_Abstracts_Archive_Temp_Zap

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


Query_Name: Book_Abstracts_Archive_Zap
Query_Type: Delete
Query_DateCreated: 23/05/2014 13:29:34
Query_DateChanged: 23/05/2014 13:30:47
Query_SQL: DELETE Book_Abstracts_Archive.* FROM Book_Abstracts_Archive INNER JOIN Book_Abstracts_Archive_Temp ON Book_Abstracts_Archive.ID1 = Book_Abstracts_Archive_Temp.ID1;
Link To Column Definitions: Book_Abstracts_Archive_Zap

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


Query_Name: Book_Location_Stats_Temp_Zap
Query_Type: Delete
Query_DateCreated: 27/04/2013 11:53:29
Query_DateChanged: 27/04/2013 11:53:29
Query_SQL: DELETE Book_Location_Stats_Temp.* FROM Book_Location_Stats_Temp;
Link To Column Definitions: Book_Location_Stats_Temp_Zap

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


Query_Name: Book_Paper_Solitons_Prune
Query_Type: Delete
Query_DateCreated: 06/08/2019 12:43:48
Query_DateChanged: 06/08/2019 13:15:00
Query_SQL: DELETE Book_Paper_Solitons.* FROM Book_Paper_Solitons INNER JOIN Book_Paper_Solitons_Zapper ON Book_Paper_Solitons.Book_ID = Book_Paper_Solitons_Zapper.Book_ID;
Link To Column Definitions: Book_Paper_Solitons_Prune

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


Query_Name: Book_Paper_Solitons_Zap
Query_Type: Delete
Query_DateCreated: 29/03/2013 12:00:38
Query_DateChanged: 29/03/2013 12:00:38
Query_SQL: DELETE Book_Paper_Solitons.* FROM Book_Paper_Solitons;
Link To Column Definitions: Book_Paper_Solitons_Zap

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


Query_Name: Book_Paper_Solitons_Zapper_Zap
Query_Type: Delete
Query_DateCreated: 06/08/2019 12:39:26
Query_DateChanged: 06/08/2019 12:39:26
Query_SQL: DELETE Book_Paper_Solitons_Zapper.Book_ID FROM Book_Paper_Solitons_Zapper;
Link To Column Definitions: Book_Paper_Solitons_Zapper_Zap

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


Query_Name: Book_Papers_Full_Zap
Query_Type: Delete
Query_DateCreated: 22/02/2009 16:02:05
Query_DateChanged: 22/02/2009 16:02:49
Query_SQL: DELETE Book_Papers_Full.* FROM Book_Papers_Full;
Link To Column Definitions: Book_Papers_Full_Zap

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


Query_Name: Book_Summary_Temp_Zap
Query_Type: Delete
Query_DateCreated: 25/06/2007 10:00:07
Query_DateChanged: 25/06/2007 10:00:07
Query_SQL: DELETE Book_Summary_Temp.* FROM Book_Summary_Temp;
Link To Column Definitions: Book_Summary_Temp_Zap

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


Query_Name: Book_Summary_Zap
Query_Type: Delete
Query_DateCreated: 25/06/2007 15:35:56
Query_DateChanged: 25/06/2007 15:36:43
Query_SQL: DELETE Book_Summary.* FROM Book_Summary INNER JOIN Book_Summary_Temp ON Book_Summary.ID = Book_Summary_Temp.ID;
Link To Column Definitions: Book_Summary_Zap

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


Query_Name: Cross_Reference_Idempotency_Zap
Query_Type: Delete
Query_DateCreated: 28/08/2015 15:55:19
Query_DateChanged: 28/08/2015 16:00:40
Query_SQL: DELETE Cross_Reference.*, Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Called_Type FROM Cross_Reference WHERE (((Cross_Reference.Calling_Type)=[Called_Type]) AND ((Cross_Reference.Calling_ID)=[Called_ID]) AND ((Cross_Reference.Called_Type)<>"N"));
Link To Column Definitions: Cross_Reference_Idempotency_Zap

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


Query_Name: Directory_Structure_Prune
Query_Type: Delete
Query_DateCreated: 25/06/2013 18:49:04
Query_DateChanged: 25/06/2013 18:49:04
Query_SQL: DELETE Directory_Structure.*, Directory_Structure.Do_Not_Parse, Directory_Structure_Temp.Directory, Directory_Structure.Directory_Level FROM Directory_Structure LEFT JOIN Directory_Structure_Temp ON Directory_Structure.Directory = Directory_Structure_Temp.Directory WHERE (((Directory_Structure.Do_Not_Parse)="No") AND ((Directory_Structure_Temp.Directory) Is Null) AND ((Directory_Structure.Directory_Level)>0));
Link To Column Definitions: Directory_Structure_Prune

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


Query_Name: Hits_Bots_By_URL_Key_Zap
Query_Type: Delete
Query_DateCreated: 08/10/2020 00:41:27
Query_DateChanged: 08/10/2020 00:51:09
Query_SQL: DELETE Hits_Bots_By_URL_Key.* FROM Hits_Bots_By_URL_Key;
Link To Column Definitions: Hits_Bots_By_URL_Key_Zap

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


Query_Name: Hits_Bots_Total_Zap
Query_Type: Delete
Query_DateCreated: 26/07/2019 18:06:27
Query_DateChanged: 26/07/2019 18:06:27
Query_SQL: DELETE Hits_Bots_Total.* FROM Hits_Bots_Total;
Link To Column Definitions: Hits_Bots_Total_Zap

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


Query_Name: Hits_Pages_Total_Zap
Query_Type: Delete
Query_DateCreated: 26/07/2019 18:06:27
Query_DateChanged: 26/07/2019 18:06:27
Query_SQL: DELETE Hits_Pages_Total.* FROM Hits_Pages_Total;
Link To Column Definitions: Hits_Pages_Total_Zap

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


Query_Name: New_Year_Crosstab_Prime_Zap
Query_Type: Delete
Query_DateCreated: 03/10/2010 17:41:40
Query_DateChanged: 01/10/2025 17:32:23
Query_SQL: DELETE Year_Crosstab_Prime.Period, Year_Crosstab_Prime.* FROM Year_Crosstab_Prime WHERE (((Year_Crosstab_Prime.Period) Like "2024-*" Or (Year_Crosstab_Prime.Period) Like "2025-*" Or (Year_Crosstab_Prime.Period) Like "2024/*" Or (Year_Crosstab_Prime.Period) Like "2025/*"));
Link To Column Definitions: New_Year_Crosstab_Prime_Zap

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


Query_Name: Note_Usage_Temp_Zap
Query_Type: Delete
Query_DateCreated: 19/08/2007 17:13:29
Query_DateChanged: 19/08/2007 17:13:29
Query_SQL: DELETE Note_Usage_Temp.* FROM Note_Usage_Temp INNER JOIN Note_Usage_Temp_Zapper ON (Note_Usage_Temp.Note_Usage = Note_Usage_Temp_Zapper.Note_Usage) AND (Note_Usage_Temp.Note_ID = Note_Usage_Temp_Zapper.Note_ID);
Link To Column Definitions: Note_Usage_Temp_Zap

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


Query_Name: Note_Usage_Temp_Zapper_Zap
Query_Type: Delete
Query_DateCreated: 19/08/2007 17:14:09
Query_DateChanged: 19/08/2007 17:14:09
Query_SQL: DELETE Note_Usage_Temp_Zapper.* FROM Note_Usage_Temp_Zapper;
Link To Column Definitions: Note_Usage_Temp_Zapper_Zap

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


Query_Name: Notes_Archive_Temp_Zap
Query_Type: Delete
Query_DateCreated: 18/06/2007 13:19:03
Query_DateChanged: 18/06/2007 13:19:03
Query_SQL: DELETE Notes_Archive_Temp.* FROM Notes_Archive_Temp;
Link To Column Definitions: Notes_Archive_Temp_Zap

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


Query_Name: Oboe_Latest_Lesson_Zap
Query_Type: Delete
Query_DateCreated: 06/10/2019 16:02:32
Query_DateChanged: 06/10/2019 16:02:43
Query_SQL: DELETE Oboe_Latest_Lesson.* FROM Oboe_Latest_Lesson;
Link To Column Definitions: Oboe_Latest_Lesson_Zap

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


Query_Name: Oboe_Practice_Hours_Temp_Dated_Last_Lesson_Prune
Query_Type: Delete
Query_DateCreated: 06/10/2019 16:23:35
Query_DateChanged: 11/10/2019 23:16:55
Query_SQL: DELETE Oboe_Practice_Hours_Temp_Dated.*, Oboe_Practice_Hours_Temp_Dated.Practice_Date, Oboe_Practice_Hours.[Not_Since_Last_Lesson?] FROM Oboe_Practice_Hours_Temp_Dated INNER JOIN Oboe_Practice_Hours ON (Oboe_Practice_Hours_Temp_Dated.Topic = Oboe_Practice_Hours.Topic) AND (Oboe_Practice_Hours_Temp_Dated.Subject = Oboe_Practice_Hours.Subject) WHERE (((Oboe_Practice_Hours_Temp_Dated.Practice_Date)<[Latest_Lesson])) OR (((Oboe_Practice_Hours.[Not_Since_Last_Lesson?])=Yes));
Link To Column Definitions: Oboe_Practice_Hours_Temp_Dated_Last_Lesson_Prune

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


Query_Name: Oboe_Practice_Hours_Temp_Dated_Zap
Query_Type: Delete
Query_DateCreated: 06/10/2019 17:25:22
Query_DateChanged: 06/10/2019 17:25:49
Query_SQL: DELETE Oboe_Practice_Hours_Temp_Dated.* FROM Oboe_Practice_Hours_Temp_Dated;
Link To Column Definitions: Oboe_Practice_Hours_Temp_Dated_Zap

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


Query_Name: Oboe_Practice_Hours_Temp_Zap
Query_Type: Delete
Query_DateCreated: 04/10/2019 18:31:12
Query_DateChanged: 04/10/2019 18:31:12
Query_SQL: DELETE Oboe_Practice_Hours_Temp.* FROM Oboe_Practice_Hours_Temp;
Link To Column Definitions: Oboe_Practice_Hours_Temp_Zap

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


Query_Name: Paper_Books_Zap
Query_Type: Delete
Query_DateCreated: 17/11/2007 17:05:59
Query_DateChanged: 17/11/2007 17:05:59
Query_SQL: DELETE Paper_Books.* FROM Paper_Books;
Link To Column Definitions: Paper_Books_Zap

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


Query_Name: Paper_Summary_Temp_Zap
Query_Type: Delete
Query_DateCreated: 09/06/2007 17:05:47
Query_DateChanged: 09/06/2007 17:05:47
Query_SQL: DELETE Paper_Summary_Temp.* FROM Paper_Summary_Temp;
Link To Column Definitions: Paper_Summary_Temp_Zap

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


Query_Name: Paper_Summary_Zap
Query_Type: Delete
Query_DateCreated: 09/06/2007 16:59:38
Query_DateChanged: 09/06/2007 17:06:15
Query_SQL: DELETE Paper_Summary.* FROM Paper_Summary INNER JOIN Paper_Summary_Temp ON Paper_Summary.ID = Paper_Summary_Temp.ID;
Link To Column Definitions: Paper_Summary_Zap

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


Query_Name: Raw_Broken_Links_Old_Zap
Query_Type: Delete
Query_DateCreated: 18/08/2018 11:53:48
Query_DateChanged: 18/08/2018 11:54:31
Query_SQL: DELETE Raw_Broken_Links_Old.* FROM Raw_Broken_Links_Old;
Link To Column Definitions: Raw_Broken_Links_Old_Zap

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


Query_Name: Raw_Broken_Links_Zap
Query_Type: Delete
Query_DateCreated: 16/08/2018 13:40:20
Query_DateChanged: 16/08/2018 13:40:21
Query_SQL: DELETE Raw_Broken_Links.* FROM Raw_Broken_Links;
Link To Column Definitions: Raw_Broken_Links_Zap

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


Query_Name: Raw_Links_Zap
Query_Type: Delete
Query_DateCreated: 13/09/2014 17:49:18
Query_DateChanged: 13/09/2014 17:49:19
Query_SQL: DELETE Raw_Links.*, Site_Map_Temp.[Processed_This_Run?] FROM Site_Map_Temp INNER JOIN Raw_Links ON (Site_Map_Temp.FIle_Name = Raw_Links.File_Name) AND (Site_Map_Temp.Directory = Raw_Links.Directory) WHERE (((Site_Map_Temp.[Processed_This_Run?])=True));
Link To Column Definitions: Raw_Links_Zap

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


Query_Name: Time_This_Month_List_Temp_Zap
Query_Type: Delete
Query_DateCreated: 22/12/2010 14:03:52
Query_DateChanged: 22/12/2010 14:03:52
Query_SQL: DELETE Time_This_Month_List_Temp.* FROM Time_This_Month_List_Temp;
Link To Column Definitions: Time_This_Month_List_Temp_Zap

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


Query_Name: Time_This_Month_List_Zap
Query_Type: Delete
Query_DateCreated: 16/01/2010 11:09:43
Query_DateChanged: 16/01/2010 11:09:43
Query_SQL: DELETE Time_This_Month_List.* FROM Time_This_Month_List;
Link To Column Definitions: Time_This_Month_List_Zap

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


Query_Name: Year_Crosstab_List_Zap
Query_Type: Delete
Query_DateCreated: 24/10/2009 13:34:45
Query_DateChanged: 24/10/2009 13:34:45
Query_SQL: DELETE Year_Crosstab_List.* FROM Year_Crosstab_List;
Link To Column Definitions: Year_Crosstab_List_Zap

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


Query_Name: Year_Crosstab_Old_Zap
Query_Type: Delete
Query_DateCreated: 02/10/2019 22:01:32
Query_DateChanged: 02/10/2019 22:01:32
Query_SQL: DELETE Year_Crosstab_Old.* FROM Year_Crosstab_Old;
Link To Column Definitions: Year_Crosstab_Old_Zap

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


Query_Name: Year_Crosstab_Zap
Query_Type: Delete
Query_DateCreated: 05/10/2008 18:52:21
Query_DateChanged: 05/10/2008 19:09:42
Query_SQL: DELETE Year_Crosstab.* FROM Year_Crosstab;
Link To Column Definitions: Year_Crosstab_Zap

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





© Theo Todman, June 2007 - July 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