> ## 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: May 20, 2023
- URL: https://nolongerset.com/week-in-review-2023-05-20/
- Published: 2023-05-20T23:55:34.000Z
- Updated: 2026-05-08T12:49:48.000Z
- Description: Highlights include a series on building a calculator in Access, selling Access solutions with Juan Soto, and creating an HTML table from an Access table.
- 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

- **Maria Barnes** ([Business Data Bytes Newsletter](https://www.linkedin.com/newsletters/business-data-bytes-6892816951870066688/))

  - [Why should I convert my Microsoft Access legacy Web Browser control to the New Edge Browser Control?](https://www.linkedin.com/pulse/why-should-i-convert-my-microsoft-access-legacy-web-browser-barnes/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Is It Time To Panic, Possibly!](https://www.devhut.net/is-it-time-to-panic-possibly/)
  - [Generate An HTML Table String From An Access Table](https://www.devhut.net/generate-an-html-table-string-from-an-access-table/)
  - [Identifying Excel Data Connections](https://www.devhut.net/identifying-excel-data-connections/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Access Application Translator](https://isladogs.co.uk/app-translator/index.html) *(Updated)*
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Go to New Record when Form Loads](https://msaccessgurus.com/VBA/Form%5FNewRecordLoad.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Should you install 32-bit or 64-bit Access in 2023?](https://nolongerset.com/32-bit-or-64-bit-access-in-2023/)
  - [VBA Cracks RedMonk's Stack Overflow Top 15 for 2023](https://nolongerset.com/redmonk-rankings-23q1/)
  - [UPDATE: Office Apps WILL Run on Windows Server After October 2025](https://nolongerset.com/ms365-on-windows-server/)
  - [Documentation-First Development](https://nolongerset.com/documentation-first-development/)
  - [Instantly "Copy" Huge Files Using Hard Links in Windows](https://nolongerset.com/hard-links/)

#### Videos‌

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

  - [Selling Access solutions – Part II](https://www.youtube.com/watch?v=Vrmq4b-2nto) (56:46): *by Juan Soto*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [Building a Calculator in Microsoft Access - Part 1](https://www.youtube.com/watch?v=CA3-P7UwygA) (35:25)
  - [Building a Calculator in Microsoft Access - Part 2](https://www.youtube.com/watch?v=1ErSwHelKig) (17:18)
  - [Building a Calculator in Microsoft Access - Part 3](https://www.youtube.com/watch?v=fqP1n6gCXus) (17:25)
  - [Variable as Default Value](https://www.youtube.com/watch?v=LW3ily6MT2s) (15:29): *How to Specify a Form Field's Default Value from VBA Code in Microsoft Access*
  - [IsTrusted](https://www.youtube.com/watch?v=O%5F5EuMRy2lc) (16:00): *How to Tell if Your Microsoft Access Database is Running From a Trusted Folder*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))

  - [Output Tables and Queries As HTML Tables](https://www.youtube.com/watch?v=Q8hPfbeS%5FGU) (23:23)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [Comparison Operators](https://www.youtube.com/watch?v=lg1WFxTp0ro) (4:57): *A Beginner's Guide to Comparison Operators in Access Queries*
  - [Query Null and Blank](https://www.youtube.com/shorts/NjRyt3-bxpk) (Short): *Never Miss a Record Again: How to Query Null and Blank Values in a Database*
  - [Link to External Data](https://www.youtube.com/watch?v=tP1CieLdIf8) (7:53): *Connecting and Working with External Data in Microsoft Access*
  - [Wildcards in Queries](https://www.youtube.com/shorts/vEbpgjhRHMo) (Short): *Simplify Your Microsoft Access Queries with Wildcards*
  - [Referential Integrity](https://www.youtube.com/watch?v=msO%5FnUABlOQ) (5:46): *Ensuring Data Consistency and Accuracy with Referential Integrity*

---

## New to Me

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

- [*One use case for NOT using schema prefixes*](https://www.red-gate.com/simple-talk/homepage/schema-prefix-at-stack-overflow/), by Aaron Bertrand

---

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

- [May 30, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-northwind-2-0/): **Tom van Stiphout** and **Kim Young** \- Northwind 2.0
- [June 1, 2023](https://accessusergroups.org/pacific/event/maintaining-data-integrity-during-migrations-with-tom-wickerath-and-kent-gorrell/): **Tom Wickerath** and **Kent Gorrell** \- Maintaining Data Integrity during Migrations **(JUST ADDED)**
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Tom van Stiphout**\- Introducing Northwind 2.0
- [June 15, 2023](https://www.daaug.org/Presentations/Details/252): **Alessandro Grimaldi** \- "VBA Pills" - Access Tips and Tricks
- [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access
- [July 6, 2023](https://accessusergroups.org/pacific/event/great-interface-design-with-greg-regan/): **Greg Regan** \- Great Interface Design **(JUST ADDED)**
- [July 20, 2023](https://www.daaug.org/Presentations/Details/253): **Mike Wolfe** \- Form Templates in Microsoft Access
- [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow)
- [August 3, 2023](https://accessusergroups.org/pacific/event/global-error-handlers-with-tom-van-stiphout-and-kim-young/): **Tom van Stiphout** and **Kim Young** \- Global Error Handlers **(JUST ADDED)**
- [August 17, 2023](https://www.daaug.org/Presentations/Details/251): **Richard Rost** \- Custom Data Entry Filter Functions in Access
- [August 29, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-08-29/): **Lenni Lobel** \- Introduction to Azure Cosmos DB
- [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp
- [September 7, 2023](https://accessusergroups.org/pacific/event/event-driven-programming-with-john-colby/): **John Colby** \- Event Driven Programming **(JUST ADDED)**
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access
- [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- (topic to be confirmed)

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-05-13) and this one (2023-05-20).*

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