> ## 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: January 11, 2025
- URL: https://nolongerset.com/week-in-review-2025-01-11/
- Published: 2025-01-11T19:38:28.000Z
- Updated: 2026-05-08T12:43:24.000Z
- Description: Highlights include creating COM add-ins with VB.Net, deploying Access updates, sorting MVFs, a current Access User Group list, and a new recurring section on End-of-Life dates.
- 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-3.5-Sonnet.*

- **[Access Forever](https://www.accessforever.org/)**

  - [Access User Groups 2025](https://www.accessforever.org/post/access-user-groups-2025), *by Maria Barnes*: *A comprehensive overview of Access user groups worldwide meeting in 2025, including virtual and in-person gatherings.*
- **Jonathan Halder** ([Access JumpStart 2.0](https://www.accessjumpstart.com/blog/))

  - [Access Fields bound to a function – updating once or per record](https://www.accessjumpstart.com/access-fields-bound-to-a-function-updating-once-or-per-record/): *Explains how functions bound to fields in queries, forms or reports only calculate once unless they reference a field from the recordset.*
  - [How to programmatically tell the difference between changing a combo box by typing or by choosing from the dropdown](https://www.accessjumpstart.com/how-to-programmatically-tell-the-difference-between-changing-a-combo-box-by-typing-or-by-choosing-from-the-dropdown/): *Details how to detect whether a combo box value was changed via typing or dropdown selection using KeyPress and Change events.*
  - [Forms that can't write to records – Access and it's usually helpful Lookup\_ prefix](https://www.accessjumpstart.com/forms-that-cant-write-to-records-access-and-its-usually-helpful-lookup%5F-prefix/): *Describes how an unindexed lookup field referenced in a form's Order By property can silently make the form read-only.*
  - [Do you use "Set"? Make sure you destroy it when you're done!](https://www.accessjumpstart.com/do-you-use-set-make-sure-you-destroy-it-when-youre-done/): *Explains why explicitly setting object variables to Nothing is important for proper cleanup in Access VBA code.*
  - [Do you have a deployment process?](https://www.accessjumpstart.com/do-you-have-a-deployment-process/): *Discusses the importance of automating Access application deployment processes and recommends using scripts and tools like SSESetup.*
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [AEU35: Developing COM Add-Ins for Access](https://isladogs.co.uk/aeu-35/index.html): *A presentation by Philipp Stiefel explaining how to create COM add-ins to extend Microsoft Access functionality using Visual Basic .Net.*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Image Cataloguer in Access with Chris Arnold](https://nolongerset.com/aug-image-cataloguer/): *A demonstration of an Access-based image cataloguing solution that combines drag-and-drop functionality with automated metadata tagging using ExifTool.*
  - [Throwback Thursday: January 9, 2025](https://nolongerset.com/throwback-thursday-2025-01-09/): *A collection of articles exploring the VBA DoEvents function, including what it is, how it works, and best practices for its use.*
  - [Using Web APIs in Access with George Young (2024 Edition)](https://nolongerset.com/aug-web-apis-2024/): *An updated presentation on integrating Web APIs into Access applications using the VBA-Web library with practical examples and implementation tips.*

#### Videos‌

- **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/@AccessUserGroups))

  - [Developing COM Add-Ins for Microsoft Access](https://www.youtube.com/watch?v=kisZ7CbBSXk) (01:11:51): *with Philipp Stiefel*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))

  - [ActiveForm](https://www.youtube.com/watch?v=fRu4EctRSc0) (20:32): *How to Use ActiveForm to Determine the Previous Form in Microsoft Access*
  - [Open Last Customer](https://www.youtube.com/watch?v=R%5FQCeF4zIqI) (20:57): *How to Add a Button to a Microsoft Access Form to Reopen the Previous Record*
  - [Global Status Function](https://www.youtube.com/watch?v=Dmv1g3S4ND8) (13:56): *How to Make My Status Function Global so it Works from Anywhere in your Microsoft Access Database*
  - [Ctrl-A: Select Long Text](https://www.youtube.com/watch?v=bbhtporXv2E) (16:49): *How to Use Ctrl-A to Select All Text in Long Text Box in Microsoft Access*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/@DanielPineault))

  - [Sorting MVFs](https://www.youtube.com/watch?v=kxFOLA5U6Eo) (12:17): *How To Sort Microsoft Access MultiValued Fields (MVF)*
- **Nifty Access \[Tony Hine, aka Uncle Gizmo\]** ([YouTube channel](https://www.youtube.com/@NiftyAccessMicrosoft))

  - [Next Previous Quit - Skip](https://www.youtube.com/watch?v=xDXJs0oBGHk) (03:09)

#### 

---

## New to Me

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

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

- [January 14, 2025](https://accessusergroups.org/sql-server-with-access/event/data-ingesting-pipeline-from-azure-iot-hub-to-azure-sql-db/): **Roy Kim** \- Data Ingesting Pipeline from Azure IOT Hub to Azure SQL DB
- [January 21, 2025](https://accessusergroups.org/access-beginners/event/all-about-table-relationships-630-pm-cst/): **Steve Owen** \- All about table relationships ***(NEW DATE)***
- [January 28, 2025](https://accessusergroups.org/lunch/event/access-lunchtime-5-2025-01-28/): **Maria Barnes** \- Using Dictionaries and Collections to work with JSON in Access
- [February 05, 2025](https://accessusergroups.org/europe/event/access-europe-2025-02-05/): **John Mallinson** \- Using VBE\_Extras Add-In with Access
- [February 06, 2025](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2025-02-06/): **Adam Waller** \- Access Version Control
- [~~February 18, 2025~~](https://accessusergroups.org/access-beginners/event/all-about-table-relationships-630-pm-cst/)~~: **Steve Owen** \- All about table relationships~~ **(*Moved to 21 Jan 25)***
- [March 05, 2025](https://accessusergroups.org/europe/event/access-europe-2025-03-05/); **Alexander Denz** \- AI Assistants – Bring your knowledge to the smartest AI models
- [March 06, 2025](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2025-03-06/): **George Hepworth** \- Eliminating Magic Numbers in VBA
- [April 02, 2025](https://accessusergroups.org/europe/event/access-europe-2025-04-02/): **John Heaser** \- Source Control for Access & SQL Databases
- [April 10-11, 2025](https://www.donkarl.com/devcon/): **Access DevCon Vienna** (speakers TBA)
- [May 07, 2025](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2025-02-06/): **Colin Riddington** \- Large Monitor Support and Responsive Forms
- [May 15, 2025 @ 9:30 am - 5:00 pm](https://ukaug.co.uk/event/ukaug-30th-anniversary-conference-spring-2025/): In-person UKAUG 30th Anniversary Conference 2025, Imperial College London (**Armen Stein**, other speakers TBA)
- [June 04, 2025](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2025-02-06/): **Anders Ebro** \- Using Class Modules

---

## Access Roadmap

**No changes* weremade to the roadmap between the Week in Review last week (2025-01-04) and this week (2025-01-11).*

*The roadmap was last updated on *October 4, 2024.* 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=Access).

"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 2024`: Integrate Monaco framework to improve SQL editor capabilities

#### Rolling Out

None.

#### Launched

- `AUG 2024`: Modern Chart Improvements
- `NOV 2023`: Making 32-bit Access [Large Address Aware](https://nolongerset.com/laa-flag/) (LAA)

---

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