> ## 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: October 21, 2023
- URL: https://nolongerset.com/week-in-review-2023-10-21/
- Published: 2023-10-22T03:50:18.000Z
- Updated: 2026-05-08T12:36:21.000Z
- Description: Highlights include updateable cross-tab forms with Pat Hartman, George Hepworth's Searchable Catalog project, and Richard Rost's Decision Tree database.
- 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

- **[Official Access Blog](https://techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog)**

  - [Access Releases 8 Issue Fixes in Version 2309 (Released September 28th, 2023)](https://techcommunity.microsoft.com/t5/access-blog/access-releases-8-issue-fixes-in-version-2309-released-september/ba-p/3957481), *by Linda Lu Cannon*
- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))

  - [Streamlining Form VBA Custom Report Wizard - 16 ](https://www.msaccesstips.com/2023/10/streamlining-form-vba-custom-report.html)
- **Mathieu Guindon** ([Rubberduck VBA](https://rubberduckvba.blog/))

  - [Progress on the RD3 Editor Shell](https://rubberduckvba.blog/2023/10/17/progress-on-the-rd3-editor-shell/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Extend Access across Multiple Monitors](https://isladogs.co.uk/extend-access-across-monitors/index.html)
  - [Synchronise Subform Scrolling](https://isladogs.co.uk/subform-sync-scroll/index.html) *(updated)*
  - [Accurately Move Forms & Controls](https://isladogs.co.uk/move-forms-controls/index.html) *(updated)*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Advanced Report Builder Form](https://nolongerset.com/report-builder-form/)
  - [Reader Question: Is it worth running an Access front-end from a RAM disk?](https://nolongerset.com/ram-disk/)
  - [Advanced Report Builder](https://nolongerset.com/advanced-report-builder/)
  - [Access 101: Local vs. Linked Tables](https://nolongerset.com/local-vs-linked-tables/)
  - [Productized Services: Finding the Sweet Spot Between Products and Services](https://nolongerset.com/productized-services/)

#### Videos‌

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

  - [Updateable Bound Forms with Denormalized Data](https://www.youtube.com/watch?v=U2yrJ9Cdw78) (01:30:11): *with Pat Hartman (Re-released)*
- **George Hepworth** ([YouTube channel](https://www.youtube.com/@GroverParkGeorge))

  - [Building the Lander Trail Foundation Searchable Catalog, Part 2](https://www.youtube.com/watch?v=5tQtNX0Up8E) (17:25): *Filtering and Searching*
  - [Building the Lander Trail Foundation Searchable Catalog, Part 3](https://www.youtube.com/watch?v=jIJ8mfQRr0M) (17:06): *Display Many-to-Many Relationships*
  - [Building the Lander Trail Foundation Searchable Catalog, Part 4](https://www.youtube.com/watch?v=w5BMeVEo1K8) (06:09): *Leverage SQL Server Views*
  - [Building the Lander Trail Foundation Searchable Catalog, Part 5](https://www.youtube.com/watch?v=Qf8zrp951aE) (10:00): *Roles for List and Detail Views*
  - [Building the Lander Trail Foundation Searchable Catalog, Part 6](https://www.youtube.com/watch?v=yPd0cALExXI) (11:27): *Patch Records in the source table*
  - [Building the Lander Trail Foundation Searchable Catalog, Part 7](https://www.youtube.com/watch?v=SuQKYgUMpgc) (11:21): *Context and App Variables*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))

  - [OpenAI](https://www.youtube.com/watch?v=pohDppXUcHY) (17:53): *Unlocking the Potential of ChatGPT in Microsoft Access via OpenAI's API - Part 1 of 2*
  - [Decision Tree Part 3: Editor Form](https://www.youtube.com/watch?v=%5F%5FA9jvWtEoQ) (21:24)
  - [Decision Tree Part 4: Editor Navigation](https://www.youtube.com/watch?v=5piY39PXiys) (25:07)
  - [Decision Tree Part 5: Viewer Form](https://www.youtube.com/watch?v=KZ71GtBOl%5Fk) (24:14)
  - [Decision Tree Part 6: Drag-and-Drop Images](https://www.youtube.com/watch?v=RFgfvRNBPjU) (28:11)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/@PharosTechnology))

  - [Format() Your Forms with VBA](https://www.youtube.com/watch?v=Lv3qcxmCqbU) (06:55): *Format Data Like a Pro with the Format Function*
  - [Read 20K File Names in Seconds](https://www.youtube.com/watch?v=csOvJeSV9I0) (08:05): *Using VBA to Optimize Data Input in Microsoft Access*

### Select Open Source Projects: New Releases

- **[msaccess-vcs-addin](https://github.com/joyfullservice/msaccess-vcs-addin#version-control-add-in-msaccess-vcs-addin):** [v4.0.25-beta (dev branch)](https://github.com/joyfullservice/msaccess-vcs-addin/releases/tag/v4.0.25-beta)

---

## New to Me

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

- *[IT Projects can fail when technical RFP’s and business cases aren’t aligned](https://greenmerits.blogspot.com/2023/10/it-projects-can-fail-when-technical.html)*

---

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

- [October 31, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-10-31/): **Crystal Long** \- Two free tools: List Objects from your Access Databases and Code Documenter
- [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))
- [November 16, 2023](https://www.daaug.org/Presentations/Details/256): **Alexander Denz** \- ChatGPT in Access
- [November 22-23, 2023](https://ukaug.co.uk/next-conference/): (IN-PERSON!) UK Access User Group Conference (at the offices of Gordon Associates in Cheltenham)
- [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
- [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
- [May 1, 2024](https://accessusergroups.org/europe/event/access-europe-2024-05-01/): **Colin Riddington** \- View & Edit Import/Export (IMEX) Data Task Specifications

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-10-14) and this one (2023-10-21).*

*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