> ## 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: January 14, 2023 - URL: https://nolongerset.com/week-in-review-2023-01-14/ - Published: 2023-01-15T03:58:17.000Z - Updated: 2026-05-08T12:52:20.000Z - Description: Highlights include using an ActiveX control to collect handwritten signatures, multiple options for getting special folders in VBA, and managing old data. - 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 - **[Access Forever](https://www.accessforever.org/)** - [Naming of linked SQL Server tables is inconsistent](https://www.accessforever.org/post/naming-of-linked-sql-server-tables-is-inconsistent), *by Karl Donaubauer* - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [VBA – Getting The Path Of System Folders](https://www.devhut.net/vba-getting-the-path-of-system-folders/) - [Microsoft Wants You To Use Stack Overflow!](https://www.devhut.net/microsoft-wants-you-to-use-stack-overflow/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Manage Old Data: Archive, Mark or Delete?](https://isladogs.co.uk/manage-old-data/index.html) - [AI: Using ChatGPT to write code](https://isladogs.co.uk/ai-code/index.html) - [Why Isladogs? Why Access?](https://isladogs.co.uk/why-isladogs/index.html) - [Application Parts & Templates](https://isladogs.co.uk/application-parts-templates/index.html) - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [Unlink Fields in Word](https://msaccessgurus.com/VBA/Word%5FUnlinkFields.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Showing User-Friendly Error Messages for Missing Data on Bound Forms in MS Access](https://nolongerset.com/bound-form-error-handling/) - [5 Tips for Making Changes on Live SQL Server Databases](https://nolongerset.com/live-database-changes/) - [Block-Level Scope in VBA...Does Not Exist](https://nolongerset.com/block-level-scope/) - [All About Indenting](https://nolongerset.com/all-about-indenting/) - [Choosing the Proper Lifetime of Variables in VBA](https://nolongerset.com/choosing-proper-extent/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Using REST/APIs in Access](https://www.youtube.com/watch?v=rGvNAjbxXxQ) (1:35:02): *by Juanjo Luna* - **Alessandro Grimaldi** ([YouTube channel](https://www.youtube.com/user/papillon0365)) - [Password Builder Assistant](https://www.youtube.com/watch?v=byka-laqF3o) (1:10): \*\* - [Talk-to-Speech](https://www.youtube.com/watch?v=DGwE0avCfyI) (30:18): *Talk-To-Speech with VBA (Access Lunchtime User Group)* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Dirty Property](https://www.youtube.com/watch?v=bfhCyr0Mllg) (9:43): *Working with Dirty Records in Microsoft Access* - [Caption Property](https://www.youtube.com/watch?v=sbEdJlOA%5FfA) (12:24): *How to Use the Caption Property in Microsoft Access* - [Visible Property](https://www.youtube.com/watch?v=pxvvrYuBL-8) (9:18): *Show or Hide Fields Based on Another Field's Value Using the Visible Property in Microsoft Access* - [Association Database, Part 1](https://www.youtube.com/watch?v=Izknj7UQr4U) (28:49): *Microsoft Access Association Database, Part 1 (Groups, Clubs, Churches, Schools, etc.)* - [Signatures](https://www.youtube.com/watch?v=svlxGkEWus0) (13:10): *How to Collect Signatures on Forms in Microsoft Access with the InkPicture ActiveX Control* - [Access Rewind](https://www.youtube.com/watch?v=hkwzyznBy38) (6:22): *Richard's "Week-in-Review" for his own videos* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [Quick Tip - List Box - Select All/Select None](https://www.youtube.com/watch?v=IFyYRBbCgEE) (7:23) - [VBA - PC/User/System/Environment Folders](https://www.youtube.com/watch?v=4D-d%5FlQt3ng) (18:32) --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*We invested 10% to pay back tech debt; Here's what happened*](https://blog.alexewerlof.com/p/tech-debt-day), by Alex Ewerlöf --- ## 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 19, 2023](https://www.daaug.org/Presentations/Details/247): **George Young -** Using Web API's in Access **(JUST ADDED)** - [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 **(TOPIC JUST ADDED)** - [February 16, 2023](https://www.daaug.org/Presentations/Details/248): **Karl Donaubauer** \- The Current State of Access **(JUST ADDED)** - [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 **(JUST ADDED)** - [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 **(JUST ADDED)** - [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 - [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 last week (2023-01-07) and this week (2023-01-14). 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.