> ## 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: October 22, 2022 - URL: https://nolongerset.com/week-in-review-2022-10-22/ - Published: 2022-10-23T02:51:53.000Z - Updated: 2026-05-08T12:54:00.000Z - Description: Highlights include a reserved word checker utility, executing PowerShell cmdlets from VBA, using Access in an Azure VM, and 5 types of control tips. - 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 - [*Access Releases 6 Issue Fixes in Version 2209 (Released September 26)*](https://techcommunity.microsoft.com/t5/access-blog/access-releases-6-issue-fixes-in-version-2209-released-september/ba-p/3651983), by Linda Lu Cannon - *[SQL for Query to list Relationships in Access database](https://msaccessgurus.com/VBA/Query%5FSQL%5FShowRelationships.htm)*, by Crystal Long - *UPDATED: [Calendar Maker](https://msaccessgurus.com/tool/CalendarMaker.htm)*, by Crystal Long - [*Access – Playing With Database Properties*](https://www.devhut.net/access-playing-with-database-properties/), by Daniel Pineault - [*VBA – Expand Short File or Path*](https://www.devhut.net/vba-expand-short-file-or-path/), by Daniel Pineault - [*VBA – Padding a String To A Desired Length*](https://www.devhut.net/vba-padding-a-string-to-a-desired-length/), by Daniel Pineault - [*VBA – Timers*](https://www.devhut.net/vba-timers/), by Daniel Pineault - *UPDATED:* [*JET ShowPlan Manager Add-In*](https://isladogs.co.uk/jet-showplan-manager-addin/index.html), by Colin Riddington - *UPDATED:* [*Speed Test 8: Optimising Queries*](https://isladogs.co.uk/speed-comparison-tests-8/index.html), by Colin Riddington - *UPDATED:* [*Access/Windows/Office365 Version Check Add-In*](https://isladogs.co.uk/avc-addin/index.html), by Colin Riddington - [*Available Connections Add-In*](https://isladogs.co.uk/available-connections-addin/index.html), by Colin Riddington - [*Compare Control Help Text Methods*](https://isladogs.co.uk/control-help/index.html), by Colin Riddington - [*Greyed Out Controls : Disable or Lock?*](https://isladogs.co.uk/greyed-out-controls/index.html) by Colin Riddington - *[Writing Boilerplate Code by Hand is for Suckers](https://nolongerset.com/upsertstandardmodule/)*, by Mike Wolfe - *[Create a Class Module from a String in Microsoft Access](https://nolongerset.com/upsertclassmodule/)*, by Mike Wolfe - *[Leadership Principles](https://nolongerset.com/leadership-principles/)*, by Mike Wolfe - *[What is Database Normalization?](https://nolongerset.com/under-100-normalization/)* by Mike Wolfe - *[GenerateTVClass(): Auto-Create a TempVars Class Module](https://nolongerset.com/generatetvclass/)*, by Mike Wolfe #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Using Text-to-Speech TTS in Access](https://www.youtube.com/watch?v=LRcv%5FptcyCI) (1:01:46): *by David Nealey and Alessandro Grimaldi* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [All About Access in an Azure VM](https://www.youtube.com/watch?v=VuOKIjLFpgE) (1:23:49): *by George Young* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Multi Language](https://www.youtube.com/watch?v=2mkwBSExnyk) (21:35): *How to Display Microsoft Access Database Labels, Buttons, and Other Controls in Multiple Languages* - [Random Name Generator](https://www.youtube.com/watch?v=VBjXEvQYnQk) (45:55): *How to Build a Random Name Generator in Microsoft Access VBA* - [First Day of the Quarter](https://www.youtube.com/watch?v=wz925sNw1mQ) (17:40): *Find the First Day of the Quarter in Microsoft Access* - [Status Box](https://www.youtube.com/watch?v=LQf8y1YF8RE) (29:08): *Use a Status Box to Display Messages to Users on your Microsoft Access Forms. Great for Long Loops.* - [Sleep](https://www.youtube.com/watch?v=EG0nyiBt154) (21:08): *Using the Sleep Function to Make Your Database Wait in Microsoft Access VBA* - [Coin Toss](https://www.youtube.com/watch?v=CE0tLLwpu3E) (27:05): *How to Generate a Random Coin Toss (or a Thousand) in Microsoft Access VBA* - [Age Demographics - Addendum](https://www.youtube.com/watch?v=TiTm1XmCK7Q) (10:46): *Age Demographics in Microsoft Access Using the Switch Function - TechHelp Addendum* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [VBA - Timers](https://www.youtube.com/watch?v=4-QhF1p1Pys) (22:19) - [VBA - PowerShell](https://www.youtube.com/watch?v=sZ1DFeUlr00) (21:23) - [Microsoft Access - Playing with Database Properties](https://www.youtube.com/watch?v=hnyC8uYgJBU) (24:13) - [Microsoft Access - Special Characters and Reserved Words](https://www.youtube.com/watch?v=aGTw-cg3AtI) (18:22) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Three Expert Data Macros](https://www.youtube.com/watch?v=uvhB8aicmR0) (10:16): *Save Time with 3 More Data Macros!* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[VBA – Run PowerShell Command](https://www.devhut.net/vba-run-powershell-command/)*, by Daniel Pineault --- ‌ ## 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/). - [October 25, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-10-25/): **Duane Hookom** \- Embedding a Table of Contents into a Report - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [November 3, 2022](https://accessusergroups.org/pacific/event/257-2022-11-03/): **Ned Pajic** \- Hosting Access Applications "in the cloud" - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Colin Riddington** \- Annotating Google Maps in Access - [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 **(JUST ADDED)** --- ‌ ## Access Roadmap *There were no changes to the roadmap between last week (2022-10-15) and this week (2022-10-22). The Access roadmap was last updated on May 31, 2022, and the development priorities 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 - `JAN 2021`: Access: ODBC Interface Support (without ACE Redistributable Engine) - `JAN 2021`: Access: DAO Interface Support (without ACE Redistributable Engine)