> ## 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: September 23, 2023
- URL: https://nolongerset.com/week-in-review-2023-09-23/
- Published: 2023-09-23T20:42:27.000Z
- Updated: 2026-05-08T12:35:45.000Z
- Description: Highlights include the death of COM/VBA in New Outlook (?!?!), a web-based image editor for Access, and a deep dive into string-building performance in VBA.
- Author: Mike Wolfe
- Tags: Week in Review, #Import 2026-05-20 02:59

## Just Published

This section includes videos, articles, and interesting discussions from the past 7 days.

#### Articles

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

  - [The New Outlook and Access/VBA](https://www.accessforever.org/post/the-new-outlook-and-access-vba), *by Karl Donaubauer*
- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))

  - [Streamlining Report Module in Class Module-2 ](https://www.msaccesstips.com/2023/09/streamlining-report-module-in-class.html)
- **Maria Barnes** ([Business Data Bytes Newsletter](https://www.linkedin.com/newsletters/business-data-bytes-6892816951870066688/))

  - [Responsible AI in the Age of Innovation](https://www.linkedin.com/pulse/responsible-ai-age-innovation-maria-barnes/)
- **Noah (Dykoski?)** ([Arkware](https://www.arkware.com/blog/))

  - [Boosting Performance and Scalability with Database Sharding](https://www.arkware.com/boosting-performance-and-scalability-with-database-sharding/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Access Modern Web Browser Control – Image Editor](https://www.devhut.net/access-modern-web-browser-control-image-editor/)
  - [Access Modern Web Browser Control – Dynamic Content](https://www.devhut.net/access-modern-web-browser-control-dynamic-content/)
  - [Access Modern Web Browser Control – Image Cropping](https://www.devhut.net/access-modern-web-browser-control-image-cropping/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [AEU22: Streamline Import Specs with VBA Classes](https://isladogs.co.uk/aeu-22/index.html)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [clsConcat: Blazing-Fast String Building Performance in VBA](https://nolongerset.com/clsconcat/)
  - [Standard String Concatenation in VBA is Slow and Inefficient](https://nolongerset.com/string-concatenation-in-vba/)
  - [Use Hidden Controls for More Reliable Code](https://nolongerset.com/use-hidden-controls/)
  - [When–And When Not–To Use the Statement Separator Character in VBA](https://nolongerset.com/statement-separator-character/)
  - [Break Down Complex Expressions for More Debuggable Code](https://nolongerset.com/break-down-complex-expressions/)

#### Videos‌

- **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/UCa%5Fke31HE1lg45NFZlK6gSw))

  - [Introduction to Azure Cosmos DB](https://www.youtube.com/watch?v=Io4tdwVFYyQ) (01:13:24): *with Leonard Lobel (Lenni)*
  - [Fundamentals of Azure OpenAI](https://www.youtube.com/watch?v=ZpwW%5FBwVuQU) (01:12:02): *with Roy Kim*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/UCl7-jJie4ifOVK87FINIuDg))

  - [Do While Loop](https://www.youtube.com/watch?v=ujlURKQ6ozI) (15:33): *Do While Loops in Microsoft Access VBA*
  - [While Wend Loop](https://www.youtube.com/watch?v=1ARAia1QNmE) (18:44): *While Wend Loops in Microsoft Access VBA*
  - [For Next Loop](https://www.youtube.com/watch?v=l80-QmKEMRk) (13:52): *For Next Loops in Microsoft Access VBA*
  - [Resize Images](https://www.youtube.com/watch?v=eiswJmHBCro) (31:20): *Resize Images in Microsoft Access: Using FFmpeg & Paint with VBA - Advanced Developer Tutorial*
  - [Account Balances Template - Release Update 3](https://www.youtube.com/watch?v=LrTIcZQgeWc) (07:57)
  - [Access EOMONTH](https://www.youtube.com/watch?v=02KCwijUa64) (14:22): *Creating Excel's EOMONTH Function in Microsoft Access VBA: Date Manipulation Made Easy*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/UC9lSC6AT4d0qour-aIbMjFQ))

  - [Modern Web Browser Control - Image Editing](https://www.youtube.com/watch?v=17pzyjOTtPU) (29:50): *Crop , Flip, Rotate, Annotate, Draw, Adjust, ...*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/UCOm7X-WFABGXg00dMS5I9dw))

  - [Advanced VBA: Subroutines & Functions](https://www.youtube.com/watch?v=HR4raH0tVtk) (11:08): *A Deep Dive into Subroutines and Functions in Programming*
  - [Using Arrays in VBA](https://www.youtube.com/watch?v=FQaYSZzGBzg) (14:31): *Introduction to Arrays: From Basics to Advanced Functions*
  - [Variable Types in VBA](https://www.youtube.com/watch?v=E89jPveNbBU) (09:25): *Variables in VBA: Navigating Naming, Scopes, and Data Types*

---

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

- [September 26, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-09-26/): **Tom van Stiphout and Kim Young** \- Accessibility is for Everyone
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access
- [October 5, 2023](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2023-10-05/): **Pat Hartman** \- Updateable Bound Forms with Denormalized Data
- [October 19, 2023](https://www.daaug.org/Presentations/Details/252): **Alessandro Grimaldi** \- "VBA Pills" - Access Tips and Tricks
- [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data
- [November 2, 2023](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2023-11-02/): **John Colby** \- Event Driven Programming: Part II ([Part I recording](https://www.youtube.com/watch?v=6gOF-b0UgNY)) **(JUST ADDED)**
- [November 16, 2023](https://www.daaug.org/Presentations/Details/256): **Alexander Denz** \- ChatGPT in Access
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- Streamline Your Import/Export Spec Workflow with VBA Classes **(TOPIC JUST UPDATED)**
- [January 3, 2024](https://accessusergroups.org/europe/event/access-europe-2024-01-03/): **Ramachandran (A.P.R.) Pillai** \- Streamlining the Form Module Code in the standalone Class Module
- [February 7, 2024](https://accessusergroups.org/europe/event/access-europe-2024-02-07/): **Carlos Quintero** \- Features of MZ-Tools to make you more productive with VBA
- [March 6, 2024](https://accessusergroups.org/europe/event/access-europe-2024-03-06/): **Thomas Möller** \- Better Access Charts in the new Edge Browser Control
- [April 3, 2024](https://accessusergroups.org/europe/event/access-europe-2024-04-03/): **Dale Fye -** Working with Command Bars and the Access Shortcut Tool **(JUST ADDED)**
- [May 1, 2024](https://accessusergroups.org/europe/event/access-europe-2024-05-01/): **Colin Riddington** \- View & Edit Import/Export (IMEX) Data Task Specifications **(JUST ADDED)**

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-09-16) and this one (2023-09-23).*

*The [development priorities](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894) were last updated on October 12, 2022.*

---

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. I'll include a link to the official Access blog post that lists 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, *[Our Road Ahead - Microsoft Access Engineering Priorities Oct 2022](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894)*.

New priorities added since the [previous set of priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075) are shown in bold below. Dropped priorities are struck through.

1. **Continued Focus on Monthly Issue Fixes** *(Monthly Issue Fix Blog)*
2. Inconsistent Database Error Fix
3. **New Macro Signing Support**
4. New (Modern) Web Browser Control (to support Chromium Edge)
5. **Dataverse Connector Data Type Support for Floating Point**
6. **Dataverse Connector Data Type Support for Rich Text**
7. **Dataverse Connector support to export to a specific Dataverse solution or publisher**
8. ~~Enabling Large Address Aware (LAA) for 32-Bit Access~~
9. ~~SQL Monaco Editor~~
10. ~~New Microsoft Graph Data Connector~~

#### In Development

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

#### Rolling Out

None.

#### Launched

- `APR 2023`: Modern Web Browser Control
- `MAR 2023`: New Modern Web Browser Form Control