Week in Review

Week in Review: June 18, 2022

Highlights include building custom progress bars, creating organizational charts, and yet another Access bug [sigh].

Mike Wolfe

Jun 18, 2022 • 3 min read

Just Published

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

Articles

Build 15225.20288 Causing Attachment Problems! by Daniel Pineault
Organizational Charts, by Daniel Pineault
Happy 4th Birthday ‘Inconsistent State’ Bug, by Daniel Pineault
Progress Bar, by Colin Riddington

Discussions

Updating Two different tables through one form
Database Structure
Run-time error 5 - Invalid procedure call or argument: Includes some good notes from The_Doc_Man on writing code while active form timers are running (tl;dr: don't do it)

Videos

Colin Riddington [Isladogs] (YouTube channel)
- Building a Progress Bar in Access (13:51)
Crystal Long (YouTube channel)
- Top Values per Group (5:27): Get Top Values per Group using a Subquery in Access ~ DataPig
- Top Values: Number or % (2:03): Using TOP Values in an Access Query ~ DataPig
Richard Rost (YouTube channel)
- Value List Combo Boxes (16:50): How to Create a Value List Combo Box Microsoft Access
- Fast Tips: WeekDay (8:46): How to Display the Day of the Week that a Particular Date Falls On in Microsoft Access (Weekday)
- Find Record (22:15): Microsoft Access Search: Find a Record on My Form Based on the Value I Selected in my Combo Box
- Access Amort 2.0 (12:29): Microsoft Access Loan Amortization Template 2.0 - Introduction for New Users. Welcome!
- Access Amort 2.0 Upgrade (25:00): Microsoft Access Loan Amortization Template 2.0 - Upgrade Video for Current Users
- Access Beginner 2, Level 3 (12:52): Form Formatting, The Grid, Properties, Themes
Pharos Technology [Dr. Richard Hanson] (YouTube channel)
- Number Formatting (7:28): Microsoft Access Number Formatting

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

VBA-Web: A Github repo maintained by Tim Hall that, "makes working with complex webservices and APIs easy with VBA"
Excel is like a pickup truck, Access is like a freight train: Clever analogy in this Quora answer from Jim Christmas

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

July 6, 2022: Mike Wolfe - Building Ribbon Interfaces in Code
July 21, 2022: Richard Rost - Custom List Box Columns
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
January 4, 2023: Peter Bryant - Automating DSN-less connections 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-06-11) and this week (2022-06-18).

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