> ## 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: September 10, 2022 - URL: https://nolongerset.com/week-in-review-2022-09-10/ - Published: 2022-09-11T03:59:00.000Z - Updated: 2026-05-08T12:54:53.000Z - Description: Highlights include a major milestone for (and giveaway from) Richard Rost, a data classification guide, and an Access QR code generator. - 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 – QR Code Generator*](https://www.devhut.net/access-qr-code-generator/), by Daniel Pineault - [*Why Can't I Create an ACCDE file? A Troubleshooting Guide*](https://isladogs.co.uk/accde-create-fail/index.html), by Colin Riddington - *UPDATED:* [*JSON Analyse & Transform for Access (JATFA)*](https://isladogs.co.uk/json-analyse-transform/index.html), by Colin Riddington - *UPDATED:* [*Annotate Google Maps in Access*](https://isladogs.co.uk/annotate-google-maps/index.html), by Colin Riddington - [*Oops - how did that make an ACCDE file?*](https://isladogs.co.uk/accde-create-error/index.html), by Colin Riddington - [*AEU7: Optimising Queries & the JET ShowPlan*](https://isladogs.co.uk/aeu-7/index.html), by Colin Riddington - [*Introducing the NENAPUTS query: An "ambiguous outer joins" journey*](https://isladogs.co.uk/nenaputs-query/index.html), by Colin Riddington - *[Design your data with security in mind](https://www.linkedin.com/pulse/design-your-data-security-mind-maria-barnes/)*, by Maria Barnes - *[3 Benefits of Documenting Your Debugging Process](https://nolongerset.com/debug-documentation-benefits/)*, by Mike Wolfe - *[7 Ways to Loop Through Controls on a Microsoft Access Form](https://nolongerset.com/loop-through-controls/)*, by Mike Wolfe - *[ObscureInfo(): Hide Sensitive Information in Access Form Controls](https://nolongerset.com/obscureinfo/)*, by Mike Wolfe - *[Access DevCon Vienna 2022 - Access Roadmap Update](https://nolongerset.com/devcon-2022-access-roadmap-update/)*, by Mike Wolfe - *[Understanding Signed and Unsigned Numbers in VBA](https://nolongerset.com/signed-vs-unsigned-numbers/)*, by Mike Wolfe #### Videos *Congratulations to Richard Rost on 20 years of computer training videos, 50,000 customers, and 37+ Million YouTube views!* - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [AEU: Optimising Queries & the JET ShowPlan](https://www.youtube.com/watch?v=mVe3InnJaAE) (1:08:39): *by Colin Riddington* - [Codifying Long Names into unique codes](https://www.youtube.com/watch?v=KJs0ENgdwDI) (1:02:19): *by Jack Stockton* - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Access Version Checker](https://www.youtube.com/watch?v=euad5S-wOig) (8:13): *Ultimate Access Version & References Checker ADD-IN* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Word Doc Properties](https://www.youtube.com/watch?v=yO8vszeccQE) (14:06): *Word Document Properties (Built-in and Custom) and Fields* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [20 Years!](https://www.youtube.com/watch?v=LF-cIMxg43g) (9:15): *Computer Learning Zone's 20th Anniversary Giveaway!* - [Check Box Color](https://www.youtube.com/watch?v=9h8UNEozj0s) (20:09): *How to Change the Color of a Check Box in Microsoft Access* - [Requery Subform](https://www.youtube.com/watch?v=bssckniacAY) (35:44): *How to Requery Records in a Subform Based on Criteria From the Parent Form in Microsoft Access* - [Button Shortcut Keys](https://www.youtube.com/watch?v=HexBP7Ja2n8) (15:50): *Use Shortcut Keys, Default, and Cancel Properties to Push Command Buttons in Microsoft Access* - [Open Form to a New Record](https://www.youtube.com/watch?v=3dPxqipspMI) (14:13): *How to Open a Form and Go To a New Record and a Specific Field in Microsoft Access* --- ## 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/). - [September 13, 2022](https://accessusergroups.org/sql-server-with-access/event/sql-server-with-access-2022-09-13/): **Juan Soto (?)** \- SQL Server with Access Academy Part 1 - [September 15, 2022](https://www.daaug.org/Presentations/Details/243): **George Hepworth** \- Book Collection Management Using Power Apps (and Access) - [September 27, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-09-27/): **Alessandro Grimaldi** \- Using Text-to-Speech (TTS) in Access (**JUST ADDED**) - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Cataloguing and searching emails with Access - [October 6, 2022](https://accessusergroups.org/pacific/event/257-2022-10-06/): **Brian Krotine** \- Hosting Access Applications "in the cloud" - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts --- ## Access Roadmap *There were *NO CHANGES* to the roadmap between last week (2022-09-03) and this week (2022-09-10).* 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, *[Changes to Our Public Roadmap and How We Communicate Access Feature Priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075)*. 1. Inconsistent Database Error Fix 2. New (Modern) Web Browser Control (to support Chromium Edge) 3. Enabling Large Address Aware (LAA) for 32-Bit Access 4. SQL Monaco Editor 5. 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)