> ## 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 12, 2022
- URL: https://nolongerset.com/week-in-review-2022-11-12/
- Published: 2022-11-12T16:35:25.000Z
- Updated: 2026-05-08T12:53:36.000Z
- Description: Highlights include two new Access User Group recordings, a WizHook sample database and reference, and a couple of videos on macro blocking.
- 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/)*)

  - [VBA – Format As Sentence Case](https://www.devhut.net/vba-format-as-sentence-case/)
  - [VBA – Convert a String to Camel Case](https://www.devhut.net/vba-convert-a-string-to-camel-case/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - *UPDATED:* [View Access Help](https://isladogs.co.uk/access-help/index.html)
  - [AEU9: PowerApps for Access Developers](https://isladogs.co.uk/aeu-9/index.html)
  - [Autofit or Zoom? Match Text to Form Control](https://isladogs.co.uk/autofit-text/index.html)
  - [The WizHook Object - Hidden & Undocumented](https://isladogs.co.uk/wizhook/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Unique Values using Access Form](https://msaccessgurus.com/VBA/UniqueValues.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [My Top 10 Allen Browne Posts](https://nolongerset.com/my-top-allen-browne-posts/)
  - [Dollar Signs at the End of VBA Functions](https://nolongerset.com/dollar-signs-in-vba-functions/)
  - [Karl's Catalog: A Checklist of Access Best Practices](https://nolongerset.com/karls-catalog/)
  - [Leadership Principle: You Can Delegate Authority But Not Responsibility](https://nolongerset.com/delegate-authority-not-responsibility/)
  - [Microsoft Access WizHook References](https://nolongerset.com/microsoft-access-wizhook-references/)

#### Videos‌

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

  - [AEU: PowerApps for Access Developers](https://www.youtube.com/watch?v=3n63LllshIg) (1:04:37): *by George Hepworth*
  - [AP: Hosting Access Applications "in the cloud"](https://www.youtube.com/watch?v=cDTyxEg%5FiJQ) (1:02:48): *by Ned Pajic of [Caspio](https://www.caspio.com/)*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [Blocked!](https://www.youtube.com/watch?v=wUMNxesq%5Fec) (9:08): *How to Deal With the New Security Risk Warning in Microsoft Access*
  - [Random AutoNumbers](https://www.youtube.com/watch?v=Ep9%5FlLxuVDw) (7:38): *Why Use Random AutoNumbers in Microsoft Access*
  - [How to Use Microsoft Access](https://www.youtube.com/watch?v=9ShCcEzf63o) (37:04): *Beginner Tutorial*
  - [Zero Length](https://www.youtube.com/watch?v=0Rv21eKMkrs) (31:56): *The Difference Between Null and Zero Length String. Indicate No Middle Name.*
  - [Word Count](https://www.youtube.com/watch?v=QQGEcN9sUUw) (15:08): *How to Count the Number of Words in a Text Field in Microsoft Access*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))

  - [Understanding Macro Blocking and Unblocking](https://www.youtube.com/watch?v=QZDBx%5FxKjHA) (19:56)
  - [VBA - Camel Case Strings](https://www.youtube.com/watch?v=ZED9C7dYxhQ) (6:46)
  - [Database Encryption Password Protection](https://www.youtube.com/watch?v=OpqnA368S8M) (8:29)
  - [Enable Mouse Wheel Scrolling of Text Box](https://www.youtube.com/watch?v=eHhoKvmwxSw) (5:17)
  - [Database Performance Optimization](https://www.youtube.com/watch?v=XdX7oSxFEjU) (16:15)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [Read File Names into Access](https://www.youtube.com/watch?v=rweYh1Cw4gM) (7:21): *Reading File Names from Your Hard Drive into a Table*
  - [Secure Deployment](https://www.youtube.com/watch?v=FS7nB4rOles) (9:30): *Deploying a Custom Ribbon with your Application*
- **Nifty Access \[Tony Hine, aka Uncle Gizmo\]** ([YouTube channel](https://www.youtube.com/c/NiftyAccessMicrosoft))

  - [TicTacToe - 1a](https://www.youtube.com/watch?v=XEpIf2vNe98) (5:39)
  - [TicTacToe - 2a](https://www.youtube.com/watch?v=0lgnL5%5FprW8) (2:28)

---

## New to Me

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

*Nothing 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/).

- [November 17, 2022](https://www.daaug.org/Presentations/Details/245): **Access Engineering Team** \- New and Upcoming in Access (**JUST ADDED**)
- [December 1, 2022](https://accessusergroups.org/pacific/event/257-2022-12-01/): **Kent Gorell** \- Managing Selection Lists for Quick Data Entry (**JUST ADDED**)
- [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/): ~~**Peter Bryant** \- Automating DSN-less Communications to SQL Server~~ **Karl Donaubauer** \- (topic to be confirmed) (**JUST UPDATED**)
- [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) (**JUST ADDED**)
- [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server (**JUST ADDED**)
- [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) (**JUST ADDED**)

---

‌

## Access Roadmap

*There were no changes to the roadmap between last week (2022-11-05) and this week (2022-11-12). 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