> ## 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 24, 2022 - URL: https://nolongerset.com/week-in-review-2022-09-24/ - Published: 2022-09-25T02:00:35.000Z - Updated: 2026-05-08T12:54:32.000Z - Description: Highlights include bug fixes in Access v2208, Microsoft's new Office update strategy, creating ACCDB/ACCDE files using code, and a series on TempVars. - 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 5 Issue Fixes in Version 2208 (Released Aug 31)*](https://techcommunity.microsoft.com/t5/access-blog/access-releases-5-issue-fixes-in-version-2208-released-aug-31/ba-p/3632918), by Michael Aldridge - *[VBA to make PowerPoint Slide Index](https://msaccessgurus.com/VBA/PowerPoint%5FSlideIndex.htm)*, by Crystal Long - [*Access – Manipulating and Parsing Text*](https://www.devhut.net/access-manipulating-and-parsing-text/), by Daniel Pineault - [*Should We Be Afraid of Microsoft’s New Update Strategy?*](https://www.devhut.net/should-we-be-afraid-of-microsofts-new-update-strategy/), by Daniel Pineault - [*Microsoft Office Trusted Documents and Trusted Locations*](https://www.devhut.net/microsoft-office-trusted-documents-and-trusted-locations/), by Daniel Pineault - [*Compile Modules using code*](https://isladogs.co.uk/compile-modules/index.html), by Colin Riddington - [*Create ACCDB & ACCDE files using code*](https://isladogs.co.uk/create-accde-code/index.html), by Colin Riddington - *UPDATED:* [*View Database Objects & Metadata*](https://isladogs.co.uk/view-database-objects/index.html), by Colin Riddington - *[Namespaces in VBA](https://nolongerset.com/namespaces-in-vba/)*, by Mike Wolfe - *[A Safer Way to Use TempVars](https://nolongerset.com/a-safer-way-to-use-tempvars/)*, by Mike Wolfe - *[TV: The TempVars Class Module](https://nolongerset.com/tv-class/)*, by Mike Wolfe - *[Beware TempVars in Queries](https://nolongerset.com/beware-tempvars-in-queries/)*, by Mike Wolfe - *[Safely Using TempVars in Queries](https://nolongerset.com/safely-using-tempvars-in-queries/)*, by Mike Wolfe #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Using SQL Server with Access](https://www.youtube.com/watch?v=3qRhImJUIyM) (1:02:32): *by Maria Barnes* - [SQL Server Academy: Introduction to SQL Server with Access](https://www.youtube.com/watch?v=y5zTb1GL2x0) (54:30): *by Juan Soto* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [Book Collection Management Using Power Apps (and Access)](https://www.youtube.com/watch?v=Y5kjyx1qIXY) (1:06:21): *by George Hepworth* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Before Update](https://www.youtube.com/watch?v=VW9szQr92xc) (15:52): *Use the Before Update Event in Microsoft Access VBA to Cancel Editing a Field in Certain Conditions* - [Synchronize Subforms](https://www.youtube.com/watch?v=Zq-A03jdkIg) (22:06): *How to Synchronize Multiple Related Subforms in Microsoft Access Without Any VBA Programming* - [InputBox](https://www.youtube.com/watch?v=-3Z7DMTf%5FPg) (15:59): *Use the InputBox Function in Microsoft Access VBA to Prompt for User Input, e.g. a Manager Password* - [Link Master/Child Fields](https://www.youtube.com/watch?v=cSc9ny1ac%5F0) (9:53): *What are the Link Master Fields and Link Child Fields Properties in Microsoft Access Subforms?* - [DateSerial](https://www.youtube.com/watch?v=PfGwjj%5FFc3M) (14:45): *How To Use DateSerial in Microsoft Access to Create a Valid Date Value From the Year, Month, and Day* - [Access Beginner 2](https://www.youtube.com/watch?v=%5Fhwpwq26NIM) (1:49:26): *Microsoft Access Beginner Level 2 Complete FULL Course. Form Design. Intro to Relationships. More!* - [Sequential Annual Coding](https://www.youtube.com/watch?v=qnjcGpc8TKc) (19:19): *Sequential Annual Coding for Customers Based on the Year their Record is Created in Microsoft Access* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [Exploring the Microsoft Access WebBrowser Control](https://www.youtube.com/watch?v=bqUwkijCvQI) (53:17) - [VBA Error Handling Basics](https://www.youtube.com/watch?v=G4MCQL6HydY) (29:51) - [Creating Trusted Locations and Documents In Microsoft Office](https://www.youtube.com/watch?v=QRWufXhnwpM) (31:54) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Three Expert Wait Screens](https://www.youtube.com/watch?v=p6-mgHHBr%5F8) (12:08): *Real Life Examples and Code for Progress Notification Screens* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*Technical Writing for Developers*](https://css-tricks.com/technical-writing-for-developers/), by [Eluda](https://css-tricks.com/author/eluda/) --- ## 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 27, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-09-27/): **Alessandro Grimaldi** \- Using Text-to-Speech (TTS) in Access - [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-17) and this week (2022-09-24). The Access roadmap was last updated on May 31, 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, *[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)