> ## 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: May 28, 2022 - URL: https://nolongerset.com/week-in-review-2022-05-28/ - Published: 2022-05-29T03:59:00.000Z - Updated: 2026-05-08T12:57:21.000Z - Description: Highlights include two new Access bugs, a modern On/Off toggle control, setting list box font colors by column, and resurrected videos from the Access forums vault. - 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 - *[Microsoft Access @ Build 2022 This Week](https://techcommunity.microsoft.com/t5/access-blog/microsoft-access-build-2022-this-week/ba-p/3417945)*, by Michael Aldridge - *[New Bug in Microsoft Access 365 Version 2205 - SQL Server NVarchar Primary Keys cause #DELETED when linked with ODBC](https://codekabinett.com/rdumps.php?Lang=2&targetDoc=msaccess-bug-v2205-odbc-deleted-nvarchar-primary-key)*, by Philipp Stiefel - [*Access Hyperlink SubAddress Bug?*](https://www.devhut.net/access-hyperlink-subaddress-bug/)*,* by Daniel Pineault - [*Connecting Power BI Desktop To An Encrypted Access Database*](https://www.devhut.net/connecting-power-bi-desktop-to-an-encrypted-access-database/), by Daniel Pineault - *[Encoded Map Path Co-ordinates](https://isladogs.co.uk/encode-coordinates/index.html)*, by Colin Riddington - *[Fast File Copy using a Windows API](https://isladogs.co.uk/api-file-copy/index.html)*, by Colin Riddington - *[On/Off Toggle Slider Control](https://isladogs.co.uk/on-off-toggle/index.html)*, by Colin Riddington - [*Populate Junction Table*](https://isladogs.co.uk/populate-junction-table/index.html), by Colin Riddington #### Discussions - [Setting Forms Font](https://www.access-programmers.co.uk/forums/threads/setting-forms-font.323346/) *A discussion about datasheet formatting.* - [Creating a tracking notes field in database](https://www.access-programmers.co.uk/forums/threads/creating-a-tracking-notes-field-in-database.323384/) *A brief discussion about creating time-stamped, user-attributed notes.* #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) \- [ESP: UIs dinámicos con Access](https://www.youtube.com/watch?v=GnV4ufDp49E) (57:22): *presented in Spanish by Alessandro Grimaldi* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Data Manipulation](https://www.youtube.com/watch?v=a2F48CayPaM) (8:38): *Samples of data manipulation in the Access query window \~ DataPig* \- [Date() Function](https://www.youtube.com/watch?v=USq9SHd3cTA) (5:27): *Uses of the Date() Function in Access \~ DataPig* \- [Crosstab](https://www.youtube.com/watch?v=WNHxb69lrmA) (5:25): *Building a custom Crosstab query in Access \~ DataPig* \- [AND vs OR](https://www.youtube.com/watch?v=26LDS8gLcyg) (4:28): *AND vs OR in an Access Query Grid + SQL introduction \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Add Anything!](https://www.youtube.com/watch?v=5zPKD3Bk%5Fl4) (22:16): *Add Anything You Want to a Record in a Microsoft Access Database. User Editable Supplemental Fields* \- [List Items Edit Form](https://www.youtube.com/watch?v=V4Gnyz9giOo) (11:03): *How to Use a List Items Edit Form to Quickly Add or Edit Items in a Combo Box in Microsoft Access* \- [Column Colors](https://www.youtube.com/watch?v=6TO4vKlTK%5FQ) (10:13): *How to Change the Color of Different Columns in List Boxes and Combo Boxes in Microsoft Access* \- [Multi-Table Forms](https://www.youtube.com/watch?v=WNsktijcEGM) (18:00): *Editing Records in Multi-Table Forms in Microsoft Access (Forms Based on Multiple Table Queries)* \- [Variables](https://www.youtube.com/watch?v=kGz5UY3YCio) (14:42): *Declaring Variables in Microsoft Access VBA. Dim, Public, Private, Static, TempVars, And More...* *NOTE: The new videos posted to Crystal's YouTube page are part of an effort to preserve the Access content of retiring creators. I covered this effort as one of [last week's discussion topics](https://nolongerset.com/week-in-review-2022-05-21/#discussions):* > [Status of DatabaseAnswers.org????](https://www.access-programmers.co.uk/forums/threads/status-of-databaseanswers-org.322983/) A conversation about preserving Access content on the web as former Access MVPs and other contributors retire --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Scripting all Agent Jobs Using SQL Server Management Studio](https://www.sqlmatters.com/Articles/Scripting%20all%20Agent%20Jobs%20Using%20SQL%20Server%20Management%20Studio%20%28SSMS%29.aspx)*, at SQLMatters.com - *[Why does HRESULT begin with H when it’s not a handle to anything?](https://devblogs.microsoft.com/oldnewthing/20180117-00/?p=97815)*, by the indomitable Raymond Chen - *[Did you know that Access is NOT a database but a Front End?](https://www.hitechcoach.com/microsoft-office/access/83-general/70-did-you-know-that-access-is-not-a-database-or-database-engine)* by Boyd Trimmell (I assume) I found the following quote from the Boyd Trimmell article noteworthy: > On the Microsoft Access Blog, there is a comment from Clint Covington of Microsoft that stated "The Jet engine is a system component and making changes to it meant making changes to Windows. The new engine gives us more flexibility to innovate in the codebase and ship updates via Office." --- ## 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 31, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-05-31/): **Crystal Long** \- Deep Dive into Word Automation using VBA and Access - [June 1, 2022](https://accessusergroups.org/europe/event/access-europe-2022-06-01/): **Alan Cossey** \- Standard Module Object Generation - [June 2, 2022](https://accessusergroups.org/pacific/event/257-2022-06-02/): **Crystal Long** \- Drawing the Periodic Table of Chemical Elements with an Access Report - [June 16, 2022](https://www.daaug.org/Presentations/Details/238): **Karl Donaubauer** \- Design Patterns with Access - [July 6, 2022](https://accessusergroups.org/europe/event/access-europe-2022-07-06/): **Mike Wolfe** \- Building Ribbon Interfaces in Code - [August 3, 2022](https://accessusergroups.org/europe/event/access-europe-2022-08-03/): **Peter Cole** \- Automating 32-bit to 64-bit VBA Conversion - [September 1, 2022](https://accessusergroups.org/pacific/event/257-2022-09-01/): **Jack Stockton** \- Codifying Long Names into Unique Codes - [September 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-09-07/): **Colin Riddington** \- Optimizing Queries and the Use of JETSHOWPLAN - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Graphical Interfaces in Access - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access Crystal Long emailed me a few teaser images from her upcoming June 2 presentation: ![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/05/image-65.png) ![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/05/image-66.png) An oxygen atom from Crystal Long's upcoming presentation, Drawing the Periodic Table of Chemical Elements with an Access Report. --- ## Access Roadmap Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access). *Microsoft made no changes to the roadmap since last week. I did change the formatting on this website to more clearly separate the upcoming features from those that have already been released.* #### In Development - `OCT 2022`: Inconsistent Database Error Fix #### Planned - `MAR 2022`: New Microsoft Graph Data Connector - `SEP 2022`: New (Modern) Web Browser Control (to support Chromium Edge) - `SEP 2022`: Enabling Large Address Aware (LAA) for 32-Bit Access - `DEC 2022`: SQL Monaco Editor #### Released - `MAY 2022`: Access Dataverse Connector - `JAN 2021`: Access: ODBC Interface Support (without ACE Redistributable Engine) - `JAN 2021`: Access: DAO Interface Support (without ACE Redistributable Engine)