> ## 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: August 26, 2023 - URL: https://nolongerset.com/week-in-review-2023-08-26/ - Published: 2023-08-26T20:23:21.000Z - Updated: 2026-05-08T12:35:02.000Z - Description: Highlights include tips to automate the new browser control, sending WhatsApp messages from Access, Python in Excel, and AI-driven help via Microsoft Q&A Assist. - 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 - **[Official Access Blog](https://techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog)** - [New Edge Browser Control in Microsoft Access](https://techcommunity.microsoft.com/t5/access-blog/new-edge-browser-control-in-microsoft-access/ba-p/3907713), *by Linda Lu Cannon* - **Maria Barnes** ([Business Data Bytes Newsletter](https://www.linkedin.com/newsletters/business-data-bytes-6892816951870066688/)) - [Unveiling Microsoft Q&A Assist: Your Gateway to Seamless Problem-Solving](https://www.linkedin.com/pulse/unveiling-microsoft-qa-assist-your-gateway-seamless-maria-barnes/) - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [Microsoft Finally Acknowledges The Modern Web Browser Control!](https://www.devhut.net/microsoft-finally-acknowledges-the-modern-web-browser-control/) - [What is a Build Number Exactly?](https://www.devhut.net/what-is-a-build-number-exactly/) - [Modern Web Browser Release Cycle](https://www.devhut.net/modern-web-browser-release-cycle/) - [So What’s Your Access Version And Build No?](https://www.devhut.net/so-whats-your-access-version-and-build-no/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Synchronise Subform Scrolling](https://isladogs.co.uk/subform-sync-scroll/index.html) *(updated)* - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Customizing the Quick Access Toolbar in Microsoft Access](https://nolongerset.com/customizing-the-qat/) - [A Simple Trick to Help ChatGPT Provide Correct Answers](https://nolongerset.com/explain-first-answer-second/) - [Python in Excel](https://nolongerset.com/python-in-excel/) - [The twinBASIC Family Tree](https://nolongerset.com/the-twinbasic-family-tree/) - [Wrapper vs. Port vs. Rewrite](https://nolongerset.com/wrapper-vs-port-vs-rewrite/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Northwind 2.0: Core forms and Workflow](https://www.youtube.com/watch?v=%5FjfYLAbHo9A) (1:08:51): *with Tom van Stiphout and Kim Young* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [Custom Data Entry Filter Functions](https://www.youtube.com/watch?v=jbjAWufABc0) (34:51): *with Richard Rost* - **Sean MacKenzie** ([YouTube channel](https://www.youtube.com/@seanmackenziedataengineering)) - [WhatsApp Messages](https://www.youtube.com/watch?v=Hnx4%5F2Xvk6Q) (1:16): *How to Send WhatsApp Messages from My MS Access Database* - [SQL CASE WHEN Statement](https://www.youtube.com/watch?v=iq-geVaMOos) (10:32): *How to Use SQL Case Statements* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Activate vs. Got Focus](https://www.youtube.com/watch?v=KUueYw5dwIg) (12:11): *What's the Difference Between On Activate and On Got Focus in Microsoft Access* - [On Activate](https://www.youtube.com/watch?v=%5Fa0G5-UHq90) (15:50): *Use the On Activate Event to Highlight Active Form in Microsoft Access* - [Force New Page](https://www.youtube.com/watch?v=xEiFlb4UT0U) (11:29): *Use the Force New Page Property to Insert a Page Break after Each Group in a Microsoft Access Report* - [On Unload](https://www.youtube.com/watch?v=8F3lbCITD20) (16:51): *Using the On Unload Event to Perform Data Validation When a Form Closes in Microsoft Access* - [Copy to Clipboard](https://www.youtube.com/watch?v=NS8uuXmtfEY) (19:31): How to Copy & Paste Data to/from the Clipboard in Microsoft Access\* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [Advanced VBA Automation (Part 1)](https://www.youtube.com/watch?v=LnnlGZcbLE4) (33:55): *Modern Web Browser Control* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Multi-Column Reports](https://www.youtube.com/watch?v=NcxT%5FQCq1Vw) (3:41): *Two-Column Reports in Microsoft Access* - [Decision-Making Macros](https://www.youtube.com/watch?v=R1YNre3B%5F30) (7:19): *Dynamic Macro Decision Making: Two Examples to Control Printing* - [Macro Debugging](https://www.youtube.com/watch?v=fICZ5BxCOws) (9:21): *Mastering Macro Debugging and Error Handling* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Squeeze the hell out of the system you have](https://blog.danslimmon.com/2023/08/11/squeeze-the-hell-out-of-the-system-you-have/)*, by Dan Slimmon - *[Do-nothing scripting: the key to gradual automation](https://blog.danslimmon.com/2019/07/15/do-nothing-scripting-the-key-to-gradual-automation/)*, by Dan Slimmon - *[Don’t fix it just because it’s technical debt](https://blog.danslimmon.com/2023/05/08/dont-fix-it-just-because-its-technical-debt/)*, by Dan Slimmon --- ## 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 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-2023-09-06/): **Colin Riddington** \- Database Analyzer and Other Tools - [September 7, 2023](https://accessusergroups.org/pacific/event/event-driven-programming-with-john-colby/): **John Colby** \- Event Driven Programming - [September 12, 2023](https://accessusergroups.org/sql-server-with-access/event/fundamentals-of-azure-openai-by-roy-kim/): **Roy Kim** \- Fundamentals of Azure OpenAI **(JUST ADDED)** - [September 21, 2023](https://www.daaug.org/Presentations/Details/255): **Armen Stein** \- Advanced Database Design - [September 26, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-09-26/): **Tom van Stiphout and Kim Young** \- Accessibility is for Everyone - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access - [October 5, 2023](https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2023-10-05/): **Pat Hartman** \- Updateable Bound Forms with Denormalized Data **(JUST ADDED)** - [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 - November 2, 2023: **You?** \- Your Presentation Can Be Here! [Contact George Hepworth](https://accessusergroups.org/pacific/contact/) - [November 16, 2023](https://www.daaug.org/Presentations/Details/256): **Alexander Denz** \- ChatGPT in Access - [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 - Date To Be Determined: **Thomas Möller** \- Better Access Charts in the new Edge browser control (session postponed from its original September 6, 2023, time slot) --- ‌ ## Access Roadmap *There were *NO CHANGES* to the roadmap between the last Week in Review (2023-08-19) and this one (2023-08-26).* *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.