> ## Content Index > Fetch the complete content index at: https://nolongerset.com/llms.txt > Use this file to discover other available public pages before exploring further. # Week in Review: October 18, 2025 - URL: https://nolongerset.com/week-in-review-2025-10-18/ - Published: 2025-10-18T21:45:58.000Z - Updated: 2026-05-08T12:47:14.000Z - Description: Highlights include a class module for exporting to Excel, entering Excel-style equations in any Access text box, and a function for sorting continuous form columns. - Author: Mike Wolfe - Tags: Week in Review, #Import 2026-05-20 02:59 ## Just Published This section includes videos, articles, and (occasionally) open-source project updates from the past 7 days. #### Articles \* *Article descriptions generated by Claude-Sonnet-4.* - **John Mallinson** ([The VBA Help](https://www.thevbahelp.com/blog)) - [Consts to Enum / Enum to Consts](https://www.thevbahelp.com/post/consts-to-enum-enum-to-consts): *VBE\_Extras now converts between individual Const declarations and Enum types, particularly useful when working with Windows API constants.* - [Using GDI+ to draw lines, fill shapes and write text on a UserForm](https://www.thevbahelp.com/post/using-gdiplus-to-draw-lines-fill-shapes-and-write-text-on-a-userform): *A comprehensive guide to using the Windows GDI+ API for drawing graphics on UserForms, including a CGdiPlusUtils class that simplifies the initialization and usage process.* - **Jonathan Halder** ([Access JumpStart 2.0](https://www.accessjumpstart.com/blog/)) - [Building Excel VBA with CoPilot](https://www.accessjumpstart.com/85274-2/): *A detailed walkthrough of using Microsoft CoPilot to build Excel VBA macros for custom sorting and CSV file import automation.* - [HAL\_Excel class module for exporting data to an Excel Spreadsheet](https://www.accessjumpstart.com/hal%5Fexcel-class-module-for-exporting-data-to-an-excel-spreadsheet/): *A class module library for exporting Access queries and tables to Excel templates using late binding to avoid version compatibility issues.* - [MZ-Tools Find and Replace carriage returns (new lines)](https://www.accessjumpstart.com/mz-tools-find-and-replace-carriage-returns-new-lines/): *How to use MZ-Tools' regular expression find and replace feature to convert SQL statements into properly formatted VBA string concatenations.* - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Throwback Thursday: October 16, 2025](https://nolongerset.com/throwback-thursday-2025-10-16/): *A retrospective featuring the popular NewSort() function for enabling user-sortable columns in Access continuous forms by clicking column labels.* #### Videos‌ - **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD)) - [Quick Queries #62](https://www.youtube.com/watch?v=XD2zRSAbHRw) (33:52): *Important Missing Index That Could Be Killing Your Microsoft Access Performance* - **Microsoft Access Fitness Database**: - [Fitness Part #49](https://www.youtube.com/watch?v=PR8jzOc9omk) (17:12): *How to Enter Excel-Style Equations in Any Text Box in Microsoft Access* - [Fitness Part #50](https://www.youtube.com/watch?v=DT07dhc5Bis) (12:36): *How to Calculate Totals for Checked Items Automatically in Microsoft Access* - [Fitness Part #51](https://www.youtube.com/watch?v=kgJQltsHUto) (17:48): *Implement Click & Shift-Click to Select Contiguous Records in Microsoft Access* - **David Britz \[David's Database and Coding Channel\]** ([YouTube channel](https://www.youtube.com/@dbritzdata)) - [Access Series Episode 7](https://www.youtube.com/watch?v=Nbzy3kj1AjA) (16:00): *Access Series Episode 7* --- ## New to Me This section includes content I discovered this week that has been around for a while. - *Nothing new this week.* --- ## Upcoming Access User Group Events NOTE: Only English-language user group meetings with scheduled guest speakers or topics are listed. For a complete list of upcoming events, visit the [Access User Group event calendar](https://accessusergroups.org/calendar/). Not all links below include the start time and time zone. For that information, check out this handy reference guide from Access MVP Maria Barnes over at AccessForever.org: [Access User Groups 2025](https://www.accessforever.org/post/access-user-groups-2025). - \[[October 28, 2025\]](https://accessusergroups.org/lunch/event/access-lunchtime-5-2025-10-28/) **Colin Riddington**: A Masterclass in Access Security - \[[November 5, 2025](https://accessusergroups.org/europe/event/access-europe-2025-11-05/)\] **Ynte Jan Kundersma**: Using Power Automate with Office Apps - \[[November 06, 2025](https://accessusergroups.org/pacific/event/create-auditing-in-an-access-database-with-3-mouse-clicks-with-george-hepworth/)\] **George Hepworth**: Create Auditing in an Access Database with 3 Mouse Clicks - \[[December 03, 2025](https://accessusergroups.org/europe/event/access-europe-2025-12-03/)\] **Adolph Dupré**: Using Twilio for Texting from Access - \[[February 04, 2026](https://accessusergroups.org/europe/event/access-europe-2026-02-04/)\] **Aleksander Wojtasz**: Creating an Advanced Data Grid Integrated with Access - \[[March 04, 2026](https://accessusergroups.org/europe/event/access-europe-2026-03-04/)\] **Chris Arnold**: Using Disconnected (In-Memory) ADO Recordsets in Access \* *NOTE: Access User Group event calendar was not displaying any events at publication time; events listed above are carried forward from last week's article.* --- ## Access Roadmap *The *following changes were made* to the roadmap between the Week in Review last week (2025-10-11) and this week (2025-10-18).* - **Modernize Access Forms and Reports to work well on Large Format Monitors:** Rollout Start Date delayed from `SEP 2025` to `DEC 2025` *The roadmap was last updated *October 15, 2025.** --- Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=%5B%22Access%22%5D). "In Development", "Rolling Out", and "Launched" are Microsoft terms that I pulled straight from the public roadmap. Dates listed are "rollout start" dates. #### In Development - `OCT 2025`: **Add zoom slider magnification to Microsoft Access:** Access will add magnification slider (10% to 500%) in lower right of the application, similar to the feature in Word, PowerPoint, and Excel. It will also be keyboard accessible and available on the ribbon. - `SEP 2025`: **Modernize Access Forms and Reports to work well on Large Format Monitors:** Remove the 22-inch size limit and modernize Access forms and reports work well on large format monitors and provide responsive behavior for different form factors. #### Rolling Out None listed. #### Launched None listed. --- ## Upcoming End-of-Life Dates Here are the key end-of-life dates Access developers should track: ### 2024 - ~~`[JUL 09]`~~ *[SQL Server 2014](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2014)* ### 2025 - ~~`[OCT 14]`~~ *[Access 2016](https://learn.microsoft.com/en-us/lifecycle/products/access-2016) | [Access 2019](https://learn.microsoft.com/en-us/lifecycle/products/access-2019) | [Office 2016](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-office-2016) | [Office 2019](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-office-2019)* - ~~`[OCT 14]`~~ *[Windows 10](https://www.microsoft.com/en-us/windows/end-of-support)* - `[OCT 28]` [Salesforce ODBC Driver](https://techcommunity.microsoft.com/blog/accessblog/access-announces-removal-of-salesforce-odbc-driver-in-october-2025/4408815) - `[NOV 11]` [Windows 11 version 23H2](https://en.wikipedia.org/wiki/Template:Windows%5F11%5Fversions) ### 2026 - `[APR 01]` [Auto-migration of Classic Outlook begins for Enterprise users](https://nolongerset.com/new-outlook-tale-of-two-cities/) - `[JUL 14]` [SQL Server 2016](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016) - `[OCT 13]` [Access 2021](https://learn.microsoft.com/en-us/lifecycle/products/access-2021) | [Office 2021](https://learn.microsoft.com/en-us/lifecycle/products/office-2021) - `[OCT 13]` [Windows 11 version 24H2](https://en.wikipedia.org/wiki/Template:Windows%5F11%5Fversions) ### 2027 - `[JAN 12]` [Windows Server 2016](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2016) - `[OCT 12]` [SQL Server 2017](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2017) ### 2029 - `[JAN 09]` [Windows Server 2019](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2019) - `[OCT 09]` [Access 2024](https://learn.microsoft.com/en-us/lifecycle/products/access-2024) | [Outlook 2024](https://learn.microsoft.com/en-us/lifecycle/products/outlook-2024) - `[OCT 09` *(or later)*`]` [**Classic Outlook**](https://techcommunity.microsoft.com/blog/outlook/new-outlook-for-windows-a-guide-to-product-availability/4078895) - *See "Edit 8/12/2024" at top of [this article](https://techcommunity.microsoft.com/blog/outlook/new-outlook-for-windows-a-guide-to-product-availability/4078895) for official clarification that "both perpetual and subscription \[i.e., MS 365\] versions of Outlook will be supported until 2029"* - *Support for Classic Outlook is guaranteed *at least through 9 Oct 2029*; it may be extended beyond this date* ### 2030 - `[JAN 08]` [SQL Server 2019](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2019) ### 2031 - `[OCT 14]` [Windows Server 2022](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2022) ### 2033 - `[JAN 11]` [SQL Server 2022](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2022) ### 2034 - `[OCT 10]` [Windows Server 2025](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2025) ### Ongoing - [Microsoft 365](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-365) (with subscription) ### Date TBD - Complete removal of VBScript from Windows OS ([Microsoft Announces the Death of VBScript](https://nolongerset.com/vbscript-deprecation/))