Week in Review: December 23, 2023

Just Published

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

Articles

• Official Access Blog

  • Access Releases 7 Issue Fixes in Version 2311 (Released November 25th, 2023), by Linda Lu Cannon

• Access Forever

  • Access User Groups 2024, by Colin Riddington

• Maria Barnes (Business Data Bytes Newsletter)

  • What is Microsoft 365 Copilot?

• Jonathan Halder (Access JumpStart 2.0)

  • TDD – 016 – Begin to Create the Iterate method
  • TDD – 017 – Trying to get to the next simplest test (and failing)
  • TDD – 018 – Eureka! My first interface.
  • TDD – 019 – An interface? What’s the big deal?
  • Access Programming – What I do and Why (Find and Replace)

• Daniel Pineault (DEVelopers HUT)

  • Recover a Deleted Microsoft Access Table
  • Windows 11 Update Breaks WiFi!
  • Microsoft Access Database Schemas

• Colin Riddington (Isladogs on Access)

  • Multiselect Filter in a Continuous Form
  • Reserved Errors - no message for this error

• Mike Wolfe (NoLongerSet)

  • How to Set the Background Color of the Microsoft Access Application Window with VBA
  • Dropping #If VBA7 Then From API Declares
  • FIXED: "You entered an expression that has no value."
  • Poe: My Tool of Choice for Exploring the World of LLMs
  • "AI Will Take My Job": A Self-Fulfilling Prophecy

Videos‌

• Access User Group Recordings (YouTube channel)

  • Automating Access Programming – Leveraging MZ Tools (01:38:59): with Carlos Quintero

• Sean MacKenzie (YouTube channel)

  • Survey (48:51): ADI Part 7: Program a Simple Survey in Microsoft Access

• Richard Rost (YouTube channel)

  • Absolute Value (20:05): Constructing a Budget Variance Analysis Using the Absolute Value (ABS) Function in Microsoft Access
  • Edge Part 2: QR Codes (16:31): Using the New Edge Browser Control in Microsoft Access, Part 2: Generating QR Codes
  • Edge Part 3: Custom Browser (14:37): Using the New Edge Browser Control in Microsoft Access, Part 3: Build a Custom Web Browser Form
  • Edge Part 4: Navigation Buttons (17:33): Using the New Edge Browser Control in Microsoft Access, Part 4: Navigation Buttons
  • Edge Part 5: Back & Forward Buttons (14:54): Using the New Edge Browser Control in Microsoft Access, Part 5: Back & Forward Buttons

• Pharos Technology [Dr. Richard Hanson] (YouTube channel)

  • Auto Backup Made Easy (09:13): Easy Auto Backup Solutions for Access Databases

• Edcelle John Gulfan (YouTube channel)

  • COMBO BOX Column Value (05:20): Tutorial in Microsoft Access

New to Me

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

• Why do programmers need private offices with doors? (Do Not Disturb), by Mohamed

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
• 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 (JUST ADDED)
• 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-16) and this one (2023-12-23).

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