Week in Review

Week in Review: September 17, 2022

Highlights include a new YouTube channel from Daniel Pineault, modern chart reference, and form resizing and "profiles" videos.

Mike Wolfe

Sep 17, 2022 • 3 min read

Just Published

^{This section includes videos, articles, and interesting discussions from the past 7 days.}

Articles

Modern Chart Reference, by Crystal Long
Access – The Mysterious Case Of The Listbox Order Exception, by Daniel Pineault
Access – Bar Code Generator, by Daniel Pineault
Access AEK is Almost Upon Us, by Daniel Pineault
Access – The Case Of The Missing Ribbon Icons, by Daniel Pineault
VBA – Extracting What I Need From A String, by Daniel Pineault
Microsoft’s Security Is Laughable!, by Daniel Pineault
Edge – Invisible Menus, Where Did They Go?, by Daniel Pineault
Microsoft Access Command-Line Switches, by Daniel Pineault
UPDATED: Accurately Move Forms & Controls, by Colin Riddington
Now the Shift from a Manual Problem to a Technology-Driven Solution is Easier than Ever, by Maria Barnes
VIDEO: "Codifying" Long Names, by Mike Wolfe
Unicode Private Use Areas in VBA, by Mike Wolfe
PICNIC: The Underlying Cause of Many Technical Support Calls, by Mike Wolfe
Unicode MsgBox Revisited, by Mike Wolfe
Avoid Context Switching for More Readable Code, by Mike Wolfe

Videos

Daniel Pineault (YouTube channel)
- Microsoft Access Command Line Switches (13:40)
- Fixing Microsoft Edge's Invisible Menus (3:17)
- Updating And Reverting Your Microsoft Office Build (9:14)
- Identifying Your Microsoft Office Installation Information (7:46): Including Office version, build number, and bitness
Richard Rost (YouTube channel)
- Variable Scope (25:00): Variable Scope & Visibility in Microsoft Access VBA (Public, Private, Dim, Global, etc.)
- Resize Forms (25:49): Resize Microsoft Access Forms for Different Screen Sizes & Resolutions Using Anchoring. Zoom In/Out.
- Control Copy Technique (8:24): Tips on Copy & Paste Technique for Microsoft Access Form & Report Controls
- Form Profile (3:59): Microsoft Access Form Profile Template - Multiple Profiles for Different Screen Sizes, Colors, Etc.
- DSum (14:32): DSum Function with Multiple Criteria in Microsoft Access to Calculate Previous 30 Days Sales Totals
- First Day of the Week (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, by Nathaniel at 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.}

September 27, 2022: Alessandro Grimaldi - Using Text-to-Speech (TTS) in Access
October 5, 2022: Alessandro Grimaldi - Cataloguing and searching emails with Access
October 6, 2022: Brian Krotine - Hosting Access Applications "in the cloud"
November 2, 2022: George Hepworth - Power Apps for Access Developers
December 7, 2022: Alexsander Wojtasz - Interactive Gantt Chart Scheduler in Access
January 4, 2023: Peter Bryant - Automating DSN-less Communications to SQL Server
February 1, 2023: 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.

"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.

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