Week in Review

Week In Review: June 11, 2022

Highlights include a better date picker control, dashboard-style gauges, and drawing shapes in Access reports.

Mike Wolfe

Jun 11, 2022 • 3 min read

Just Published

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

Articles

Azure Web Services Don’t Do It! by Daniel Pineault
Microsoft Access Roadmap Updated, Again, by Daniel Pineault
Microsoft Access Gauges, by Daniel Pineault
A Better Date Picker, by Colin Riddington
Draw By Your Numbers… Follow the Data Paths and Connect the Dots, by Maria Barnes

Discussions

Videos

Access User Group Recordings (YouTube channel)
- Standard Module Object Generation (53:37): presented by Alan Cossey for the Access Europe User Group
- Drawing Shapes in an Access Report (1:20:29): Creating the Periodic Table of Elements with Crystal Long for Access Pacific User Group
Colin Riddington [Isladogs] (YouTube channel)
- A Better Date Picker (10:56)
Crystal Long (YouTube channel)
- SubQuery in Criteria (2:03): Use Subquery as Criteria in Access Query (SubSelect statement compare to average) ~ DataPig
- Smart Parameters (2:31): Using Smart (Dynamic) Parameters in Access Queries ~ DataPig
- % of Total (3:19): Getting Percent of Total using the DSUM aggregate function ~ DataPig
Richard Rost (YouTube channel)
- Large Check Box (15:41): How to Create a Large, Custom-Sized Checkbox in Microsoft Access Forms & Reports
- If Then (9:25): If, Then, ElseIf, Else, End If - Conditional Statements in Microsoft Access VBA (Visual Basic)
- Average Rank & Median (27:09): How to Calculate the Average, Rank, and Median Values of a Set of Records in Microsoft Access
- Gmail App Passwords (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 (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.

New to Me

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

Purpose of System Tables, by Colin Riddington
Feast your eyes on three Microsoft Access infographics, by Mark Gillis
Terrible Clients Explained With Pirates
TSQL: How to use XML parameters in stored procedures, 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.}

June 16, 2022: Karl Donaubauer - Design Patterns with Access
July 6, 2022: Mike Wolfe - Building Ribbon Interfaces in Code
August 3, 2022: Peter Cole - Automating 32-bit to 64-bit VBA Conversion
September 1, 2022: Jack Stockton - Codifying Long Names into Unique Codes
September 7, 2022: Colin Riddington - Optimizing Queries and the Use of JETSHOWPLAN
October 5, 2022: Alessandro Grimaldi - Graphical Interfaces in Access
November 2, 2022: George Hepworth - Power Apps for Access Developers
December 7, 2022: 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.

"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