> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Week in Review: April 8, 2023
- URL: https://nolongerset.com/week-in-review-2023-04-08/
- Published: 2023-04-08T18:52:19.000Z
- Updated: 2026-05-08T12:50:36.000Z
- Description: Highlights include a reliable way to bypass AutoExec in VBA, a Pro version of the IslaDogs Table Analyzer, and the new Rubberduck VBA Swag Shop.
- Author: Mike Wolfe
- Tags: Week in Review, #Import 2026-05-20 02:59

## Just Published

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

#### Articles

- **[Official Access Blog](https://techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog)**

  - [Access Releases 6 Issue Fixes in Version 2303 (Released March 28, 2023)](https://techcommunity.microsoft.com/t5/access-blog/access-releases-6-issue-fixes-in-version-2303-released-march-28/ba-p/3789614)
- **Mathieu Guindon** ([Rubberduck VBA](https://rubberduckvba.wordpress.com/))

  - [Rubberduck Swag Shop is Open!](https://rubberduckvba.wordpress.com/2023/04/07/rubberduck-swag-shop-is-open/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Power Automate – Delay Action](https://www.devhut.net/power-automate-delay-action/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Datasheet Totals Row Bug](https://isladogs.co.uk/datasheet-totals-row-bug/index.html)
  - [BUG: Breakpoints and special keys](https://isladogs.co.uk/breakpoint-special-keys/index.html)
  - [Navigation pane search bar code](https://isladogs.co.uk/nav-pane-search/index.html)
  - [AEU14: Creating calendar format reports](https://isladogs.co.uk/aeu-14/index.html)
  - [System Tray Alerts](https://isladogs.co.uk/system-tray-alerts/index.html) (*UPDATED*)
  - [ERROR: Trust Center Settings in ACCDR files](https://isladogs.co.uk/trust-center-accdr/index.html)
  - [BUG: Popup forms with breakpoints & navigation](https://isladogs.co.uk/popup-breakpoint-bug/index.html)
  - [Table Analyzer & Viewer Pro](https://isladogs.co.uk/table-analyzer-pro/index.html)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [LockControls() Function: Locking and Unlocking Multiple MS Access Controls in VBA](https://nolongerset.com/lockcontrols/)
  - [How to Safely Disable Controls in Microsoft Access](https://nolongerset.com/setctlenabled/)
  - [How to Use VBA to Set the ControlSource Property of an Access Image Control (and Other Deeply Hidden Object Properties)](https://nolongerset.com/deep-hidden-access-properties/)
  - [Spinning Plates: What this Parlor Trick Has in Common with Software Development](https://nolongerset.com/spinning-plates/)
  - [Feature Gates: How Microsoft Switched to a Single Code Base for Multiple Versions of Office](https://nolongerset.com/office-feature-gates/)

#### Videos‌

- **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA))

  - [Relationships Window Bug](https://www.youtube.com/watch?v=H6DCrip4Kqw) (2:18): *Update on the Relationships Windows Bug - Part 2*
  - [Datasheet Totals Row Bug](https://www.youtube.com/watch?v=p-Gvg9Iw9Rc) (2:27)
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [Subdatasheets](https://www.youtube.com/watch?v=dXz7msLEZ4M) (11:25): *What, How, & Why (I Don't Let End-Users Play With Them)*
  - [Denormalize For Performance](https://www.youtube.com/watch?v=mzsYZ--6tbQ) (20:56): *One Way to Speed Up your Microsoft Access Database*
  - [Disable AutoSave Subform](https://www.youtube.com/watch?v=UXvl5TsvF5k) (10:53): *How to Disable Automatic Record Saving in a Subform*
  - [Replication ID Foreign Key](https://www.youtube.com/watch?v=693-8UGMHJQ) (10:07): *Replication ID as a Foreign Key in Microsoft Access*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [Ranking Data Sets by Percentiles in Microsoft Access](https://www.youtube.com/shorts/DW0VMMtS08c) (Short)
  - [Customize the Access Toolbar](https://www.youtube.com/watch?v=5n43%5FD2SJ3I) (7:19): *Boost Your Productivity with Customized Quick Access Toolbar in MS Access*
  - [Median Magic: How to Locate the Middle of a Data Set in Microsoft Access](https://www.youtube.com/shorts/beX8JqgM21o) (Short)
  - [Database Design](https://www.youtube.com/watch?v=mILvhzZD1GQ) (5:10): *A Five-Step Database Design Guide for Beginners*

---

## New to Me

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

- *[Power Tip: Improve the security of database connections](https://www.microsoft.com/en-us/microsoft-365/blog/2011/04/08/power-tip-improve-the-security-of-database-connections/)*, by Ben Clothier
- *[Bypassing Autoexec](http://www.theaccessweb.com/api/api0068.htm)*, by Dev Ashish

---

## 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](https://accessusergroups.org/calendar/).

- [April 20, 2023](https://www.daaug.org/Presentations/Details/250): **Tom van Stiphout** \- Northwind 2.0 Is Here!
- [April 25, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-04-25/): **Maria Barnes** \- What's New with Access?
- [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna**
- [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access
- [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access
- [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow)
- [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access
- [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- (topic to be confirmed)

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-04-01) and this one (2023-04-08).*

*The [development priorities](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894) were last updated on October 12, 2022.*

---

Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access).

"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, *[Our Road Ahead - Microsoft Access Engineering Priorities Oct 2022](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894)*.

New priorities added since the [previous set of priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075) are shown in bold below. Dropped priorities are struck through.

1. **Continued Focus on Monthly Issue Fixes** *(Monthly Issue Fix Blog)*
2. Inconsistent Database Error Fix
3. **New Macro Signing Support**
4. New (Modern) Web Browser Control (to support Chromium Edge)
5. **Dataverse Connector Data Type Support for Floating Point**
6. **Dataverse Connector Data Type Support for Rich Text**
7. **Dataverse Connector support to export to a specific Dataverse solution or publisher**
8. ~~Enabling Large Address Aware (LAA) for 32-Bit Access~~
9. ~~SQL Monaco Editor~~
10. ~~New Microsoft Graph Data Connector~~

#### In Development

- `APR 2023`: Modern Web Browser Control
- `MAR 2023`: New Modern Web Browser Form Control

#### Rolling Out

None.

#### Launched

None.