> ## 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: November 19, 2022
- URL: https://nolongerset.com/week-in-review-2022-11-19/
- Published: 2022-11-19T17:32:53.000Z
- Updated: 2026-05-08T12:53:29.000Z
- Description: Highlights include multiple ways to hide sensitive data, a CDO email tester, an improved SQL editor, and updates from the Access dev team.
- 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

- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [The Day I Stopped Using FireFox](https://www.devhut.net/the-day-i-stopped-using-firefox/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [The Power of Data](https://isladogs.co.uk/power-data/index.html)
  - [Hide Sensitive Data](https://isladogs.co.uk/hide-sensitive-data/index.html)
  - *UPDATED:* [Translate and Speak](https://isladogs.co.uk/translate-speak/index.html)
  - *UPDATED:* [Control the Application Interface](https://isladogs.co.uk/control-application-interface/index.html)
  - *UPDATED:* [Attention Seeking Database](https://isladogs.co.uk/attention-seek/index.html)
  - *UPDATED:* [CDO EMail Tester](https://isladogs.co.uk/email-tester/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [What is ASCII for each character?](https://msaccessgurus.com/VBA/WhatisAscii.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Learning From Other Coding Styles](https://nolongerset.com/learning-from-code-styles/)
  - [Learning From Other Languages](https://nolongerset.com/learning-from-other-languages/)
  - [The Reason MS Access Forms and Reports are Limited to 22 Inches](https://nolongerset.com/form-report-max-width/)
  - [Select Entire Module in VBA With Control + Click](https://nolongerset.com/control-click-select-module/)
  - [Select Entire Sub or Function in VBA with a Double-Click](https://nolongerset.com/double-click-select-procedure/)

#### Videos‌

- **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg))  
  - [ESP: Controle la interfaz de la aplicación y busque la atención del usuario](https://www.youtube.com/watch?v=0G24fioPpKM) (*Control the Application Interface*) (1:32:19): *Colin Riddington (English with Spanish subtitles)*
- **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ))  
  - [New and Upcoming in Access](https://www.youtube.com/watch?v=TC8b6DrCh7Y) (1:09:02): *presented by the Microsoft Access Engineering Team*  
    - **Joe Jimenez*: New Web Browser Control*
    - **Sachin Arunkumar*: VBA Macro Code Signing in Access*
    - **Courtney Owen*: Improvements in exporting Access tables to Dataverse*
    - **Dale Rector*: Q&A with the Principal Engineering Manager for MS Access*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))  
  - [Archive Records](https://www.youtube.com/watch?v=eYIYYpK6r3A) (25:47): *Archiving Old Data in your Microsoft Access Database*
  - [InStr Function](https://www.youtube.com/watch?v=U4BSlpEtNsA) (12:58): *Use the InStr Function to Find a String Within a String in Microsoft Access*
  - [Numbers As Text](https://www.youtube.com/watch?v=6egi1exLW4Q) (15:48): *When to Store Numbers in a Text Field in Microsoft Access. Val Function*
  - [Merge Tables](https://www.youtube.com/watch?v=MwYhwaOwuGc) (21:53): *How to Merge Tables From Multiple Sources Into One Master Database in Microsoft Access*
  - [AppActivate](https://www.youtube.com/watch?v=DRIfR80jHG0) (17:45): *Switch Between Open Applications Using AppActivate in Microsoft Access VBA*
  - [Access WatchDog](https://www.youtube.com/watch?v=HsVhU4IjBH4) (2:20): *Microsoft Access WatchDog Template. Reboot PC if Access Database Locks Up*
  - [Logon Automatically](https://www.youtube.com/watch?v=-uVST%5F2iNjY) (12:58): *How to Automatically Logon to Windows on System Start Without a Password (for Windows 10, 11)*
  - [Access Rewind](https://www.youtube.com/watch?v=go7uWzdvgMQ) (2:31): *Richard's "Week-in-Review" for his own videos*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))  
  - [MS Access - Improved SQL Editor](https://www.youtube.com/watch?v=tReY54d2Ww0) (15:13)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))  
  - [Simple Inventory Dashboard](https://www.youtube.com/watch?v=OGFezLKh8mw) (6:44): *Using Dashboards to Visualize Data*
  - [Simple Dynamic Forms](https://www.youtube.com/watch?v=LbJMzrXFOzs) (7:20): *How to Change Controls on a Form Based on Combo Box Selection*

---

## New to Me

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

- [MS Access - Improved SQL Editor](https://www.devhut.net/ms-access-improved-sql-editor/), *by Daniel Pineault (companion article to Daniel's video above)*

---

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

- [December 1, 2022](https://accessusergroups.org/pacific/event/257-2022-12-01/): **Kent Gorell** \- Managing Selection Lists for Quick Data Entry
- [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Colin Riddington** \- Annotating Google Maps in Access
- [December 13, 2022](https://accessusergroups.org/sql-server-with-access/event/sql-server-with-access-2022-12-13/): **Juan Soto** \- Access with SQL Server Academy Part II *([review Part I here](https://www.youtube.com/watch?v=y5zTb1GL2x0))*
- [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Karl Donaubauer** \- (topic to be confirmed)
- [January 5, 2023](https://accessusergroups.org/pacific/event/257-2023-01-05/): **Juanjo Luna** \- Using REST/API calls with Access (Spanish to English translation will be provided) (**JUST ADDED**)
- [January 31, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-01-31/): **Colin Riddington** \- Translate & Speak Using Access
- [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts
- [March 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-03-01/): **Maria Barnes** \- Optimizing Queries in SQL Server
- [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Aleksander Wojtasz** \- (topic to be confirmed)
- [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
- [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 last week (2022-11-12) and this week (2022-11-19). 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

None.

#### Rolling Out

None.

#### Launched

- `MAY 2022`: Access Dataverse Connector