> ## 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: July 16, 2022 - URL: https://nolongerset.com/week-in-review-2022-07-16/ - Published: 2022-07-17T03:59:00.000Z - Updated: 2026-05-08T12:56:17.000Z - Description: Highlights include 5 things NOT to do when writing code, embedding videos on Access forms, and--of course--more bugs. :-( - Author: Mike Wolfe - Tags: Week in Review, #Import 2026-05-20 02:59 *NOTE: If you know of any Microsoft Access articles published in the *past 7 days* that I missed, please let me know in the comments below. I'm especially interested in websites that publish regular Access content (at least several times per year). Thanks in advance for helping out!* ## Just Published This section includes videos, articles, and interesting discussions from the past 7 days. #### Articles - [Cannot open a database created with a previous version](https://www.devhut.net/access-cannot-open-a-database-created-with-a-previous-version/), by Daniel Pineault - [Sharing Files Over The Internet](https://www.devhut.net/sharing-files-over-the-internet/), by Daniel Pineault - [MDEs & ACCDEs Breaking](https://www.devhut.net/access-mdes-accdes-breaking/), by Daniel Pineault - [Microsoft Office/Access V2206 – Stay Away!](https://www.devhut.net/microsoft-office-access-v2206-stay-away/), by Daniel Pineault - [Continuous subform scrollbar selection](https://isladogs.co.uk/continuous-subform-scroll/index.html) ), by Colin Riddington - [Standard Module Object Generation (SMOG)](https://isladogs.co.uk/smog/index.html), by Colin Riddington #### Discussions - [How do I search and select names that start with certain letters?](https://stackoverflow.com/q/72967399/154439) - [Inventory Management](https://www.access-programmers.co.uk/forums/threads/inventory-management.323990/): Brainstorming a new database design - [Counting multiple checkboxes](https://www.access-programmers.co.uk/forums/threads/counting-multiple-checkboxes.323961/): OP inherited a 25-year old Access app. #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Building Ribbon Interfaces in Code](https://www.youtube.com/watch?v=MS2yfOXsa-c) (47:50): *by Mike Wolfe* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Mainform Subform](https://www.youtube.com/watch?v=rvKKAFRWDQ0) (6:23): *Access Main Form and Subform for data from tables Related in a 1 to Many Relationship \~ DataPig* - [Startup Options](https://www.youtube.com/watch?v=gUrvvZckPnM) (3:22): *Startup Options to simplify User Interaction with the Access Application \~ DataPig* - [Splash Screen](https://www.youtube.com/watch?v=3t22QyJzzHM) (3:30): *Splash Screen form in Access that shows on start up \~ DataPig* - [Option Group](https://www.youtube.com/watch?v=ImSZULSwtMM) (8:21): *Setting up and using an Option Group in Access \~ DataPig* - [MsgBox InputBox](https://www.youtube.com/watch?v=vDqOU%5FWG4PQ) (8:16): *Using MsgBox and InputBox to communicate with the user in Access \~ DataPig* - [Image to Button](https://www.youtube.com/watch?v=4PnNuaQ39QA) (2:02): *Make an Image appear and act like a button in Access \~ DataPig* - [Multi-Column Combobox](https://www.youtube.com/watch?v=PN%5FSaHl79mQ) (6:28): *Multi-Column Combobox in Access \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Play Video](https://www.youtube.com/watch?v=ehAMOjkiuag) (15:32): *How to Play a Video or Audio File in a Microsoft Access Form Using the Windows Media Player Control* - [Timestamp](https://www.youtube.com/watch?v=eTEELNpa3Lc) (13:17): *Adding a Timestamp: Tracking When a Record Was Last Updated in Microsoft Access* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Comparison Operators](https://www.youtube.com/watch?v=13klpe3DGQQ) (5:29): *A Review of Comparison Operators* - [Profit & Discount Queries](https://www.youtube.com/watch?v=Qb3MGf1HA4o) (7:32): *Calculating Profit and Discount Percent from Sales Data* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [5 Software Engineering Foot-guns](https://kenkantzer.com/5-software-engineering-foot-guns/) *(I'm especially partial to #1, as [I've written about in the past](https://nolongerset.com/dont-write-clever-code/))* - [The Googler’s Dilemma: Why Experience Will Always Have a Premium](https://kenkantzer.com/the-googlers-dilemma-why-experience-will-always-have-a-premium/) *(I apparently found a kindred spirit, as [I've written about this in the past](https://nolongerset.com/the-knowledge-square/), too)* --- ## 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/). - [July 21, 2022](https://www.daaug.org/Presentations/Details/239): **Richard Rost** \- Custom List Box Columns - [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 - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less connections 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-07-09) and this week (2022-07-16).* 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)