> ## 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: March 4, 2023
- URL: https://nolongerset.com/week-in-review-2023-03-04/
- Published: 2023-03-04T20:47:54.000Z
- Updated: 2026-05-08T12:51:16.000Z
- Description: Highlights include a trick to update parent form calculations without using subform events, translation tools in Access, and early/late binding declarations.
- 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

- **Philipp Stiefel** ([CodeKabinett](https://codekabinett.com/index.php?Lang=2))

  - [Update Parent Form with Sub Form References](https://codekabinett.com/rdumps.php?Lang=2&targetDoc=update-parent-form-sub-form-references)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Access – Check If Anyone Has The Database Open](https://www.devhut.net/access-check-if-anyone-has-the-database-open/)
  - [Access – VBA – Get The Next AutoNumber Value](https://www.devhut.net/access-vba-get-the-next-autonumber-value/)
  - [VBA – Universal RegEx Match Function](https://www.devhut.net/vba-universal-regex-match-function/)
  - [VBA – Early and Late Binding Declarations](https://www.devhut.net/vba-early-and-late-binding-declarations/)
  - [VBA – RegEx – Retrieve HTML Img Src MIME Type](https://www.devhut.net/vba-regex-retrieve-html-img-src-mime-type/)
  - [Access – Hiding Database Objects](https://www.devhut.net/access-hiding-database-objects/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Emulated Split Form](https://isladogs.co.uk/emulated-split-form/index.html) (*UPDATED*)
  - [Automatic Form Resizing - Part 4](https://isladogs.co.uk/automatic-form-resizing-4/index.html) (*UPDATED*)
  - [Automatic Form Resizing - Part 3](https://isladogs.co.uk/automatic-form-resizing-3/index.html) (*UPDATED*)
  - [Automatic Form Resizing - Part 2](https://isladogs.co.uk/automatic-form-resizing-2/index.html) (*UPDATED*)
  - [Automatic Form Resizing - Part 1](https://isladogs.co.uk/automatic-form-resizing-1/index.html) (*UPDATED*)
  - [AEU13: Optimizing Queries in SQL Server](https://isladogs.co.uk/aeu-13/index.html)
  - [Use Multiple Tags on Form Controls](https://isladogs.co.uk/multiple-tags/index.html)
  - [Set Default Control Properties in Forms & Reports](https://isladogs.co.uk/default-control-properties/index.html)
  - [Access News & Events](https://isladogs.co.uk/news-events/index.html) (*UPDATED*)
  - [Access Videos](https://isladogs.co.uk/videos/index.html) (*UPDATED*)
  - [Access Application Translator](https://isladogs.co.uk/app-translator/index.html) (*UPDATED*)
  - [Translate and Speak](https://isladogs.co.uk/translate-speak/index.html) (*UPDATED*)
  - [BUG: Disabled Datasheet Fields Undone By Events!](https://isladogs.co.uk/datasheet-event-bug/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Loop folders, Link CSV files, Document structure using VBA](https://msaccessgurus.com/tool/LoopLinkDocument.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Password Generator](https://nolongerset.com/password-generator/)
  - [MS Access Windows API Viewer](https://nolongerset.com/windows-api-viewer/)
  - [Updating Linked SQL Server Views in Access When Changing the Underlying Table Data Types](https://nolongerset.com/update-view-field-type-change/)
  - [Richard Rost: Newest Access MVP](https://nolongerset.com/richard-rost-access-mvp/)
  - [Access DevCon Vienna 2023: April 27-28](https://nolongerset.com/devcon-2023-announcement/)

#### Videos‌

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

  - [Translation Tools using Access](https://www.youtube.com/watch?v=ncVquUreN%5F4) (1:10:34): *by Colin Riddington*
- **Philipp Stiefel** ([YouTube channel](https://www.youtube.com/c/codekabinettcomen/featured))

  - [Update Parent Form with Sub Form Control References](https://www.youtube.com/watch?v=pcBzFCWqTic) (22:22)
- **Alessandro Grimaldi** ([YouTube channel](https://www.youtube.com/user/papillon0365))

  - [Tutorial: Continuous form column sorter](https://www.youtube.com/watch?v=xWbD1Kw8Ock) (0:27)
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [#7 Quick Queries](https://www.youtube.com/watch?v=V4FmavCn2xY) (50:14): *Hiding Access Interface, Runtime w Full Access, More!*
  - [Same Value Multiple Records](https://www.youtube.com/watch?v=ojwrM5C%5FSHk) (16:06): *Dynamic Default Value: Use the Same Value For Multiple Records During Data Entry in Microsoft Access*
  - [Microsoft MVP Award](https://www.youtube.com/watch?v=Zqexa-4qlHs) (2:28): *I've Been Given the Microsoft MVP Award for a 3rd Time!*
  - [Association Database, Part 10](https://www.youtube.com/watch?v=oW0NfsCePjI) (24:37): *Multi-Level Group Forms*
  - [Association Database, Part 11](https://www.youtube.com/watch?v=pyNAGBvBra4) (29:35): *Group Subform on the Person Form*
  - [Colors in Access VBA](https://www.youtube.com/watch?v=9e8AlVYv2UM) (17:24): *How to Get the Exact Color You Want in Microsoft Access VBA*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [7 Methods to Clean Your Data](https://www.youtube.com/watch?v=JdY6yRSgRC8) (23:26): *7 Data Manipulations to Make Your Data Look Great!*

---

## New to Me

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

- *[Lessons learned after 20 years of developing, managing and selling a software product](https://levelup.gitconnected.com/lessons-learned-after-20-years-of-developing-managing-and-selling-a-software-product-1fcc05f45b03)*, by [Eugenio Tacchini](https://medium.com/@eugenio.tacchini?source=post%5Fpage-----1fcc05f45b03--------------------------------)

---

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

- [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- Creating calendar format reports
- [April 6, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Tom Wickerath and George Hepworth** \- Migrating Access Tables to SQL Server, a Comparison of Methods
- [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna**
- [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access
- [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access
- [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow)
- [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access (**TOPIC JUST ADDED**)
- [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data (**TOPIC JUST ADDED**)
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- (topic to be confirmed)

---

‌

## Access Roadmap

*There was *ONE CHANGE* to the roadmap between the last Week in Review (2023-02-25) and this one (2023-03-04).*

- A duplicate feature was added, "Modern Web Browser Control"

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