> ## 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: August 23, 2025
- URL: https://nolongerset.com/week-in-review-2025-08-23/
- Published: 2025-08-24T01:18:50.000Z
- Updated: 2026-05-08T12:46:45.000Z
- Description: Highlights include how to break on a specific recordset loop iteration, API helper features in VBE_Extras, date filtering tips, and a spotlight on great UI design at Access Forever.
- 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.*

- **[Access Forever](https://www.accessforever.org/)**  
  - [Application Manages Quotes in the Construction Industry](https://www.accessforever.org/post/an-application-manages-quotations-in-the-construction-industry), *by Bernd Siebelist (adapted for AFo by Karl Donaubauer)*: *A comprehensive Access application that integrates email processing, SAP connectivity, and custom design features to manage construction industry quotations, increasing daily inquiry processing from 20 to nearly 100.*
- **[The UKAUG Blog](https://ukaug.co.uk/articles/)**  
  - [Talk and Chat August 2025 -- Graph API](https://ukaug.co.uk/talk-and-chat-august-2025-graph-api/): *Materials and video from a UK Access User Group session covering the implementation and use of Microsoft Graph API within Access applications.*
- **Marcus Dieterle** ([LinkedIn Articles](https://www.linkedin.com/in/marcus-dieterle-557572222/recent-activity/articles/))  
  - [Developers App Helpers - part 1](https://www.linkedin.com/pulse/developers-app-helpers-part-1-marcus-dieterle-lojve/): *A collection of VBA functions for creating desktop shortcuts, managing trusted locations, and dynamically controlling Access application properties to make databases appear more professional and app-like.*
- **John Mallinson** ([The VBA Help](https://www.thevbahelp.com/blog))  
  - [Automatically add Windows API declaration(s)](https://www.thevbahelp.com/post/automatically-add-windows-api-declaration-s): *VBE\_Extras functionality that helps identify and automatically add Windows API declarations to VBA code from a database of over 1,700 functions, 400+ types, and 9,000+ constants.*
  - [Using 'F1' to view Windows API web pages](https://www.thevbahelp.com/post/using-f1-to-view-windows-api-web-pages): *VBE\_Extras extends the F1 key functionality to open Microsoft documentation web pages for Windows API functions, types, enums, and constants directly from the VBA editor.*
  - [Testing the state of a key using the GetKeyState Windows API Function](https://www.thevbahelp.com/post/testing-the-state-of-a-key-using-the-getkeystate-windows-api-function): *Demonstrates how to use the GetKeyState Windows API function to check if keys like Shift, Ctrl, Alt, Caps Lock, and Num Lock are currently pressed or toggled.*
  - [Get and set the active printer ... and list all available printers](https://www.thevbahelp.com/post/get-and-set-the-active-printer-and-list-all-available-printers): *Shows how to use GetDefaultPrinter, SetDefaultPrinter, and EnumPrinters Windows API functions to manage and list system printers in VBA.*
- **Jonathan Halder** ([Access JumpStart 2.0](https://www.accessjumpstart.com/blog/))  
  - [Access Tip: How to Break into Your Code at Exactly the Right Moment](https://www.accessjumpstart.com/access-tip-how-to-break-into-your-code-at-exactly-the-right-moment/): *Shows how to use VBA Watch functionality to break into code execution at specific conditions, such as when a recordset reaches a particular record ID.*
  - [TDD in Access: Separating Logic from Forms for Cleaner Tests](https://www.accessjumpstart.com/tdd-in-access-separating-logic-from-forms-for-cleaner-tests/): *Demonstrates how to decouple form-dependent functions from UI controls by using custom types to enable faster, more efficient unit testing.*
  - [Access Date Filtering: Between vs. >= and < Explained](https://www.accessjumpstart.com/access-date-filtering-between-vs-and-explained/): *Explains why using >= and < operators is safer than BETWEEN for date range filtering when dealing with time components in Access databases.*
  - [What Happens When You Press Ctrl-A in an Access Text Box?](https://www.accessjumpstart.com/what-happens-when-you-press-ctrl-a-in-an-access-text-box/): *Explores the unexpected behavior of Ctrl-A in Access text boxes and provides alternative methods and VBA solutions for selecting all text.*
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)  
  - [How to Improve Loading and Performance of Large Excel Files](https://www.devhut.net/how-to-improve-loading-and-performance-of-large-excel-files/): *Practical strategies to optimize Excel workbook performance including using binary format, manual calculations, and minimizing volatile functions.*
  - [Dell's New Laptop Shipping with Windows 11's Greatest Hits of Bugs](https://www.devhut.net/dells-new-laptop-shipping-with-windows-11s-greatest-hits-of-bugs/): *A frustrating experience setting up a new Dell laptop reveals Windows 11's inconsistent language settings, problematic Edge launch, and Office installation issues.*
  - [Oracle's VirtualBox the Mortal Enemy Microsoft Windows and Brave](https://www.devhut.net/oracles-virtualbox-the-mortal-enemy-microsoft-windows-and-brave/): *VirtualBox appears to cause intermittent freezing and copy/paste failures in Brave browser and Windows, with no consistent solution found.*
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)  
  - [32 to 64-bit Conversion - Page 1 (of 5) (UPDATED)](https://isladogs.co.uk/32-64-bit-conversion/index.html): *A comprehensive guide covering the main issues developers face when ensuring Access applications work in both 32-bit and 64-bit environments, including API declarations, ActiveX controls, and ACCDE file compatibility.*
  - [New features in the VBE\_Extras add-in](https://isladogs.co.uk/new-extras-tools/index.html): *An overview of recent enhancements to the VBE\_Extras add-in for Office applications, highlighting features like HTML code copying, automated API declaration insertion, and extended F1 help functionality.*
  - [Export Objects to HTML Encoding Issues](https://isladogs.co.uk/export-object-html-issues/index.html): *Documents recent issues in Access where exporting objects to HTML with formatting causes excessive encoding of all data and data scrambling errors, particularly affecting versions from 2506 onwards.*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)  
  - [Access Add-in Helper with Geoffrey L. Griffith](https://nolongerset.com/aug-add-in-helper/): *Geoffrey L. Griffith demonstrates two custom tools that automate the complex process of building Access add-ins and editing database properties.*
  - [Throwback Thursday: August 21, 2025](https://nolongerset.com/throwback-thursday-2025-08-21/): *A weekly roundup highlighting past articles about Microsoft Access's role in validating business processes before investing in custom software development.*

#### Videos‌

- **George Hepworth** ([YouTube channel](https://www.youtube.com/@GroverParkGeorge))  
  - From Access to PowerApps: Replicating Northwind: *A series from one of the core team members of the Northwind 2.0 template redesign project.*  
    - [Interface Design -- Fixed vs Floating Add Rows](https://www.youtube.com/watch?v=TD1bRlw8b1Q) (07:09)
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))  
  - [Quick Queries #54](https://www.youtube.com/watch?v=3tuTrrexH7g) (19:52): *Viewing Users in a Split Database, Merge Columns in Combo Box*
  - **Microsoft Access Fitness Database**:  
    - [Part 24](https://www.youtube.com/watch?v=chzgrbRDtLg) (29:21): *Building a Food Log Form and Supporting Query*
    - [Part 25](https://www.youtube.com/watch?v=DRNBFG6cDAI) (18:14): *Filter Food Log Records by Date with Navigation Buttons*
    - [Part 26](https://www.youtube.com/watch?v=OSUS0BN2%5FO0) (17:02): *Custom Time Entry in a Bound Date Field with Validation*
    - [Part 27](https://www.youtube.com/watch?v=bI1PNfCZeo4) (18:01): *Display & Edit Time Portion Only of a DateTime Field*

---

## New to Me

This section includes content I discovered this week that has been around for a while.

[No, AI is not Making Engineers 10x as ProductiveCuring Your AI 10x Engineer Imposter Syndrome![](https://colton.dev/apple-touch-icon.png)](https://colton.dev/blog/curing-your-ai-10x-engineer-imposter-syndrome/)

---

## 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). 

- \[[August 26, 2025](https://accessusergroups.org/lunch/event/access-lunchtime-5-2025-08-26/)\] **Maria Barnes**: Update on calling Microsoft Graph API from VBA
- \[[September 03, 2025](https://accessusergroups.org/europe/event/access-europe-2025-09-03/)\] **Adam Waller**: Version Control for the Sole Developer – Why it Matters
- \[[September 04, 2025](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2025-09-04/)\] **Greg Regan**: Updated Control Tip Text
- \[[September 30, 2025](https://accessusergroups.org/lunch/event/access-lunchtime-5-2025-09-30/)\] **Crystal Long & Adrian Bell**: Using Custom and Built-in Functions in Expressions
- \[[October 01, 2025](https://accessusergroups.org/europe/event/access-europe-2025-10-01/)\] **Marcus Dieterle**: High impact – Custom dialogs and mini-notifications
- \[[October 28, 2025\]](https://accessusergroups.org/lunch/event/access-lunchtime-5-2025-10-28/) **Colin Riddington**: A Masterclass in Access Security ***(JUST ADDED)***
- \[[November 05, 2025](https://accessusergroups.org/europe/event/access-europe-2025-11-05/)\] **Aleksander Wojtasz**: Topic TBD
- \[[December 03, 2025](https://accessusergroups.org/europe/event/access-europe-2025-12-03/)\] **Adolph Dupré**: Topic TBD
- \[[January 07, 2026](https://accessusergroups.org/europe/event/access-europe-2026-01-07/)\] **Ynte Jan Kundersma**: Using Power Automate with Office Apps
- \[[March 04, 2026](https://accessusergroups.org/europe/event/access-europe-2026-03-04/)\] **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-08-16) and this week (2025-08-23).*

*The roadmap was last updated the week of *August 9, 2025.* The* [*development priorities*](https://www.accessforever.org/post/microsoft-s-plans-for-access-oct-24-march-25) *were last updated at the German-language AEK conference on October 20, 2024.*

---

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.

"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.

#### Development Priorities

The items listed below reflect Microsoft's order of priority and were published in the following article, [*Microsoft's Plans for Access Oct '24 – March '25*](https://www.accessforever.org/post/microsoft-s-plans-for-access-oct-24-march-25).

The items are listed in priority order according to Principal Engineering Manager Dale Rector. The "Expected Benefit" of each feature is shown in italics after the description of the feature itself.

New priorities added since the [previous set of priorities](https://www.accessforever.org/post/microsoft-s-plans-for-access-in-the-next-6-months) are shown in bold below.

1. Continued Focus on Monthly Issue Fixes: *(Monthly Issue Fix Blog) Improved product quality and reliability*
2. Large monitor support for forms: *Improved support of Access on the latest hardware*
3. **Integrated source control**: *Simplifying the process of building mission critical Access solutions*

Special thanks to Karl Donaubauer for posting the updated priorities at [AccessForever.org](https://www.accessforever.org/post/microsoft-s-plans-for-access-oct-24-march-25).

#### 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:

### 2024

- ~~`[JUL 01]`~~ [Teams Classic Client](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-teams)
- ~~`[JUL 09]`~~ [SQL Server 2014](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2014)
- ~~`[OCT 01]`~~ [Auto-migration of Classic Outlook begins for personal accounts](https://support.microsoft.com/en-us/office/switch-to-new-outlook-for-windows-f5fb9e26-af7c-4976-9274-61c6428344e7)
- ~~`[OCT 08]`~~ [Windows 11 version 22H2](https://en.wikipedia.org/wiki/Template:Windows%5F11%5Fversions)

### 2025

- ~~`[JAN 01]`~~ [Auto-migration of Classic Outlook begins for Small/Medium Business users](https://support.microsoft.com/en-us/office/switch-to-new-outlook-for-windows-f5fb9e26-af7c-4976-9274-61c6428344e7)
- `[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/))