Week in Review: December 30, 2023

Just Published

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

Articles

• Jonathan Halder | Steven Halder (Access JumpStart 2.0)

  • TDD – 020 – Crossover Article… working on 2 computers
  • TDD – 021 – Prepping SVN Working Copy on the Laptop
  • TDD – 022 – Configuring and preparing OASIS-SVN
  • TDD – 023 – Exporting from OASIS-SVN and finishing up

• Daniel Pineault (DEVelopers HUT)

  • Display Images In The Modern Web Browser Control While Preserving The Aspect Ratio
  • Display Images In The (Old) Web Browser Control While Preserving The Aspect Ratio

• Colin Riddington (Isladogs on Access)

  • AEU24: Top 10 Advanced Features of MZ-Tools (Updated)
  • Filter By Form
  • Multiselect Filter in a Continuous Form (Updated)

• Crystal Long (Ms Access Gurus | Access Access Newsletter)

  • Modify Word Document Properties with Access

• Mike Wolfe (NoLongerSet)

  • Common Uses for One-to-One Database Relationships
  • How to Filter Reports in Microsoft Access
  • 18 Tips to Build a Great Report Filtering User Experience in Microsoft Access
  • How to Access the .Document Property to Parse Web Pages Using the New Edge Browser Control
  • Merry Christmas

Videos‌

• Access User Group Recordings (YouTube channel)

  • Basics of Classes in VBA (01:09:56): with Adrian Bell
  • Automating Access Programming – Leveraging MZ Tools (01:38:59): with Carlos Quintero -- CORRECTED
  • Modify Word Document Properties with Access (58:42): with Crystal Long

• Colin Riddington [Isladogs] (YouTube channel)

  • Multiselect Filter in a Continuous Form (12:04)

• George Hepworth (YouTube channel)

  • Named Formulas in PowerApps (21:18): Wanna Feed Your Need for Speed? Named Formulas instead of Collections for PowerApps

• Richard Rost (YouTube channel)

  • Edge Part 6: Trusted Domains (22:21): Using the New Edge Browser Control in Microsoft Access, Part 6: Trusted Domains
  • Edge Part 7: Navigation Events (18:46): Using the New Edge Browser Control in Microsoft Access, Part 7: Navigation Events
  • Edge Part 8: Get Page Text (20:21): Using the New Edge Browser Control in Microsoft Access, Part 8: Get Page Text
  • "Gain" or "Loss" (24:58): Identifying Gains and Losses in Microsoft Access Using IIF and ABS and some Concatenation

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

• January 3, 2024: Ramachandran (A.P.R.) Pillai - Streamlining the Form Module Code in the standalone Class Module
• January 4, 2024: Kent Gorrell - The Power of Sub classes in Access VBA (fixed broken link)
• February 7, 2024: Carlos Quintero - Features of MZ-Tools to make you more productive with VBA
• March 6, 2024: Thomas Möller - Better Access Charts in the new Edge Browser Control
• March 15, 2024: Access Day - one-day in-person Access Conference in Seattle, WA area
• April 3, 2024: Dale Fye - Working with Command Bars and the Access Shortcut Tool
• April 18-19, 2024: Access DevCon Vienna - (Online in Microsoft Teams) Agenda to be announced
• May 1, 2024: Colin Riddington - View & Edit Import/Export (IMEX) Data Task Specifications

‌

Access Roadmap

There were NO CHANGES to the roadmap between the last Week in Review (2023-12-23) and this one (2023-12-30).

The development priorities were last updated at the German-language AEK conference on October 14, 2023.

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 or Access engineering team presentations.  I'll include a link to the source of 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, Microsoft's Plans for Access in the Next 6 Months.

The items are listed in priority order according to Principal Engineering Manager Dale Rector.  The "Expected Benefit" of each feature is shown in italics after the description of the feature itself.

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

1. Continued Focus on Monthly Issue Fixes: (Monthly Issue Fix Blog) Improved product quality and reliability
2. Access becomes Large Address Aware: Removal of key customer error issue
3. Dataverse export improvements: Make it easier and faster for admins to migrate their data to Dataverse
4. Large monitor support for forms: Improved support of Access on the latest hardware
5. Modern Chart Improvements: Expanded support for the most popular chart types and options
6. SQL Editor Improvements: Significantly improved SQL query editing experience
7. Inconsistent Database Error Fix

Special thanks to Karl Donaubauer for posting the updated priorities at AccessForever.org.

In Development

• NOV 2023: Making 32-bit Access Large Address Aware (LAA)

Rolling Out

None.

Launched

• APR 2023: Modern Web Browser Control
• MAR 2023: New Modern Web Browser Form Control

UPDATED [2023-12-31]: Fixed broken link to Kent Gorrell's presentation on sub-classes in VBA (h/t Crystal Long via email).