> ## 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: June 11, 2022 - URL: https://nolongerset.com/week-in-review-2022-06-11/ - Published: 2022-06-11T20:45:07.000Z - Updated: 2026-05-08T12:56:58.000Z - Description: Highlights include a better date picker control, dashboard-style gauges, and drawing shapes in Access reports. - 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 - [*Azure Web Services Don’t Do It!*](https://www.devhut.net/azure-web-services-dont-do-it/) by Daniel Pineault - [*Microsoft Access Roadmap Updated, Again*](https://www.devhut.net/microsoft-access-roadmap-updated-again/), by Daniel Pineault - [*Microsoft Access Gauges*](https://www.devhut.net/microsoft-access-gauges/), by Daniel Pineault - [*A Better Date Picker*](https://isladogs.co.uk/better-date-picker/index.html), by Colin Riddington - *[Draw By Your Numbers… Follow the Data Paths and Connect the Dots](https://www.linkedin.com/pulse/draw-your-numbers-follow-data-paths-connect-dots-maria-barnes/?trackingId=1V%2B%2FZme9QX%2BjheRG1hhYqg%3D%3D)*, by Maria Barnes #### Discussions - [](https://stackoverflow.com/questions/72493608/finding-version-of-office-365-build-version-with-ms-access-vba)[Finding Version of OFFICE 365 Build version with MS-Access VBA](https://stackoverflow.com/q/72493608/154439) - [Speeding up Front End DB while still developing](https://www.access-programmers.co.uk/forums/threads/speeding-up-front-end-db-while-still-developing.323601/) - [Phone Numbers Update](https://www.access-programmers.co.uk/forums/threads/phone-numbers-update.323564/) #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) \- [Standard Module Object Generation](https://www.youtube.com/watch?v=gTRt-fxwAJA) (53:37): *presented by Alan Cossey for the Access Europe User Group* \- [Drawing Shapes in an Access Report](https://www.youtube.com/watch?v=FVJx2BGrKu8) (1:20:29): *Creating the Periodic Table of Elements with Crystal Long for Access Pacific User Group* - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) \- [A Better Date Picker](https://www.youtube.com/watch?v=whwVSkSEjKw) (10:56) - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [SubQuery in Criteria](https://www.youtube.com/watch?v=TjF7dQ8JhdQ) (2:03): *Use Subquery as Criteria in Access Query (SubSelect statement compare to average) \~ DataPig* \- [Smart Parameters](https://www.youtube.com/watch?v=N11Yg-gMiig) (2:31): *Using Smart (Dynamic) Parameters in Access Queries \~ DataPig* \- [% of Total](https://www.youtube.com/watch?v=VNUA7gNSLTA) (3:19): *Getting Percent of Total using the DSUM aggregate function \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Large Check Box](https://www.youtube.com/watch?v=4-Wy4PWtFUk) (15:41): *How to Create a Large, Custom-Sized Checkbox in Microsoft Access Forms & Reports* \- [If Then](https://www.youtube.com/watch?v=c3QmpLo1EDw) (9:25): *If, Then, ElseIf, Else, End If - Conditional Statements in Microsoft Access VBA (Visual Basic)* \- [Average Rank & Median](https://www.youtube.com/watch?v=uzTQZpcoi1E) (27:09): *How to Calculate the Average, Rank, and Median Values of a Set of Records in Microsoft Access* \- [Gmail App Passwords ](https://www.youtube.com/watch?v=eDELkdvqSz8)(5:46): *How to Configure App Passwords to use Gmail with Your Mail Program, Less Secure Apps, MS Access, VBA* \- [Access Beginner 2, Lesson 2](https://www.youtube.com/watch?v=YgegZnxnD0U) (12:51): *Form Design, Intro to Relationships, Combo Boxes* *NOTE: The new videos posted to Crystal's YouTube page are part of an [effort to preserve the Access content of retiring creators](https://www.access-programmers.co.uk/forums/threads/status-of-databaseanswers-org.322983/).* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*Purpose of System Tables*](https://isladogs.co.uk/purpose-of-system-tables/index.html), by Colin Riddington - *[Feast your eyes on three Microsoft Access infographics](https://techcommunity.microsoft.com/t5/access-blog/feast-your-eyes-on-three-microsoft-access-infographics/ba-p/1133400)*, by Mark Gillis - [*Terrible Clients Explained With Pirates*](https://toggl.com/track/worst-client-types-infographic/) - *[TSQL: How to use XML parameters in stored procedures](https://www.computerworld.com/article/2960645/tsql-how-to-use-xml-parameters-in-stored-procedures.html)*, by Stephen Glasskeys --- ## 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/). - [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 --- ## Access Roadmap *There were *NO CHANGES* to the roadmap between last week (2022-06-04) and this week (2022-06-11).* 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, *[Changes to Our Public Roadmap and How We Communicate Access Feature Priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075)*. - Inconsistent Database Error Fix - New (Modern) Web Browser Control (to support Chromium Edge) - Enabling Large Address Aware (LAA) for 32-Bit Access - SQL Monaco Editor - New Microsoft Graph Data Connector #### In Development None. #### Rolling Out None. #### Launched - `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)