> ## 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. # Weeks in Review: January 28, 2023 - URL: https://nolongerset.com/week-in-review-2023-01-28/ - Published: 2023-01-29T04:59:00.000Z - Updated: 2026-05-08T12:52:03.000Z - Description: I'm back! Highlights from the past two weeks include using web APIs in Access, Rubberduck 3.0 news, using the registry from VBA, and more on ChatGPT. - Author: Mike Wolfe - Tags: Week in Review, #Import 2026-05-20 02:59 *I'm back from vacation and returning to my regular daily routine. If you were disappointed that there was no Week in Review last week, you'll be relieved to know that I included two weeks worth of updates in today's edition. Enjoy!* ## 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 2212 (Released January 4, 2023)](https://techcommunity.microsoft.com/t5/access-blog/access-releases-4-issue-fixes-in-version-2212-released-january-4/ba-p/3722903), *by Linda Lu Cannon* - **[Access Forever](https://www.accessforever.org/)** - [Access Conferences in 2023](https://www.accessforever.org/post/access-conferences-in-2023), *by Karl Donaubauer* - **Juan Soto** ([Access Experts](https://accessexperts.com/access-developer-blog/)) - [Can ChatGPT write VBA code? How about SQL Queries? Yes! But…](https://accessexperts.com/blog/2023/01/22/can-chatgpt-write-vba-code-how-about-sql-queries-yes-but/) - **Mathieu Guindon** ([Rubberduck VBA](https://rubberduckvba.wordpress.com/)) - [Rubberduck 3.0: January Update](https://rubberduckvba.wordpress.com/2023/01/17/rubberduck-3-0-january-update/) - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [VBA – Storing Information In The Registry](https://www.devhut.net/vba-storing-information-in-the-registry/) - [Microsoft Access – Get Object Created Or Modified Date/Time](https://www.devhut.net/microsoft-access-get-object-created-or-modified-date-time/) - [Experts Exchange – Most Valuable Expert](https://www.devhut.net/experts-exchange-most-valuable-expert/) - [Microsoft Access – Table Fields or Table Columns, Which Is It?](https://www.devhut.net/microsoft-access-table-fields-or-table-columns-which-is-it/) - [Microsoft Access – Quick Tips – The List Box Control](https://www.devhut.net/microsoft-access-quick-tips-the-list-box-control/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Manage Windows Smart Screen Warnings](https://isladogs.co.uk/smart-screen-warnings/index.html) - [Maximum Password Length in Access Files](https://isladogs.co.uk/password-length/index.html) - [AI: Can ChatGPT be used to write malware?](https://isladogs.co.uk/ai-code-2/index.html) - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [Draw a Rainbow](https://msaccessgurus.com/VBA/Draw%5FRainbow.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Archive Collection: Humor](https://nolongerset.com/archive-humor/) - [Archive Collection: Form Design](https://nolongerset.com/archive-form-design/) - [Archive Collection: Defensive Programming](https://nolongerset.com/archive-defensive-programming/) - [Archive Collection: Tools](https://nolongerset.com/archive-tools/) - [Archive Collection: Test-Driven Development](https://nolongerset.com/archive-tdd/) - [Archive Collection: twinBASIC](https://nolongerset.com/archive-collection-twinbasic/) - [Archive Collection: Bug Types](https://nolongerset.com/archive-bug-types/) - [Archive Collection: Hidden Features](https://nolongerset.com/archive-hidden-features/) - [Debug Documentation: Signal vs. Noise Edition](https://nolongerset.com/debug-documentation/) - [How to Duplicate a Line of Code in VBA](https://nolongerset.com/duplicate-one-line-of-vba/) - [Micro-Efficiency: Duplicating Line(s) of Code in VBA](https://nolongerset.com/duplicating-vba-lines/) - [Guard Clauses](https://nolongerset.com/guard-clauses/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [SQL Server Academy Part III: DSNLess Connections and Views](https://www.youtube.com/watch?v=YK6Sd3h1klg) (1:10:58): *with Juan Soto and Mark Edwards* - [VBA Signing in Microsoft Access](https://www.youtube.com/watch?v=D2QNkOaxanA) (46:22): *with Maria Barnes* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) - [Using Web APIs in Access](https://www.youtube.com/watch?v=9CQcJkR%5FaKM) (1:24:37): *with George Young* - **Alessandro Grimaldi** ([YouTube channel](https://www.youtube.com/user/papillon0365)) - [Colored Ticker](https://www.youtube.com/watch?v=OnreOCw82v4) (1:10) - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Draw Rainbows](https://www.youtube.com/watch?v=MlFXCFG7eIg) (10:14): *Draw a Rainbow on Access Reports* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Association Database, Part 2](https://www.youtube.com/watch?v=5VXsue53oZY) (28:30): *Laying Out Tables & Forms* - [Association Database, Part 3](https://www.youtube.com/watch?v=M7V48AgYg2M) (30:21): *Modifying TechHelp Template, Building All Tables* - [Association Database, Part 4](https://www.youtube.com/watch?v=Qt7uGfgqrZ8) (34:22): *Person Form, Family Combo, Form, Head of Family Combo* - [Association Database, Part 5](https://www.youtube.com/watch?v=wl8PNG8Jl8A) (23:18): *Family Member List, Edit Members, Family List Form* - [Association Database, Part 6](https://www.youtube.com/watch?v=zsFoRg8GRkg) (17:43): *Helper Type Form, Helper Form, Lists of Lists* - [Association Database, Part 7](https://www.youtube.com/watch?v=LMXAO4i8b5o) (15:44): *Combo Boxes for Helper Data* - [Math in Fields](https://www.youtube.com/watch?v=KTN6mYRsdqE) (18:34): *Entering Math Equations in Microsoft Access Fields Like You Can in Excel* - [Changing Query Data Sources](https://www.youtube.com/watch?v=N5qBqY9CLlA) (8:09): *How to Quickly & Easily Change the Data Sources in a Microsoft Access Query* - [Zodiac Signs](https://www.youtube.com/watch?v=p7M19dsAbIc) (14:54): *How to Display Zodiac Signs and Symbols Based on Date of Birth in your Microsoft Access Database* - [Images from the Web](https://www.youtube.com/watch?v=hS96kT0hDUY) (12:54): *Display Images from the Web in your Microsoft Access Forms and Reports Using the Image Control* - [Poll 2023 January](https://www.youtube.com/watch?v=Or2krutPIMA) (2:09): *What Topics do YOU Want to See Next?* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [VBA - Saving Application/User Settings To The Registry](https://www.youtube.com/watch?v=9nu-oORhlkk) (19:03) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Retrieve & Parse JSON From the Web](https://www.youtube.com/watch?v=ssxE9zKEtbU) (13:32): *Getting UPC Data from the Web and Parsing it Into a Table* --- ## 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/). - [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** \- Using Temp Tables in Access to Manage Data Processing Tasks - [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 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 - [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access (**JUST ADDED** *\- rescheduled from Dec 2022*) - [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 the last Week in Review (2023-01-14) and this one (2023-01-28). 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.