> ## 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: June 4, 2022 - URL: https://nolongerset.com/week-in-review-2022-06-04/ - Published: 2022-06-04T14:18:50.000Z - Updated: 2026-05-08T12:56:59.000Z - Description: Highlights include major changes to the Access roadmap, Richard Rost's Beginner Access video course is now free, and research on developer interviews. - 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 - [*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), by Michael Aldridge - *[The science of interviewing developers](https://stackoverflow.blog/2022/05/23/the-science-of-interviewing-developers/)*, by Isaac Lyman at stackoverflow.com - [*Power Automate – Flow – Loosing HTML Tags*](https://www.devhut.net/power-automate-flow-loosing-html-tags/), by Daniel Pineault - [*Getting Website Info Without Using a WebBrowser Control*](https://www.devhut.net/getting-website-info-without-using-a-webbrowser-control/), by Daniel Pineault - *[Is Your Data Being Used as an Asset? Or is it a Pain in the…](https://www.linkedin.com/pulse/your-data-being-used-asset-pain-maria-barnes/?trackingId=iAzX9MsaQoCuiyxIHetJNQ%3D%3D)*, by Maria Barnes #### Discussions - [VBA - How to open folder without knowing the full name](https://stackoverflow.com/q/72364455/154439) - [](https://stackoverflow.com/questions/72431994/delete-viewing-sql-server-table-in-access)[#DELETE viewing SQL Server table in Access](https://stackoverflow.com/q/72431994/154439) *The most recent bug in Access 365 rears its ugly head.* - [Is it possible to search for gaps between records?](https://www.access-programmers.co.uk/forums/threads/is-it-possible-to-search-for-gaps-between-records.323412/) #### Videos - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Nz Function](https://www.youtube.com/watch?v=Iv1RyLFqmZ4) (2:16): *Avoiding pitfalls when data has Null instead of an actual value \~ DataPig* \- [Left and Right Functions](https://www.youtube.com/watch?v=QObcjX%5FIGBY) (2:00): *Left and Right functions in Microsoft Access \~ DataPig* \- [InStr Function](https://www.youtube.com/watch?v=e50lhbpC1wM) (7:22): *InStr (in string ) function in Microsoft Access \~ DataPig* \- [IIF Function](https://www.youtube.com/watch?v=qEuEvoRYRLc) (4:36): *The versatile Immediate If (IIF) Function \~ DataPig* \- [Delete Query + Subquery](https://www.youtube.com/watch?v=ae0WFnnFjv4) (1:21): *Delete Query with SubQuery \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Military Time](https://www.youtube.com/watch?v=jJgNunOU29I) (10:51): *How to Enter and Display Military Time (24 Hour Time) Without a Colon Separator in Microsoft Access* \- [Terms of Sale](https://www.youtube.com/watch?v=Jp%5FYPWfWDh8) (16:19): *How to Select Different Terms of Sale Text for Invoices Based on Type of Sale in Microsoft Access* \- [Format Property & Function](https://www.youtube.com/watch?v=sBpNm2HMNZM) (9:09): *How to Change the Way Data is Displayed with the Format Property and Function in Microsoft Access* \- [List Items Edit Form Set Value](https://www.youtube.com/watch?v=-t2pns6LzwI) (11:25): *How To Set the Return Value in a Combo Box After Using a List Items Edit Form in Microsoft Access* \- [Fix Poor Quality Images](https://www.youtube.com/watch?v=bz1%5FyR0eA%5Fc) (13:13): *How to Fix Poor Image Quality in your Microsoft Access Reports when Printing or Creating PDFs* \- [Access Beginner 2, Lesson 1](https://www.youtube.com/watch?v=rcw9i35BgiE) (9:01): *Microsoft Access Beginner 2, Lesson 01: Getting Started. Security Warning. Trusted Location. Review.* \- [Access Beginner 2, Lesson 0](https://www.youtube.com/watch?v=zzYUA9KRk-A) (4:08): *Microsoft Access Beginner 2, Lesson 00: Introduction. What's Covered.* \- [Full Course Microsoft Access](https://www.youtube.com/watch?v=SpMSeIfloSk) (3:01): *I've Decided to Post My Entire Microsoft Access Beginner Tutorial Series Here on YouTube For FREE!* *NOTE: The new videos posted to Crystal's YouTube page are part of an [effort to preserve the Access content of retiring creators](https://www.access-programmers.co.uk/forums/threads/status-of-databaseanswers-org.322983/).* --- ## New to Me This section includes content I discovered this week that has been around for awhile. *Nothing to share here 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/). - [June 16, 2022](https://www.daaug.org/Presentations/Details/238): **Karl Donaubauer** \- Design Patterns with Access - [July 6, 2022](https://accessusergroups.org/europe/event/access-europe-2022-07-06/): **Mike Wolfe** \- Building Ribbon Interfaces in Code - [August 3, 2022](https://accessusergroups.org/europe/event/access-europe-2022-08-03/): **Peter Cole** \- Automating 32-bit to 64-bit VBA Conversion - [September 1, 2022](https://accessusergroups.org/pacific/event/257-2022-09-01/): **Jack Stockton** \- Codifying Long Names into Unique Codes - [September 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-09-07/): **Colin Riddington** \- Optimizing Queries and the Use of JETSHOWPLAN - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Graphical Interfaces in Access - [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 --- ## Access Roadmap *There were [major changes](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075) to the roadmap this week.* 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)*. - Inconsistent Database Error Fix - New (Modern) Web Browser Control (to support Chromium Edge) - Enabling Large Address Aware (LAA) for 32-Bit Access - SQL Monaco Editor - 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)