Week in Review: May 7, 2022
Highlights include an IE integration article from Daniel Pineault, an Access tool from Crystal Long, and a PowerApps User Group video.
The Week in Review is the best way to keep up with the latest and greatest from the world of Microsoft Access. Every Saturday, I publish links from around the web. If you find or publish content that you think should be included, email me at mike at nolongerset dot com, tag me on Twitter @nolongerset, or tag me on LinkedIn Mike Wolfe. I retain full editorial control of what appears here. There are no paid or affiliate links, only high quality Microsoft Access content.
Click the "Subscribe" button above to receive this weekly update–along with links to my other daily articles–in your inbox every Sunday morning.
This section includes videos, articles, and interesting discussions from the past 7 days.
- Binding To An Existing Internet Explorer Instance, by Daniel Pineault
- A Trip Down Memory Lane, by Colin Riddington
- Identifying and Managing Mission-Critical Access Applications During a Development Project, by IT Impact
- Access User Group Recordings (YouTube channel)
- PowerApps (1:04:42): Yes, PowerApps IS For Access Developers
- Colin Riddington [Isladogs] (YouTube channel)
- Attention Seeking Database: Part 4 (8:41) - System Tray & Message Alerts
- Richard Rost (YouTube channel)
- Database Title & Icon (15:05): Change the Microsoft Access Application Title & Icon on Windows Taskbar, Desktop, Forms, & Reports
- Filter Characters (16:44): How to Remove Unwanted Characters from a Microsoft Access Text Field with a Custom Filter Function
- Save Button (8:17): How to Add a Save Button to Your Microsoft Access Forms
- Custom List Box Columns (28:09): Custom List Box Columns in Microsoft Access. Dynamically Display Fields Based on User Selection
- Developer 37 (5:26): User-Selected List of Fields to Display on a Form
- Disaster Recovery (11:00): How to Fix Your Data When You Accidentally Mess Up Records
New to Me
This section includes content I discovered this week that has been around for awhile.
- Analyzer for Microsoft Access, by Crystal Long et al.
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.
- May 10, 2022: Juan Soto (?) - Learn How to Sell Access with SQL Server Projects
- May 19, 2022: Kevin Bell - AppLauncher (a new Access front-end deployment service)
- June 1, 2022: Alan Cossey - Standard Module Object Generation
- June 2, 2022: Crystal Long - Drawing the Periodic Table of Chemical Elements with an Access Report
- 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 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
Listed below is a snapshot of the official Access Roadmap.
MAR 2022: Access Dataverse Connector
MAR 2022: New Microsoft Graph Data Connector
MAY 2022: Inconsistent Database Error Fix ("Monster Bug")
SEP 2022:New (Modern) Web Browser Control (to support Chromium Edge)
SEP 2022: Enabling Large Address Aware (LAA) for 32-Bit Access
DEC 2022: SQL Monaco Editor
Keep in mind, at the 2022 Access DevCon, Michael Aldridge from Microsoft gave an update on the Access Roadmap and warned that it would soon change to show only items that the team has 90% confidence that they will be able to deliver.
Long story short, everything from the above list except for the Dataverse Connector will be disappearing when the Access team updates the official roadmap (that apparently hasn't happened yet).
The items that disappear off the roadmap will be shown in priority order on an official Microsoft blog post. When that happens, I will update my Week in Review to include both the official Access Roadmap and the evolving list of priorities.
Request for Feedback
Let me know what you think of this new weekly feature in the comments below.
- Is it a worthwhile endeavor?
- Are there other types of content you would like to see included?
- Is there anything major that I missed?