> ## 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 23, 2022 - URL: https://nolongerset.com/week-in-review-2022-07-23/ - Published: 2022-07-24T03:59:00.000Z - Updated: 2026-05-08T12:56:06.000Z - Description: Highlights include the latest edition of Karl Donaubauer's Access News, creating a custom splash form, and the public release of the SSMS-style "Access Studio" tool. - 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 - [Access Fix Now Available for VBA Security Patch Issue](https://techcommunity.microsoft.com/t5/access-blog/access-fix-now-available-for-vba-security-patch-issue/ba-p/3578017), by Michael Aldridge - [Database Backup Restore From Desktop](https://www.msaccesstips.com/2022/07/database-backup-restore-from-desktop.html), by a.p.r. pillai - [Karl Donaubauer – Access News – New Edition](https://www.devhut.net/karl-donaubauer-access-news-new-edition/), by Daniel Pineault - [Create Custom Splash Form](https://isladogs.co.uk/custom-splash-form/index.html), by Colin Riddington - [Access Studio](https://isladogs.co.uk/access-studio/index.html), by Colin Riddington - [Access Command Line Switches](https://isladogs.co.uk/command-line-switches/index.html), by Colin Riddington - UPDATED: [Control the Application Interface](https://isladogs.co.uk/control-application-interface/index.html), by Colin Riddington - [ASCII Character Set](https://isladogs.co.uk/ascii-char/index.html), by Colin Riddington #### Discussions - [Editing non-editable Form](https://www.access-programmers.co.uk/forums/threads/editing-non-editable-form.324059/): *OP is looking for a workaround to allow editing a form based on a UNION query* - [List Database Design Changes since a specific date](https://www.access-programmers.co.uk/forums/threads/list-database-design-changes-since.324001/): *Hey, that's what [version control](https://nolongerset.com/tag/version-control/) is for!* - [On No Data](https://www.access-programmers.co.uk/forums/threads/on-no-data.324069/): *I recently published a function for just such an occasion: *[InformNoData()](https://nolongerset.com/informnodata/)*.* - [Difficulty Answering Questions](https://www.access-programmers.co.uk/forums/threads/difficulty-answering-questions.142081/): *Over at AWF, Uncle Gizmo resurrected this 14-year-old discussion about the quality of the *questions* being asked on the forum and whether they have declined. Interesting points made by several commenters.* #### Videos - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [Custom List Box Columns in Access](https://www.youtube.com/watch?v=G7Jy2XbAMcU) (38:28): *Presented by Richard Rost* - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Splash Form](https://www.youtube.com/watch?v=Vay4DhkhxTA) (8:21): *Create a Custom Splash Form in Access* - **Karl Donaubauer** ([YouTube channel](https://www.youtube.com/channel/UC9mBp9F%5FTX252IDs%5FxNWb7w)) - [Access News](https://www.youtube.com/watch?v=hvbzxJL8Qh8) (19:00): *Edition 3 (April - June 2022) including an interview with Access MVP Philipp Stiefel.* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Web Browser Control](https://www.youtube.com/watch?v=HiehahFIA60) (4:20): *Using the ActiveX Web Browser Control in Access \~ DataPig* - [Query Visualization Dashboards](https://www.youtube.com/watch?v=%5FBEVTjJX3X8) (7:26): *Query Visualizations in Access \~ DataPig* - [Tab Control](https://www.youtube.com/watch?v=Q7oX9gR3kQo) (7:35): *Using a Tab Control in Access \~ DataPig* - [Popup Form](https://www.youtube.com/watch?v=YsP0yZvxL6k) (6:25): *Popup Form to Edit Details in Access \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Searchable Document Index](https://www.youtube.com/watch?v=a0Kvpcld-q0) (8:36): *Microsoft Word Automation, DOC, PDF to TXT* --- ## New to Me This section includes content I discovered this week that has been around for awhile. Either I learned nothing new this week...or I forgot to make a note of it. I'll try to do better next 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/). - [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-16) and this week (2022-07-23).* 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)