Week in Review: September 13, 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.}

Microsoft 365 Developer Blog
- Prepare your VBA projects for VBScript deprecation in Windows, by Wenjun Gong: Guidance on preparing VBA projects for the phased deprecation of VBScript in Windows, including how to use the new RegExp classes included in Office 2508 and later.
Marcus Dieterle (LinkedIn Articles)
- 🚀 DEV Functions Series -- Part 2: Developers App Helper: A collection of useful VBA functions for controlling Access interface elements, window behavior, and visual effects to create more professional and user-friendly database applications.
Jonathan Halder (Access JumpStart 2.0)
- Productivity Check-In: What's Worth My Time (and What Isn't)?: A reflection on identifying and eliminating time-wasting activities, particularly around time tracking and email management, to improve overall productivity.
- A Reusable Recipe for Importing and Exporting Text Files in Access: An object-oriented approach to building a flexible file conversion tool using classes and interfaces to handle different customer file formats with minimal code changes.
- Navigating Multi-Page Subreports in Access--Without Losing Your Place: A detailed solution for maintaining user position when navigating multi-page subreports in Access forms, using specific VBA techniques to prevent the report from resetting to the top.
Daniel Pineault (DEVelopers HUT)
- Unable to Get SQL View To Work With The Monaco Editor?: Describes how to fix the SQL View disappearing issue in Access by disabling the Monaco SQL Editor and reverting to the plain text editor.
Colin Riddington (Isladogs on Access)
- ACCDB to MDB Conversion Issues: Explains the two methods for converting ACCDB files to older MDB format and common issues that prevent successful conversion, including newer field types, data types, controls, and sort order problems.
- Is My Database Compiled?: Explains two meanings of "compiled" in Access databases and provides VBA code to check both VBA project compilation status and whether a database has been converted to ACCDE/MDE format.
- Windowed & Non-Windowed Controls in Access: Explores the differences between windowed and non-windowed controls in Access, their Z-order behavior, and includes an unexpected discovery about modern chart overlaying behavior.
Mike Wolfe (NoLongerSet)
- Throwback Thursday: September 11, 2025: A weekly roundup featuring compatibility considerations between Access and SQL Server, including articles on date fields, Yes/No fields, floating point arithmetic, and epoch differences.

Videos‌

Access User Group Recordings (YouTube channel)
- Version Control for the Sole Developer - Why it Matters (01:07:40): with Adam Waller
- Updated Control Tip Text (01:14:13): with Greg Regan
Richard Rost (YouTube channel)
- Quick Queries #57 (30:57): Can Access Really Handle a Million Records Without Crashing?
- Microsoft Access Fitness Database:
  - Part 33 (14:40): Calculating Required Weight Plates Algorithm
  - Part 34 (13:09): Implementing Symmetric Plate Calculation Algorithm
  - Part 35 (24:14): Add Daily Totals to Form Footer, Fix Combo Box Defaults
- RecordsAffected (22:16): How to Use RecordsAffected to Count Deleted Records in Microsoft Access
Edcelle John Gulfan (YouTube channel)
- FREEZE FIELD in Microsoft Access (01:33): How to Freeze fields in Microsoft Access Datasheet

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}^.

[September 30, 2025] Crystal Long & Adrian Bell: Using Custom and Built-in Functions in Expressions
[October 01, 2025] Marcus Dieterle: High impact – Custom dialogs and mini-notifications
[October 28, 2025] Colin Riddington: A Masterclass in Access Security
[November 5, 2025] Ynte Jan Kundersma: Using Power Automate with Office Apps
[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

Access Roadmap

There were no changes made to the roadmap between the Week in Review last week (2025-09-06) and this week (2025-09-13).

The roadmap was last updated the week of August 9, 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.

In Development

SEP 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

NOTE: Dates listed are rollout start dates.

SEP 2024: Integrate Monaco framework to improve SQL editor capabilities: The Monaco Editor is the fully featured code editor from VS Code with standard IDE functionality such as syntax highlighting, IntelliSense, and autocomplete.

Upcoming End-of-Life Dates

Here are the key end-of-life dates Access developers should track:

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)