Week in Review: January 10, 2026
Just Published
This section includes videos, articles, and (occasionally) open-source project updates from the past 7 days.
Articles
*Article descriptions generated by Claude-Opus-4.5 and Claude-Sonnet-4.5.
- John Mallinson (The VBA Help)
- Creating sentences and lists from a series of items: Two VBA functions that convert Collections or Arrays of strings into user-friendly sentences or bulleted/numbered lists for display in dialogs.
- Getting file / folder attributes: Using the GetFileAttributes Windows API function to retrieve extended file and folder attributes beyond what VBA's GetAttr function provides.
- Setting file / folder attributes: Using the SetFileAttributes Windows API function to modify file and folder attributes, including how to update existing attributes without overwriting them.
- Daniel Pineault (DEVelopers HUT)
- How to Batch Optimize Images in a Folder Using VBScript and ImageMagick: A VBScript utility that automates resizing and converting images to multiple formats using ImageMagick's convert.exe or mogrify.exe tools.
- Experts Exchange: A Community Worth Taking Notice Of: A personal review highlighting Experts Exchange as a stable, well-moderated technical forum with high-quality discussions across multiple technology topics.
- Colin Riddington (Isladogs on Access)
- AEU47: Spot the Difference–new style Access MsgBox: Details of a January 2026 Access Europe meeting featuring Neil Sargent's presentation on replicating Microsoft's new colorful Fluent UI message boxes in Access using borderless forms, custom icons, and advanced formatting techniques.
- AEU48: Advanced Data Grid Integrated with Access: Announcement of a February 2026 Access Europe meeting where Aleksander Wojtasz will demonstrate creating an advanced data grid using HTML, CSS, and JavaScript with the Access Edge browser control.
- Mike Wolfe (NoLongerSet)
- Throwback Thursday: January 8, 2026: A weekly feature revisiting past articles about pausing VBA code execution until a form or report is closed without using acDialog mode.
Videos
-
Access User Group Recordings (YouTube channel)
- Spot the Difference – A new style MsgBox for Access (01:06:35): with Neil Sargent
-
Karl Donaubauer (YouTube channel)
- Access News Edition 10 (13:51): 2025 Year in Review
-
Richard Rost (YouTube channel)
- Quick Queries #74 (25:41): Microsoft Access Time Fields Might Not Work the Way You Expect Them To
- Decimal Places (18:12): Why Microsoft Access Ignores Your Decimal Places And How to Force It to Behave Fitness #68
- Placed In A State (16:48): How To Fix The Database Has Been Placed In A State by User Admin Error In Microsoft Access
- Missing (15:38): Why Is This Microsoft Access Function Missing Right Where You Need It Most? Fitness #67
- Wrong Default (28:28): Why Zero is Often the Wrong Default Value Setting in Microsoft Access. Fitness #66
New to Me
This section includes content I discovered this week that has been around for a while.
21 Lessons From 14 Years at Google, by Addy Osmani
[From #5]: "Novelty is a loan you repay in outages, hiring, and cognitive overhead."
I wish I understood and appreciated this earlier in my career. My novel approaches made me uber-efficient, but they created friction that has made it harder to onboard new developers and offload more of my own work to my team.
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.
- [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
- [April 1, 2026] Peter Cole: Using vbWatchdog with Access
- [May 6, 2026] Tim Finch: Grid Lanes
- [June 3, 2026] Kevin Bell: SQL Server Tips and Tricks for Access Developers
- [September 2, 2026] John Mallinson: Working with the Windows API
Access Roadmap
There were no changes made to the roadmap between the Week in Review last week (2026-01-03) and this week (2026-01-10).
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.DEC 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.
Development Priorities
"Development Priorities" do not appear on the Access Roadmap. Instead, they get updated from time to time in official Access blog posts or Access engineering team presentations. I'll include a link to the source of the current development priorities as they get updated.
The items listed below reflect Microsoft's order of priority and were published in the following Access Forever article, Microsoft's Plans for Access Oct '25 – March '26.
- Continued focus on monthly issue fixes, security, customer-reported bugs, etc. to improve product quality, security, reliability, and relevance. Most of our engineering hours are spent here.
- Large monitor support: Remove 22” limitation to support using Access on modern hardware.
- Large monitor support: Enable zoom slider magnification for forms.
- Large monitor support: Modernize forms to work well on large monitors.
- Time allowing, we’ll continue to work on remaining large monitor support features (support zoom in reports and design layout, automatic zooming, support multiple monitor scenarios).
- If we still have time left over in the semester, we will begin work on Git integration for source code management in Access. (Spec is in progress. We will likely roll this out in phases also beginning the second half of 2026.)
Special thanks to Karl Donaubauer for posting the updated priorities at AccessForever.org.
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]Salesforce ODBC Driver[OCT 28]Windows 11 version 23H2[NOV 11]
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)