> ## 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: April 1, 2023 - URL: https://nolongerset.com/week-in-review-2023-04-01/ - Published: 2023-04-02T00:10:42.000Z - Updated: 2026-05-08T12:50:45.000Z - Description: Highlights include how to find a control associated with a label, Access's surprising folder-locking behavior, and a new setting to make your database self-destruct. - 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 Forever](https://www.accessforever.org/)** - [Microsoft 365 Plans that include Access](https://www.accessforever.org/post/microsoft-365-plans-that-include-access), *by Karl Donaubauer* - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [Access – Determine a Label’s Associated Control](https://www.devhut.net/access-determine-a-labels-associated-control/) - [VBA – Extract Base URL From A Full URL](https://www.devhut.net/vba-extract-base-url-from-a-full-url/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Progress Bar](https://isladogs.co.uk/progress-bar/index.html) *(UPDATED)* - [View Access Help](https://isladogs.co.uk/access-help/index.html) *(UPDATED)* - [Better Date Picker](https://isladogs.co.uk/better-date-picker/index.html) *(UPDATED)* - [Using the new VBA Project Signing feature - Part 1](https://isladogs.co.uk/vba-project-signing/index.html) *(UPDATED)* - [BUG: Tables Disappear In Relationships Window](https://isladogs.co.uk/relationships-window-bug/index.html) - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [Get MSysObjects in Another Database](https://msaccessgurus.com/VBA/SQL%5FMSysObjects%5FAnotherDatabase.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [The Zen of Python: 19 Pieces of Programming Wisdom](https://nolongerset.com/zen-of-python/) - [The 5 Surprising Lessons I Learned About Developing Software](https://nolongerset.com/lessons-learned/) - [Microsoft Access's Surprising Folder Locking Behavior](https://nolongerset.com/folder-locking-behavior/) - [Impact vs. Effort: A Simple Formula for Estimating ROI](https://nolongerset.com/impact-vs-effort/) - [Better Global Constants in VBA with Dot-Driven Development](https://nolongerset.com/better-global-constants/) #### Videos‌ - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Relationships Design Window Bug](https://www.youtube.com/watch?v=0jJSEDBxnZQ) (2:38) - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Self Destruct!](https://www.youtube.com/watch?v=NTSc9O6t06Q) (9:45): *How to Create a Database in Microsoft Access That Will Self-Destruct in 24 Hours* - [Startup Form](https://www.youtube.com/watch?v=9poHPoBkG8c) (9:30): *How to Load a Form on Startup in your Microsoft Access Database* - [ACCDE](https://www.youtube.com/watch?v=I9Bqfg6sUrs) (16:35): *Creating ACCDE Files in Microsoft Access* - [Refresh vs. Requery](https://www.youtube.com/watch?v=yE7DYxhaM5w) (10:09): *Refresh vs. Requery in Microsoft Access: What's the Difference?* - [Requery in Place](https://www.youtube.com/watch?v=nirVLRYFHeU) (21:20): *How to Requery a Continuous Form in Microsoft Access Without the Focus Moving* - [On Got Focus](https://www.youtube.com/watch?v=9wp1ZRSQBj0) (18:28): *Using the On Got Focus Event in Microsoft Access to Provide On-Screen Help to Users* - [Developer 42](https://www.youtube.com/watch?v=-uGiMtJpFrc) (1:33): *Parameter Arrays, Products With Options, More!* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Ranking](https://www.youtube.com/shorts/9klnLF-7e7I) (Short): *Rank Your Data Set with Ease: Using Correlated Subqueries in Microsoft Access* - [What is a Database?](https://www.youtube.com/watch?v=E2kKbHIxMa8) (5:28): *From Simple Spreadsheets to Massive Data LakesFrom Simple Spreadsheets to Massive Data Lakes* - [Taking Pictures](https://www.youtube.com/shorts/kJam6sLABKY) (Short): *Taking Pictures in a Microsoft Access Database* - [Middle Quartiles](https://www.youtube.com/watch?v=fSuFeDEp2L4) (11:58): *Use a Single Query to find the Top or Middle Quartiles of a Data Set* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - **[User Interface Design and Implementation: Learnability Part 2](http://web.mit.edu/6.813/www/sp16/classes/03-learnability/)**, *MIT: Department of Electrical Engineering & Computer Science (Collaboratively authored with contributions from: Elena Glassman, Philip Guo, Daniel Jackson, David Karger, Juho Kim, Rob Miller, Clayton Sims, and Haoqi Zhang.)* --- ## 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/). - [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- Creating calendar format reports - [April 6, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Tom Wickerath and George Hepworth** \- Migrating Access Tables to SQL Server, a Comparison of Methods - [April 20, 2023](https://www.daaug.org/Presentations/Details/250): **Tom van Stiphout** \- Northwind 2.0 Is Here! - [April 25, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-04-25/): **Maria Barnes** \- What's New with Access? - [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna** - [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access - [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow) - [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access - [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data - [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- (topic to be confirmed) --- ‌ ## Access Roadmap *There were *NO CHANGES* to the roadmap between the last Week in Review (2023-03-25) and this one (2023-04-01).* *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 - `APR 2023`: Modern Web Browser Control - `MAR 2023`: New Modern Web Browser Form Control #### Rolling Out None. #### Launched None.