Week in Review: October 18, 2025
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)
- 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: 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)
- Building Excel VBA with CoPilot: 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: 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): How to use MZ-Tools' regular expression find and replace feature to convert SQL statements into properly formatted VBA string concatenations.
- Mike Wolfe (NoLongerSet)
- Throwback Thursday: October 16, 2025: 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)
- Quick Queries #62 (33:52): Important Missing Index That Could Be Killing Your Microsoft Access Performance
- Microsoft Access Fitness Database:
- Fitness Part #49 (17:12): How to Enter Excel-Style Equations in Any Text Box in Microsoft Access
- Fitness Part #50 (12:36): How to Calculate Totals for Checked Items Automatically in Microsoft Access
- Fitness Part #51 (17:48): Implement Click & Shift-Click to Select Contiguous Records in Microsoft Access
-
David Britz [David's Database and Coding Channel] (YouTube channel)
- Access Series Episode 7 (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. 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.
- [October 28, 2025] Colin Riddington: A Masterclass in Access Security
- [November 5, 2025] Ynte Jan Kundersma: Using Power Automate with Office Apps
- [November 06, 2025] George Hepworth: Create Auditing in an Access Database with 3 Mouse Clicks
- [December 03, 2025] Adolph Dupré: Using Twilio for Texting from Access
- [February 04, 2026] Aleksander Wojtasz: Creating an Advanced Data Grid Integrated with Access
- [March 04, 2026] 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
toDEC 2025
The roadmap was last updated October 15, 2025.
Listed below is a snapshot of the official Access Roadmap.
"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
SQL Server 2014[JUL 09]
2025
Access 2016 | Access 2019 | Office 2016 | Office 2019[OCT 14]
Windows 10[OCT 14]
[OCT 28]
Salesforce ODBC Driver[NOV 11]
Windows 11 version 23H2
2026
[APR 01]
Auto-migration of Classic Outlook begins for Enterprise users[JUL 14]
SQL Server 2016[OCT 13]
Access 2021 | Office 2021[OCT 13]
Windows 11 version 24H2
2027
[JAN 12]
Windows Server 2016[OCT 12]
SQL Server 2017
2029
[JAN 09]
Windows Server 2019[OCT 09]
Access 2024 | Outlook 2024[OCT 09
(or later)]
Classic Outlook- See "Edit 8/12/2024" at top of this article 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
2031
[OCT 14]
Windows Server 2022
2033
[JAN 11]
SQL Server 2022
2034
[OCT 10]
Windows Server 2025
Ongoing
- Microsoft 365 (with subscription)
Date TBD
- Complete removal of VBScript from Windows OS (Microsoft Announces the Death of VBScript)