> ## 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: April 29, 2023 - URL: https://nolongerset.com/week-in-review-2023-04-29/ - Published: 2023-04-29T17:50:09.000Z - Updated: 2026-05-08T12:50:13.000Z - Description: Highlights include the release of the Northwind 2.0 database templates, automatic form resizing, and a deep dive into VBA events with a.p.r. pillai. - 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)** - [Announcing New Templates for Microsoft Access: Northwind 2.0 is here!](https://techcommunity.microsoft.com/t5/access-blog/announcing-new-templates-for-microsoft-access-northwind-2-0-is/ba-p/3806082), *by George Hepworth* - **[Access Forever](https://www.accessforever.org/)** - [Northwind 2.0 Is Live and Ready for YOU](https://www.accessforever.org/post/northwind-2-0-is-live-and-ready-for-you), *by George Hepworth* - **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/)) - [Streamlining Form Module Code Part Two](https://www.msaccesstips.com/2023/04/streamlining-form-module-code-part-two.html) - **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)) - [Draw Dials, Stoplights, and Rounded Rectangles on Access Reports](https://www.linkedin.com/pulse/draw-dials-stoplights-rounded-rectangles-access-strive4peace-/) - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [How To Emulate Your Clients Drive – 2](https://www.devhut.net/how-to-emulate-your-clients-drive-2/) - [Access/Office Won’t Update Beyond Version 2002](https://www.devhut.net/access-office-wont-update/) - [Access – Northwind 2.0 Direct Downloads](https://www.devhut.net/access-northwind-2-0-direct-downloads/) - [Power Automate – Twitter Connector Fails](https://www.devhut.net/power-automate-twitter-connector-fails/) - [Northwind 2.0 Is Available](https://www.devhut.net/northwind-2-0-is-available/) - [Access – Proper Folder Setup](https://www.devhut.net/access-proper-folder-setup/) - [VBA – Getting Summary Information About Your VBE Project](https://www.devhut.net/vba-getting-summary-information-about-your-vbe-project/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Making Automatic Form Resizing work for you](https://isladogs.co.uk/using-afr/index.html) - [Password Login (with Session Login Information)](https://isladogs.co.uk/password-login/index.html) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Access DevCon Vienna 2023 - Day One Recap](https://nolongerset.com/devcon-vienna-2023-recap-1/) - [twinBASIC Update: DevCon 2023](https://nolongerset.com/devcon-2023-tb/) - [Defensive Programming - DevCon 2023](https://nolongerset.com/devcon-2023-bugs/) - [How ChatGPT Helped Me Write a Complex Stored Procedure in SQL Server](https://nolongerset.com/chatgpt-complex-sproc/) - [Why You Should Learn to Love Syntax Errors](https://nolongerset.com/learn-to-love-syntax-errors/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [New Edge Browser Control](https://www.youtube.com/watch?v=66wNedvHizk) (1:05:17): *by Maria Barnes, George Hepworth, and Colin Riddington* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [Northwind 2.0 Is Here!](https://www.youtube.com/watch?v=i4mQ%5F7tj%5Fgk) (1:26:20): *with Tom van Stiphout and the Northwind team* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Append Only](https://www.youtube.com/watch?v=Iq9PkvkLJSs) (16:17): *How the Append Only Property for Long Text Works in Microsoft Access & Why You Shouldn't Use It* - [Can't Format Currency](https://www.youtube.com/watch?v=qDra%5FBZ5bHo) (18:27): *What To Do When Your Value Won't Format as Currency in Microsoft Access* - [Create a Database](https://www.youtube.com/watch?v=FP31SN07dzw) (12:48): *How To Create a Database in Microsoft Access* - [Optional Parameters](https://www.youtube.com/watch?v=BPhJN1t7NU0) (16:53): *How to Use Optional Parameters in Microsoft Access VBA* - [Shortcut Keys](https://www.youtube.com/watch?v=9QmrN8c%5FBMY) (5:14): *Copy Value from the Same Field in the Previous Record* - [Quickly Run SQL](https://www.youtube.com/watch?v=znXNG45563o) (12:16): *How to Quickly Execute SQL Commands Without Building a Query in Microsoft Access* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Naming Conventions](https://www.youtube.com/shorts/dU%5FdN7sctbE) (Short): *Naming Conventions in Microsoft Access to Enhance Clarity and Organization* - [Input Masks](https://www.youtube.com/watch?v=fgJyMgdVQ-I) (9:21): *Customizing Data Input for Phone Numbers, Passwords, and More* - [Alphabetizing Properties](https://www.youtube.com/shorts/4Fxie0bjGKM) (Short): *Quick Tip: Alphabetizing Properties for Easy Access in Forms and Reports* - [Format Fields in a Table](https://www.youtube.com/watch?v=cVIj-KzGE1o) (12:07): *Customizing Table Fields: Date, Number, and Text Formatting Techniques* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *Nothing new this 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/). - [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [May 4, 2023](https://accessusergroups.org/pacific/event/standardizing-form-and-list-filtering-using-vba-classes-with-eric-blomquist/): **Eric Blomquist** \- Standardizing Form and List Filtering using VBA Classes - [May 9, 2023](https://accessusergroups.org/sql-server-with-access/event/selling-access-solutions-part-ii/): **Juan Soto** \- Selling Access Solutions - Part II **(JUST ADDED)** - [May 18, 2023](https://www.daaug.org/Presentations/Details/251): **Richard Rost** \- Custom Data Entry Filter Functions in Access - [May 30, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-northwind-2-0/): **Tom van Stiphout** and **Kim Young** \- Northwind 2.0 **(JUST ADDED)** - [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access - [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow) - [August 29, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-08-29/): **Lenni Lobel** \- Introduction to Azure Cosmos DB **(JUST ADDED)** - [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access - [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) --- ‌ ## Access Roadmap *There were *NO CHANGES* to the roadmap between the last Week in Review (2023-04-22) and this one (2023-04-29).* *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.