> ## 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 1, 2023 - URL: https://nolongerset.com/week-in-review-2023-07-01/ - Published: 2023-07-01T14:55:55.000Z - Updated: 2026-05-08T12:33:57.000Z - Description: Highlights include an AI-focused episode of the quarterly Access News webcast, the release of Rubberduck 2.5.9, and tips on importing web data into Access. - 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 - **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)) - [Draw Birthday Balloons in Access](https://www.linkedin.com/pulse/draw-birthday-balloons-access-crystal-strive4peace-/) - **Mathieu Guindon** ([Rubberduck VBA](https://rubberduckvba.wordpress.com/)) - [Rubberduck 2.5.9](https://rubberduckvba.blog/2023/06/30/rubberduck-2-5-9/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Age Calculation](https://isladogs.co.uk/age-calculation/index.html) *(updated)* - [Available Connections Add-In](https://isladogs.co.uk/available-connections-addin/index.html) *(updated)* - [Available Connections](https://isladogs.co.uk/available-connections/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 Birthday Balloons](https://msaccessgurus.com/VBA/Draw%5FBirthdayBalloons.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [PascalCase All the Things](https://nolongerset.com/pascalcase-all-the-things/) - [What is cyclomatic complexity?](https://nolongerset.com/under-100-cyclomatic-complexity/) - [SSE Setup: Fix for Error -2147024671](https://nolongerset.com/sse-setup-fix-for-virus-error/) - [Reader Question: How to Match Names from Multiple Systems](https://nolongerset.com/matching-names/) - [DevHut.Net Goes Dark](https://nolongerset.com/devhut-goes-dark/) #### Videos‌ - **Karl Donaubauer** ([YouTube channel](https://www.youtube.com/channel/UC9mBp9F%5FTX252IDs%5FxNWb7w)) - [Access News](https://www.youtube.com/watch?v=cs%5FmZvaKYeY) (23:01): *Edition 6, April - June 2023* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Crosstab Sort](https://www.youtube.com/watch?v=iwgVlKiJPoQ) (14:19): *How to Sort Your Crosstab Query Column Headers Descending in Microsoft Access* - [Two Spaces!](https://www.youtube.com/watch?v=vHQJCFRLVrY) (16:10): *How to Fix Records Where Users Typed Two Spaces After a Period in Microsoft Access* - [Wizards Don't Start!](https://www.youtube.com/watch?v=ScEbWH0yQZk) (11:22): *What to do if the Control Wizards Don't Start in Microsoft Access* - [DLookup Slow!](https://www.youtube.com/watch?v=fHYYwMM1rWA) (15:05): *What to do if DLookup is Slow in your Microsoft Access Database* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Append Queries](https://www.youtube.com/watch?v=XIQr5gy4ttU) (7:38): *Understanding and Troubleshooting Append Queries in Access* - [Compact and Repair](https://www.youtube.com/shorts/QfY0h6K0u3g) (Short): *Utilizing 'Compact and Repair' Feature in Microsoft Access* - [Updateable Queries](https://www.youtube.com/watch?v=HcLy5ifTM1c) (5:20): *The Rules That Determine Whether Query Data is Updateable in Microsoft Access* - [Data Updates](https://www.youtube.com/shorts/mAnOZvFZNrE) (Short): \*Zip Through Data Updates in Microsoft Access \* - [Import Web Data](https://www.youtube.com/watch?v=s5T5j2cJvhI) (8:54): *Extract, Transform, Load: Master Data Import from the Web to MS Access* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Why We Stopped Estimating Ongoing Development](https://corgibytes.com/blog/2016/03/04/complicated-vs-complex/)*, by [Andrea Goulet](http://twitter.com/andreagoulet) - [*Flattening Arrow Code*](https://blog.codinghorror.com/flattening-arrow-code/), by Jeff Atwood --- ## 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 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [July 6, 2023](https://accessusergroups.org/pacific/event/great-interface-design-with-greg-regan/): **Greg Regan** \- Great Interface Design - [July 20, 2023](https://www.daaug.org/Presentations/Details/254): **George Hepworth** \- Extending Access with a PowerApps Barcode Scanner - [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- An Access Developer Guide to creating applications in Blazor - [August 3, 2023](https://accessusergroups.org/pacific/event/global-error-handlers-with-tom-van-stiphout-and-kim-young/): **Tom van Stiphout** and **Kim Young** \- Global Error Handlers - [August 17, 2023](https://www.daaug.org/Presentations/Details/251): **Richard Rost** \- Custom Data Entry Filter Functions in Access - [August 29, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-08-29/): **Lenni Lobel** \- Introduction to Azure Cosmos DB - [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- Better Access Charts in the new Edge browser control - [September 7, 2023](https://accessusergroups.org/pacific/event/event-driven-programming-with-john-colby/): **John Colby** \- Event Driven Programming - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access - [October 19, 2023](https://www.daaug.org/Presentations/Details/252): **Alessandro Grimaldi** \- "VBA Pills" - Access Tips and Tricks - [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) - [January 3, 2023](https://accessusergroups.org/europe/event/access-europe-2024-01-03/): **Ramachandran (A.P.R.) Pillai** \- Streamlining the Form Module Code in the standalone Class Module --- ‌ ## Access Roadmap *There were *NO CHANGES* to the roadmap between the last Week in Review (2023-06-24) and this one (2023-07-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.