> ## 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: September 17, 2022 - URL: https://nolongerset.com/week-in-review-2022-09-17/ - Published: 2022-09-17T21:07:31.000Z - Updated: 2026-05-08T12:54:40.000Z - Description: Highlights include a new YouTube channel from Daniel Pineault, modern chart reference, and form resizing and "profiles" videos. - 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 - [*Modern Chart Reference*](http://msaccessgurus.com/article/Chart%5FModern.htm), by Crystal Long - *[Access – The Mysterious Case Of The Listbox Order Exception](https://www.devhut.net/access-the-mysterious-case-of-the-listbox-order-exception/)*, by Daniel Pineault - [*Access – Bar Code Generator*](https://www.devhut.net/access-bar-code-generator/), by Daniel Pineault - [*Access AEK is Almost Upon Us*](https://www.devhut.net/access-aek-is-almost-upon-us/), by Daniel Pineault - [*Access – The Case Of The Missing Ribbon Icons*](https://www.devhut.net/access-the-case-of-the-missing-ribbon-icons/), by Daniel Pineault - [*VBA – Extracting What I Need From A String*](https://www.devhut.net/vba-extracting-what-i-need-from-a-string/), by Daniel Pineault - [*Microsoft’s Security Is Laughable!*](https://www.devhut.net/microsofts-security-is-laughable/), by Daniel Pineault - [*Edge – Invisible Menus, Where Did They Go?*](https://www.devhut.net/edge-invisible-menus-where-did-they-go/), by Daniel Pineault - [*Microsoft Access Command-Line Switches*](https://www.devhut.net/microsoft-access-command-line-switches/), by Daniel Pineault - *UPDATED: [Accurately Move Forms & Controls](https://isladogs.co.uk/move-forms-controls/index.html)*, by Colin Riddington - *[Now the Shift from a Manual Problem to a Technology-Driven Solution is Easier than Ever](https://www.linkedin.com/pulse/now-shift-from-manual-problem-technology-driven-solution-maria-barnes/)*, by Maria Barnes - *[VIDEO: "Codifying" Long Names](https://nolongerset.com/video-codifying-long-names/)*, by Mike Wolfe - *[Unicode Private Use Areas in VBA](https://nolongerset.com/private-use-areas/)*, by Mike Wolfe - *[PICNIC: The Underlying Cause of Many Technical Support Calls](https://nolongerset.com/picnic/)*, by Mike Wolfe - *[Unicode MsgBox Revisited](https://nolongerset.com/unicode-msgbox-revisited/)*, by Mike Wolfe - [*Avoid Context Switching for More Readable Code*](https://nolongerset.com/avoid-context-switching/), by Mike Wolfe #### Videos - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [Microsoft Access Command Line Switches](https://www.youtube.com/watch?v=YGvh5pMJgLk) (13:40) - [Fixing Microsoft Edge's Invisible Menus](https://www.youtube.com/watch?v=ZEIxBenocPM) (3:17) - [Updating And Reverting Your Microsoft Office Build](https://www.youtube.com/watch?v=JROodrU7CEQ) (9:14) - [Identifying Your Microsoft Office Installation Information](https://www.youtube.com/watch?v=G7qAC985Hus) (7:46): *Including Office version, build number, and bitness* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Variable Scope](https://www.youtube.com/watch?v=bBQH8nWFtzw) (25:00): *Variable Scope & Visibility in Microsoft Access VBA (Public, Private, Dim, Global, etc.)* - [Resize Forms](https://www.youtube.com/watch?v=IItLb9Inw0Y) (25:49): *Resize Microsoft Access Forms for Different Screen Sizes & Resolutions Using Anchoring. Zoom In/Out.* - [Control Copy Technique](https://www.youtube.com/watch?v=p7zcld-J76k) (8:24): *Tips on Copy & Paste Technique for Microsoft Access Form & Report Controls* - [Form Profile](https://www.youtube.com/watch?v=fYjYjFiLMxg) (3:59): *Microsoft Access Form Profile Template - Multiple Profiles for Different Screen Sizes, Colors, Etc.* - [DSum](https://www.youtube.com/watch?v=WzwpFfYPQnA) (14:32): *DSum Function with Multiple Criteria in Microsoft Access to Calculate Previous 30 Days Sales Totals* - [First Day of the Week](https://www.youtube.com/watch?v=ojo2psqhX6s) (11:05): *How to Find the First and Last Days of the Week in Microsoft Access* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Why your website should be under 14kB in size](https://endtimes.dev/why-your-website-should-be-under-14kb-in-size/)*, by Nathaniel at [endtimes.dev](https://endtimes.dev/) --- ## 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/). - [September 27, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-09-27/): **Alessandro Grimaldi** \- Using Text-to-Speech (TTS) in Access - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Cataloguing and searching emails with Access - [October 6, 2022](https://accessusergroups.org/pacific/event/257-2022-10-06/): **Brian Krotine** \- Hosting Access Applications "in the cloud" - [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 - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts --- ## Access Roadmap *There were *NO CHANGES* to the roadmap between last week (2022-09-10) and this week (2022-09-17). The Access roadmap was last updated on May 31, 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, *[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)*. 1. Inconsistent Database Error Fix 2. New (Modern) Web Browser Control (to support Chromium Edge) 3. Enabling Large Address Aware (LAA) for 32-Bit Access 4. SQL Monaco Editor 5. 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)