> ## 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: December 31, 2022 - URL: https://nolongerset.com/week-in-review-2022-12-31/ - Published: 2022-12-31T19:42:01.000Z - Updated: 2026-05-08T12:52:35.000Z - Description: Highlights include a deep dive into creating a customer follow-up database, automatic form resizing, and a risk-minimizing approach to app rewrites. - 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/)** - [Let's celebrate the Bug of the Year!](https://www.accessforever.org/post/let-s-celebrate-the-bug-of-the-year), *by Karl Donaubauer* - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [VBA – Phantom/Ghost BreakPoints](https://www.devhut.net/vba-phantom-ghost-breakpoints/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Speed Test 8: Optimising Queries](https://isladogs.co.uk/speed-comparison-tests-8/index.html) *(UPDATED)* - [Speed Test 14: Loop vs Recursion](https://isladogs.co.uk/speed-comparison-tests-14/index.html) - [Automatic Form Resizing - Page 4](https://isladogs.co.uk/automatic-form-resizing-4/index.html) - [Automatic Form Resizing - Page 3](https://isladogs.co.uk/automatic-form-resizing-3/index.html) *(UPDATED)* - [Automatic Form Resizing - Page 2](https://isladogs.co.uk/automatic-form-resizing-2/index.html) *(UPDATED)* - [Automatic Form Resizing - Page 1](https://isladogs.co.uk/automatic-form-resizing-1/index.html) *(UPDATED)* - [Why Rushmore?](https://isladogs.co.uk/why-rushmore/index.html) - [Speed Test 10: Regex Or Not](https://isladogs.co.uk/speed-comparison-tests-10/index.html) *(UPDATED)* - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [Draw a Christmas Tree on Access reports](https://msaccessgurus.com/VBA/Draw%5FChristmasTree.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Avoiding the "Invalid in Immediate Pane" Error](https://nolongerset.com/fix-invalid-in-immediate-pane-error/) - [Converting VBA Long Color Values to RGB](https://nolongerset.com/convertcolortorgb/) - [Using FreeMind as a Schema Development Tool](https://nolongerset.com/freemind-as-schema-designer/) - [The Single Most Important Concept for Understanding Relational Databases](https://nolongerset.com/foreign-key-concept/) - [Merry Christmas](https://nolongerset.com/merry-christmas-3/) #### Videos‌ - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Stretch/Shrink Forms](https://www.youtube.com/watch?v=kfnvystAeu0) (5:41): *Stretch/Shrink Forms using Automatic Form Resizing* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Draw Christmas Tree](https://www.youtube.com/watch?v=t%5FWAgli6L2Q) (7:37): *Draw Christmas Tree on Access Report* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [2023 Preview](https://www.youtube.com/watch?v=sQwRj0vewjc) (3:12): *Happy New Year 2023 from Richard Rost at Computer Learning Zone* - [Access Compactor](https://www.youtube.com/watch?v=0rNbl15QO58) (3:09): *Microsoft Access Automated Compact and Repair Tool With Nightly Or Weekly Event* - [ChatGPT](https://www.youtube.com/watch?v=7mHRyMd9pKI) (5:02): *ChatGPT Creates a List of Fifteen Fictitious Names with Formatting* - [Transaction Tables](https://www.youtube.com/watch?v=zwb3%5Fwy6hPo) (11:35): *Three Methods for Creating Tables to Track Transactions in Microsoft Access* - [Followups - Part 3](https://www.youtube.com/watch?v=Adxb60p5Qtw) (17:47): *Create a Customer Followup Database in Microsoft Access: Part 3* - [Followups - Part 4](https://www.youtube.com/watch?v=lHuU0miIju8) (29:04): *Create a Customer Followup Database in Microsoft Access: Part 4* - [Followups - Part 5](https://www.youtube.com/watch?v=Ayvk-nQcKuU) (18:21): *Create a Customer Followup Database in Microsoft Access: Part 5* - [Followups - Part 6](https://www.youtube.com/watch?v=rMjJubGBKSk) (29:06): *Create a Customer Followup Database in Microsoft Access: Part 6* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Strangler Fig Application](https://martinfowler.com/bliki/StranglerFigApplication.html)*, by Martin Fowler *(A risk-minimizing approach for rewriting complex applications)* - [*How to serialize objects in VBA*](http://www.kudinov.ru/?p=21), by Alexey Kudinov --- ## 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/). - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Karl Donaubauer** \- A baker's dozen of tips, tricks and tools in 60 minutes - [January 5, 2023](https://accessusergroups.org/pacific/event/257-2023-01-05/): **Juanjo Luna** \- Using REST/API calls with Access (Spanish to English translation will be provided) - [January 31, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-01-31/): **Colin Riddington** \- Translate & Speak Using Access - [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- State-of-the-art charts in Access with chart.js - [February 2, 2023](https://accessusergroups.org/pacific/event/257-2023-02-02/): **Linda Ewen** \- (topic to be announced) - [March 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-03-01/): **Maria Barnes** \- Optimizing Queries in SQL Server - [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- (topic details to follow) - [April 20-21, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna** (*tentative dates*) - [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 - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** (topic details to follow) - [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 last week (2022-12-24) and this week (2022-12-31). 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) (*NOTE: as of publication, this link leads to an unfiltered view of the entire Microsoft 365 roadmap because as of [the week of December 10, 2022](https://nolongerset.com/week-in-review-2022-12-10/#access-disappears-from-the-microsoft-365-roadmap), there are no Access items shown on the roadmap*). "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 None. #### Rolling Out None. #### Launched None.