> ## 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 2, 2023
- URL: https://nolongerset.com/week-in-review-2023-09-02/
- Published: 2023-09-02T13:47:01.000Z
- Updated: 2026-05-08T12:35:09.000Z
- Description: Highlights include a video series on Colin Riddington's Access Analyzer Pro tool, plus introductory videos on Eval, Data Macros, and the Form Detail On Paint event.
- 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

- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))

  - [Streamlining Form Module Code - Part Eleven ](https://www.msaccesstips.com/2023/08/streamlining-form-module-code-part.html)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Modern Web Browser control – Display Problems](https://www.devhut.net/modern-web-browser-control-display-problems/)
  - [Access AEK25 (2023)](https://www.devhut.net/access-aek25-2023/)
  - [Modern Web Browser control – No Mixed Content Sources](https://www.devhut.net/modern-web-browser-control-no-mixed-content-sources/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Database Analyzer Pro](https://isladogs.co.uk/database-analyzer-pro/index.html) *(updated)*
  - [The Strange Dotted Square 'Bug' FIXED](https://isladogs.co.uk/dotted-square-bug/index.html) *(updated)*
  - [AEU19: Database Analyzer and Other Tools](https://isladogs.co.uk/aeu-19/index.html) *(updated)*
  - [AEU21: Use SQL Geography data in Access](https://isladogs.co.uk/aeu-21/index.html)
  - [AEU20: The Future of Access](https://isladogs.co.uk/aeu-20/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Word Selection Summary](https://msaccessgurus.com/VBA/Word%5FSelectionSummary.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Pause Code Until a Form is Closed or Hidden (without acDialog)](https://nolongerset.com/waittilformclosedorhidden/)
  - [Using the NotInList Event in Microsoft Access to Dynamically Update Combo Boxes](https://nolongerset.com/notinlist/)
  - [How to Pause Code Execution Until a Form or Report is Closed (Without Using acDialog)](https://nolongerset.com/waittilobjclosed/)
  - [Working with Empty in VBA](https://nolongerset.com/empty-in-vba/)
  - [How to Be Signed In To Multiple Organizations in the MS Teams Desktop App Simultaneously](https://nolongerset.com/two-instances-of-ms-teams/)

#### Videos‌

- **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA))

  - [Access Database Analyzer Pro - 1](https://www.youtube.com/watch?v=mlt3kUhynQk) (4:31): *Analysis Reports*
  - [Access Database Analyzer Pro - 2](https://www.youtube.com/watch?v=YehQh2uRqcY) (5:54): *View Analysis Results*
  - [Access Database Analyzer Pro - 3](https://www.youtube.com/watch?v=GVQMkn9EhEc) (25:28): *Options & Analysis*
  - [Access Database Analyzer Pro - 4](https://www.youtube.com/watch?v=2X2vvX8-nDw) (8:01): *Introduction*
- **Sean MacKenzie** ([YouTube channel](https://www.youtube.com/@seanmackenziedataengineering))

  - [Eval](https://www.youtube.com/watch?v=-AhY6xw%5FE80) (24:57): *How to Use the Eval Function in Microsoft Access*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [AutoSave](https://www.youtube.com/watch?v=zNwOPH5HL7k) (15:01): *AutoSave Form Data at Timed Intervals in Microsoft Access*
  - [File In Use](https://www.youtube.com/watch?v=B--M%5FeLuLng) (21:18): *How to Fix "File Already in Use" and "Already Opened" Errors When Compacting in Microsoft Access*
  - [MCA Loan Calculator](https://www.youtube.com/watch?v=cBwvS8sixs4) (33:55): *How to Calculate a Merchant Cash Advance (MCA) Loan Repayment in Microsoft Access*
  - [On Paint](https://www.youtube.com/watch?v=Ehyda-byrQE) (21:43): *How to Use the On Paint Event in Microsoft Access Forms to Supplement Conditional Formatting*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))

  - [Mixed Content Source BUG!](https://www.youtube.com/watch?v=VT7EwEAPSQQ) (8:04): *New Modern Web Browser Control*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [Convert Macro to VBA](https://www.youtube.com/watch?v=6jkS1%5FZT%5FaQ) (5:10): *Converting a Macro into VBA Code for Better Efficiency*
  - [Data Macros](https://www.youtube.com/watch?v=3iZia04-hEY) (10:16): *Data Macros and the Events that Drive Them*
  - [Embedded Macros](https://www.youtube.com/watch?v=-72DiDxDRxI) (8:26): *The Benefits of Embedded Macros in Access*
- **Edcelle John Gulfan** ([YouTube channel](https://www.youtube.com/@EdcelleJohnGulfan))

  - [Prevent Opening a Report Without Records](https://www.youtube.com/watch?v=63rgDc-8bq4) (4:32)

---

## 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 6, 2023](https://accessusergroups.org/europe/event/access-europe-2023-09-06/): **Colin Riddington** \- Database Analyzer and Other Tools
- [September 7, 2023](https://accessusergroups.org/pacific/event/event-driven-programming-with-john-colby/): **John Colby** \- Event Driven Programming
- [September 12, 2023](https://accessusergroups.org/sql-server-with-access/event/fundamentals-of-azure-openai-by-roy-kim/): **Roy Kim** \- Fundamentals of Azure OpenAI
- [September 21, 2023](https://www.daaug.org/Presentations/Details/255): **Armen Stein** \- Advanced Database Design
- [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: **You?** \- Your Presentation Can Be Here! [Contact George Hepworth](https://accessusergroups.org/pacific/contact/)
- [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** \- (topic to be confirmed)
- [January 3, 2023](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, 2023](https://accessusergroups.org/europe/event/access-europe-2024-02-07/): **Carlos Quintero** \- Features of MZ-Tools to make you more productive with VBA **(JUST ADDED)**
- Date To Be Determined: **Thomas Möller** \- Better Access Charts in the new Edge browser control (session postponed from its original September 6, 2023, time slot)

---

‌

## Access Roadmap

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

*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

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

#### Rolling Out

None.

#### Launched

None.