> ## 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 5, 2022
- URL: https://nolongerset.com/week-in-review-2022-11-05/
- Published: 2022-11-06T03:23:15.000Z
- Updated: 2026-05-08T12:53:44.000Z
- Description: Highlights include a new Access MVP (congrats Juanjo Luna!), a deep dive into the FileSystemObject, and using UIAutomation to interact with the ribbon.
- Author: Mike Wolfe
- Tags: Week in Review, #Import 2026-05-20 02:59

Congratulations to the newest Microsoft Access MVP, mi buen amigo, [**Juanjo Luna**](https://mvp.microsoft.com/en-us/PublicProfile/5005027?fullName=Juan%20Jose%20Luna%20Aleixos)! Well deserved.

[![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/11/image-8.png)](https://mvp.microsoft.com/en-us/PublicProfile/5005027?fullName=Juan%20Jose%20Luna%20Aleixos)

Juan Jose Luna Aleixos

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

  - [What is a Data Fabric?](https://www.linkedin.com/pulse/what-data-fabric-maria-barnes/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [VBA – FSO Files, Folders, Drives and More](https://www.devhut.net/vba-fso-files-folders-drives-and-more/)
  - [VBA – Bring a Window to the Front Without Knowing Its Hwnd or Title](https://www.devhut.net/vba-bring-a-window-to-the-front-without-knowing-its-hwnd/)
  - [VBA – Ribbon Automation Via UIAutomation](https://www.devhut.net/vba-ribbon-automation-via-uiautomation/)
  - [VBA – Find A Window By Its Title and Bring It To The Front](https://www.devhut.net/vba-find-a-window-by-its-title-and-bring-it-to-the-front/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - *UPDATED:* [Compare Control Help Text Methods](https://isladogs.co.uk/control-help/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Basic SQL Syntax](https://msaccessgurus.com/VBA/SQL%5FBasicSyntax.htm)
  - [Draw Boxes around Text in Access for Shortcuts Report](https://www.linkedin.com/pulse/draw-boxes-around-text-access-shortcuts-report-crystal-strive4peace-/)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Using Temp Tables as Report Record Sources](https://nolongerset.com/temp-table-recordsources/)
  - [What does RBAR mean?](https://nolongerset.com/under-100-rbar/)
  - [Sorting Arrays of Strings in Access with WizHook](https://nolongerset.com/sortstringarray/)
  - [Checking Version Compatibility with NetOffice](https://nolongerset.com/version-compatibility-checker/)
  - [What is rowversion in SQL Server?](https://nolongerset.com/under-100-rowversion/)

#### Videos‌

- **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA))  
  - [Control Help Text](https://www.youtube.com/watch?v=K8xlE6Rv8cI) (17:44): *5 Ways of Providing Control Help Text*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))  
  - [RecordCount](https://www.youtube.com/watch?v=bu6A5VPJhnc) (20:40): *How to Show What Record You're On and How Many Total Records There Are in Your Microsoft Access Form*
  - [TimeValue](https://www.youtube.com/watch?v=EtSax-1olY0) (16:19): *Use the TimeValue Function to Get Just the Time Portion of a DateTime Field in Microsoft Access*
  - [Hour Minute Second](https://www.youtube.com/watch?v=52QgIxRN3pM) (11:32): *Find the Busiest Times of the Day Using the Hour, Minute, and Second Functions in Microsoft Access*
  - [DateValue](https://www.youtube.com/watch?v=9IjGsd3fWIE) (11:46): *Use the DateValue Function to Get Just the Date Portion of a DateTime Field in Microsoft Access*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))  
  - [The Danger of FileLen](https://www.youtube.com/watch?v=-0vtS8y%5FHk8) (3:38)
  - [VBA - Creating Directories](https://www.youtube.com/watch?v=EWovmZOL4Jc) (12:24)
  - [VBA – Bring a Window to the Front - Part 1](https://www.youtube.com/watch?v=440AT%5FeZGTE) (10:54)
  - [VBA – Bring a Window to the Front - Part 2](https://www.youtube.com/watch?v=kW9SdpRQITE) (20:42)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))  
  - [Help Users with Tags](https://www.youtube.com/watch?v=GFGEHtwTzrE) (5:15): *Tag Property Examples for Assisting Users on a Form*

---

## New to Me

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

- *[How to communicate effectively as a developer](https://www.karlsutt.com/articles/communicating-effectively-as-a-developer/)*, by Karl Sutt
- [*Bang Vs. Dot in Forms*](https://rogersaccessblog.blogspot.com/2017/11/bang-vs-dot-in-forms.html), by Roger Carlson

---

## 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 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
- [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
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access

---

‌

## Access Roadmap

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