> ## 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: February 11, 2023 - URL: https://nolongerset.com/week-in-review-2023-02-11/ - Published: 2023-02-11T15:29:20.000Z - Updated: 2026-05-08T12:51:49.000Z - Description: Highlights include a video showing how to integrate charts.js in Access, calling the Windows Color Picker Dialog from VBA, and an Access CalendarMaker. - 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)** - [Access Releases 4 Issue Fixes in Version 2301 (Released January 26, 2023)](https://techcommunity.microsoft.com/t5/access-blog/access-releases-4-issue-fixes-in-version-2301-released-january/ba-p/3737383), *by Linda Lu Cannon* - **[Access Forever](https://www.accessforever.org/)** - [List of fixes in 2023](https://www.accessforever.org/post/list-of-fixes-in-2023), *by Karl Donaubauer* - [Feedback requested: There is no message for this error](https://www.accessforever.org/post/feedback-requested-there-is-no-message-for-this-error), *by Colin Riddington* - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [Access – VBA – Close All Open Queries](https://www.devhut.net/access-vba-close-all-open-queries/) - [Access – VBA – Close All Open Tables](https://www.devhut.net/access-vba-close-all-open-tables/) - [Access – VBA – Convert ControlType to Name](https://www.devhut.net/access-vba-convert-controltype-to-name/) - [Access – VBA – Find Images In Forms and Reports](https://www.devhut.net/access-vba-find-images-in-forms-and-reports/) - [VBA – Determine Your PC’s IP Address](https://www.devhut.net/vba-determine-your-pcs-ip-address/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [AEU12: State-of-the-art charts in Access](https://isladogs.co.uk/aeu-12/index.html) - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [CalendarMaker with Day Colors](https://msaccessgurus.com/tool/CalendarMaker%5FDayColor.htm) - [CalendarMaker updated](https://msaccessgurus.com/tool/CalendarMaker.htm) - [Get Folder with Office File Dialog](https://msaccessgurus.com/VBA/Office%5FGetFolder.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [How to Return Values from a Sub in VBA](https://nolongerset.com/return-values-from-a-sub/) - [Every Function Has a Return Type](https://nolongerset.com/every-function-has-a-return-type/) - [Why Use Subs at All?](https://nolongerset.com/why-use-subs-at-all/) - [Subs vs. Functions in VBA](https://nolongerset.com/subs-vs-functions/) - [Open the Windows Color Dialog from VBA](https://nolongerset.com/color-dialog/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [State-of-the-art charts in Access using charts.js](https://www.youtube.com/watch?v=GlmWWmgSQo8) (1:21:49): *by Thomas Möller* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Don't Use First & Last](https://www.youtube.com/watch?v=M9spMmzpAOY) (12:47): *Why I Never Use the First & Last Functions in Microsoft Access (Stick to Min & Max)* - [Conditional Formatting Change From Previous](https://www.youtube.com/watch?v=dyrsQ2joM%5FY) (8:58): *Conditional Formatting Change From Previous Record in Microsoft Access* - [Quick Queries #6](https://www.youtube.com/watch?v=X0s37fcdiIY) (15:19): *Space in Field Name, AutoNumbers, Can Grow/Shrink, More* - [IP Addresses](https://www.youtube.com/watch?v=zOaJcjj9YMo) (10:37): *Storing IP Addresses in Microsoft Access, Prevent Duplicates, Sort Numerically* - [Split Function](https://www.youtube.com/watch?v=XyMOo0ehqkE) (13:32): *Using the Split Function in Microsoft Access VBA to Break Apart Strings into Individual Field Values* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [VBA - Color Picker Using APIs](https://www.youtube.com/watch?v=weNanMZ1nUk) (8:55) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Workhorse Action Queries](https://www.youtube.com/watch?v=9K1NmhtN1JA) (7:34): *Real World Examples of Make Table, Append, and Delete Queries* --- ## 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/). - [February 15, 2023](https://accessusergroups.org/sql-server-with-access/event/sql-server-with-access-academy-part-iv/): **Juan Soto (?)** \- SQL Server with Access Academy Part IV – Learn how to create, link and make views that can edit data **(JUST ADDED)** - [February 16, 2023](https://www.daaug.org/Presentations/Details/248): **Karl Donaubauer** \- The Current State of Access - [March 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-03-01/): **Maria Barnes** \- Optimizing Queries in SQL Server - [March 2, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Speakers TBA** \- Migrating Access Tables to SQL Server, a Comparison of Methods - [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- (topic details to follow) - [April 6, 2023](https://accessusergroups.org/pacific/event/multi-language-support-in-access-applications-with-jack-stockton/): **Jack Stockton** \- Multi-Language Support in Access applications - [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna** - [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 - [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) **(JUST ADDED)** - [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp **(JUST ADDED)** - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** (topic details to follow) - [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- (topic details to follow) **(JUST ADDED)** - [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-02-04) and this one (2023-02-11). 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 - `MAR 2023`: New Modern Web Browser Form Control #### Rolling Out None. #### Launched None.