> ## 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 25, 2022 - URL: https://nolongerset.com/week-in-review-2022-06-25/ - Published: 2022-06-26T02:53:23.000Z - Updated: 2026-05-08T12:56:48.000Z - Description: Highlights include an elegant solution to synchronized scrolling, a novel approach to db schema versioning, and a deep dive into recovering deleted db objects. - 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 - [*Change Attachment Dialog Default Directory*](https://www.devhut.net/change-attachment-dialog-default-directory/), by Daniel Pineault - *[Install Windows 3.1 on an iPhone](https://isladogs.co.uk/windows-iphone/index.html)*, by Colin Riddington - [*Access Infographics*](https://isladogs.co.uk/access-infographics/index.html), by Colin Riddington - [*Drag & Drop Database Objects*](https://isladogs.co.uk/drag-drop-objects/index.html), by Colin Riddington - [*Synchronise Subform Scrolling*](https://isladogs.co.uk/subform-sync-scroll/index.html), by Colin Riddington (*Includes an elegant solution to a problem whose alternate solutions usually involve lots of VBA code and/or Windows APIs.*) - [*Recover Deleted Database Objects*](https://isladogs.co.uk/recover-deleted-objects/index.html), by Colin Riddington (*Great article with lots of details on what actually happens to tables/queries/forms/reports that you delete in your Access database. That said, I keep my Access applications under [version control](https://nolongerset.com/tag/version-control/), so I NEVER have to worry about accidentally deleting a database object.*) - *[How Can Your Data Benefit You in Ways You’ve Yet to Even Imagine?](https://www.linkedin.com/pulse/how-can-your-data-benefit-you-ways-youve-yet-even-imagine-barnes/?trackingId=ly1qOr%2FATXC8GqML%2Bi97cA%3D%3D)*, by Maria Barnes #### Discussions - [Ms access online back end / via internet .... without affecting performance](https://www.access-programmers.co.uk/forums/threads/ms-access-online-back-end-via-internet-without-affecting-performance.323398/) - [](https://www.access-programmers.co.uk/forums/threads/search-button.323671/)[S](https://www.access-programmers.co.uk/forums/threads/search-button.323671/)earch Button: *Discussion about implementing a search field on a continuous form.* - [Does an Access query negate the benefits of utilizing SQL Server?](https://www.access-programmers.co.uk/forums/threads/does-an-access-query-negate-the-benefits-of-utilizing-sql.323726/) #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) \- [Word Automation from Access](https://www.youtube.com/watch?v=BWjqPYQjgmU) (52:29): *VBA Deep Dive by Crystal Long* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) \- [Design Patterns with Access](https://www.youtube.com/watch?v=hWPbGT7iM3A) (1:14:52): *Presented by Karl Donaubauer* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Union Query](https://www.youtube.com/watch?v=NDjckH2eyGI) (8:03): *Step by step design of Union query to show both detail and summary data \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Multiple Combo Boxes For One Field](https://www.youtube.com/watch?v=WM2cW-%5F8Kfo) (14:10): *Binding Multiple Combo Boxes to One Field in Microsoft Access. Why Would You Do This?* \- [Modal & Popup](https://www.youtube.com/watch?v=CiX2-311PXk) (11:55): *How to Create Modal and Popup Forms in Microsoft Access. Create Popup Sticky Notes.* \- [Project Budgets](https://www.youtube.com/watch?v=ml4RV2qz0PI) (38:41): *Relationships with More than 2 Tables in Microsoft Access: Assign Orders to Projects for Budgeting* \- [Week of the Year](https://www.youtube.com/watch?v=D20CDHGEq7M) (12:44): *How to Display the Week of the Year in Microsoft Access Forms, Queries, and Reports (1-53)* \- [Access Beginner 2, Level 4](https://www.youtube.com/watch?v=AuWWHc0588k) (15:53): *Intro to Relationships, Primary & Foreign Keys, More* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/channel/UCOm7X-WFABGXg00dMS5I9dw/featured)) \- [Validation Rules](https://www.youtube.com/watch?v=Sf2KWpchxYc) (8:58): *Table Validation Rules and Text* \- [Attachment Data Type](https://www.youtube.com/watch?v=FOUj5yV0TBw) (3:04): *How to Use the New Attachment Data Type* \- [Table Indexing](https://www.youtube.com/watch?v=PkkbefsznYE) (4:30): *How to Index Your Critical Fields in a Table* *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. - [How to Version SQL Server Database Schema](https://www.codinghelmet.com/articles/sql-schema-versioning) --- ## 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 6, 2022](https://accessusergroups.org/europe/event/access-europe-2022-07-06/): **Mike Wolfe** \- Building Ribbon Interfaces in Code - [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-06-18) and this week (2022-06-25).* 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) ***UPDATE*** *\[2022-06-27\]: Fixed broken link to Colin Riddington's Windows 3.1 on an iPhone article (thanks, Adam Waller!).*