> ## 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: July 5, 2025
- URL: https://nolongerset.com/week-in-review-2025-07-05/
- Published: 2025-07-06T01:27:16.000Z
- Updated: 2026-05-08T12:46:14.000Z
- Description: Highlights include a faster alternative to DLookup, using AI to analyze an Access database, and an Access bug and subsequent fix related to Access wizards.
- 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.*

- **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/))

  - [How to select the previous or next choice in an Access Combo box or Listbox using VBA](https://www.linkedin.com/pulse/how-select-previous-next-choice-access-combo-box-vba-strive4peace--ma1zc/): *Demonstrates a VBA procedure to programmatically navigate through combo box and listbox items using command buttons with previous/next functionality.*
- **Jonathan Halder** ([Access JumpStart 2.0](https://www.accessjumpstart.com/blog/))

  - [Allowing AI to see your whole database](https://www.accessjumpstart.com/allowing-ai-to-see-your-whole-database/): *Explores methods for exporting Access database objects to text files so AI tools can analyze entire database structures and provide development assistance.*
  - [Playing with CoPilot for analyzing an Access database](https://www.accessjumpstart.com/playing-with-copilot-for-analyzing-an-access-database/): *Documents the process of consolidating exported Access object files into a single text file that CoPilot can analyze to provide performance optimization recommendations.*
  - [Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns](https://www.accessjumpstart.com/mastering-cross-join-in-sql-server-from-cartesian-products-to-reusing-calculated-columns/): *Explains how to use CROSS JOINs for generating Cartesian products and creating reusable calculated columns without repeating complex formulas.*
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Access MVPs Launch 'Access Talk' on Discord](https://www.devhut.net/access-mvps-launch-access-talk-on-discord/): *A group of Access MVPs have created a new Discord server called "Access Talk" to provide a welcoming community space for Microsoft Access users to connect, share knowledge, and get support.*
  - [Microsoft Access Wizards Broken](https://www.devhut.net/microsoft-access-wizards-broken/): *Microsoft Access wizards for MVFs and lookup fields have been broken for several weeks due to unrelated security work, with no official acknowledgment from the Access team on their blog or fixes page.*
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Lookup Wizard Bug (FIXED)](https://isladogs.co.uk/lookup-wizard-bug-fixed/index.html): *The lookup wizard bug that prevented creation of multivalued fields and table-level lookup fields has been quickly acknowledged and fixed across all affected Office channels.*
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Analyzer (update)](https://msaccessgurus.com/tool/Analyzer.htm): *The free Analyzer tool for Microsoft Access has been updated with vbWatchdog improvements and provides comprehensive database documentation with over 50 built-in reports.*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Throwback Thursday: July 3, 2025](https://nolongerset.com/throwback-thursday-2025-07-03/): *This week's throwback features articles about the underused Watch Window debugging tool in VBA, along with related debugging resources and developer humor.*
  - [GET and POST with JSON with Neil Sargent & Leo theDBguy](https://nolongerset.com/aug-get-post-json/): *Neil Sargent demonstrates a production-ready solution for integrating Microsoft Access with external APIs using JSON for both GET and POST operations in a real-world electrical testing company application.*

#### 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.*  
    - [The Remaining Order Detail Sub Procedures](https://www.youtube.com/watch?v=mK9SLHDXxAc) (11:50)
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))

  - [Quick Queries #47](https://www.youtube.com/watch?v=w70KdDXJS1s) (28:25): *Outlook Email Automation, Faster Dlookup, CoPilot Integration*
  - [Faster DLookup: Part 1](https://www.youtube.com/watch?v=mVG4tPtgwNA) (15:18): *Faster Than DLookup: Speed Up Your Microsoft Access Code & Forms with This Simple Technique*
  - [Faster DLookup: Part 2](https://www.youtube.com/watch?v=%5FlxZs-WkO24) (16:52): *Faster Than DLookup: Speed Up Your Microsoft Access Code & Forms with This Simple Technique, Part 2*
  - [Timer Function](https://www.youtube.com/watch?v=hEOBHGqzfU4) (17:57): *Is Your Microsoft Access Database Slow? Use the Timer Function to Find Out Where.*

---

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

- \[[August 06, 2025](https://accessusergroups.org/europe/event/access-europe-2025-08-06/)\] **Colin Riddington**: New and Forthcoming Features in Access
- \[[September 03, 2025](https://accessusergroups.org/europe/event/access-europe-2025-09-03/)\] **Adam Waller**: Topic TBD
- \[[October 01, 2025](https://accessusergroups.org/europe/event/access-europe-2025-10-01/)\] **Marcus Dieterle**: High impact – Custom dialogs and mini-notifications
- \[[November 05, 2025](https://accessusergroups.org/europe/event/access-europe-2025-11-05/)\] **Aleksander Wojtasz**: Topic TBD

---

## Access Roadmap

*There *were no changes made* to the roadmap between the Week in Review last week (2025-06-28) and this week (2025-07-05):*

- **Add zoom slider magnification to Microsoft Access:** Rollout start changed from JUN 2025 to SEP 2025
- **Modernize Access Forms and Reports to work well on Large Format Monitors**: Rollout start changed from JUL 2025 to SEP 2025

*The roadmap was last updated on A*pril 10, 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.*

- `AUG 2024`: **Modern Chart Improvements:** A top ask from customers is to modernize Access charts and to support better data visualization in Access. To satisfy this user request, we are integrating a new charting package called “Ivy” into Access. Ivy is a charting package written by the Office DVX team that is currently used in Excel, Word, and PowerPoint.
- `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)
- `[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/))