Week in Review

Week in Review: October 15, 2022

Highlights include changes to the Access team's development priorities, adding spell check to Access, and generating Excel charts via automation from Access.

Mike Wolfe

Oct 15, 2022 • 3 min read

Just Published

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

Articles

Our Road Ahead - Microsoft Access Engineering Priorities Oct 2022, by Michael Aldridge
Access Roadmap Update (Oct 2022), by Colin Riddington
Get Default Printer, by Colin Riddington
AEU8: Cataloguing & searching emails, by Colin Riddington
Is Location Trusted?, by Colin Riddington
Update All Form & Report Fonts, by Colin Riddington
Table Size Check, by Colin Riddington
How to monetize your data with artificial intelligence (AI) & analytics, by Maria Barnes
Bug Alert Follow-Up: CurrentDb and DAO.OpenDatabase, by Mike Wolfe
WriteTempFile(): A Simple VBA Function to Save Text to a New Temporary File, by Mike Wolfe
The Problems with Boilerplate Code, by Mike Wolfe
BUG ALERT: FortiClient VPN and Windows Update KB5018410, by Mike Wolfe
VBA: A Simple Programming Language, by Mike Wolfe

Videos‌

Access User Group Recordings (YouTube channel)
- Cataloguing and Searching Emails with Access (1:00:12): by Alessandro Grimaldi
- Cleaning Up Duplicates in Large Data Sets (59:40): by Linda Ewen
Richard Rost (YouTube channel)
- Age Demographics (20:54): Get a Count of Customers by Bracketed Age Demographic Group Ranges in Microsoft Access
- Decades (12:22): How to Show the Decade for a Date Value in Microsoft Access
- After Update (10:50): How to Update Data Automatically Using the After Update Event in Microsoft Access
- Check Spelling (13:35): How to Check Spelling in Microsoft Access Forms
Daniel Pineault (YouTube channel)
- Microsoft Access Basics (31:10): What You Need To Know Before You Get Started [EDITOR'S NOTE: This video includes a great section on both the strengths and weaknesses of Microsoft Access.]
- Managing Tables (12:18): Tables (Importing, Linking) and the Linked Table Manager
- Generate Charts in Excel (16:36)
- Export Data to Excel (32:25)

New to Me

^{This section includes content I discovered this week that has been around for awhile.}

Nothing new this week.

‌

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

October 20, 2022: George Young - All About Access in an Azure VM (JUST ADDED)
October 25, 2022: Duane Hookom - Embedding a Table of Contents into a Report
November 2, 2022: George Hepworth - Power Apps for Access Developers
November 3, 2022: Ned Pajic - Hosting Access Applications "in the cloud"
December 7, 2022: Colin Riddington - Annotating Google Maps in Access
January 4, 2023: Peter Bryant - Automating DSN-less Communications to SQL Server
January 31, 2023: Colin Riddington - Translate & Speak Using Access (JUST ADDED)
February 1, 2023: Thomas Möller - Better Access Charts
March 1, 2023: Maria Barnes - Optimizing Queries in SQL Server (JUST ADDED)
June 7, 2023: Thomas Pfoch - Maps for Microsoft Access (JUST ADDED)

‌

Access Roadmap

There were no changes to the roadmap itself between last week (2022-10-08) and this week (2022-10-15). The Access roadmap was last updated on May 31, 2022. However, the DEVELOPMENT PRIORITIES WERE UPDATED for the first time since 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, Our Road Ahead - Microsoft Access Engineering Priorities Oct 2022.

New priorities added since the previous set of priorities are shown in bold below. Dropped priorities are struck through.

Continued Focus on Monthly Issue Fixes (Monthly Issue Fix Blog)
Inconsistent Database Error Fix
New Macro Signing Support
New (Modern) Web Browser Control (to support Chromium Edge)
Dataverse Connector Data Type Support for Floating Point
Dataverse Connector Data Type Support for Rich Text
Dataverse Connector support to export to a specific Dataverse solution or publisher
~~Enabling Large Address Aware (LAA) for 32-Bit Access~~
~~SQL Monaco Editor~~
~~New Microsoft Graph Data Connector~~

In Development

None.

Rolling Out