> ## 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: August 27, 2022 - URL: https://nolongerset.com/week-in-review-2022-08-27/ - Published: 2022-08-27T21:06:12.000Z - Updated: 2026-05-08T12:55:11.000Z - Description: Highlights include a dedicated web page for the Access Europe User Group, a Nav Pane Helper Add-in, and a deep dive into database theory. - 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 - [*Navigation Pane Helper Add-In*](https://isladogs.co.uk/nav-pane-helper-addin/index.html), by Colin Riddington - [*Access Europe User Group*](https://isladogs.co.uk/access-europe/index.html), by Colin Riddington - [*AEU1- Inaugural Meeting (Colin & Alessandro)*](https://isladogs.co.uk/aeu-1/index.html), by Colin Riddington - [*AEU3: Classic vs Modern Charts (Crystal Long)*](https://isladogs.co.uk/aeu-3/index.html), by Colin Riddington - [*AEU5: Build Ribbon Interfaces in Code (Mike Wolfe)*](https://isladogs.co.uk/aeu-5/index.html), by Colin Riddington - [*AEU6: 32 to 64-bit Conversion (Peter Cole)*](https://isladogs.co.uk/aeu-6/index.html), by Colin Riddington - [*Hidden Message Challenge*](https://isladogs.co.uk/hiddenmessage/index.html), by Colin Riddington - [*JET ShowPlan Manager Add-In*](https://isladogs.co.uk/jet-showplan-manager-addin/index.html), by Colin Riddington - *[How to be a Data Centric Company](https://www.linkedin.com/pulse/how-data-centric-company-maria-barnes/)*, by Maria Barnes - *[Bug Alert: Wizards Don't Work with MVFs and Attachment Fields](https://nolongerset.com/bug-alert-report-wizard-hangs/)*, by Mike Wolfe - *[HOW TO: Handle Excel Events in a twinBASIC COM Addin](https://nolongerset.com/handle-excel-events-in-twinbasic/)*, by Mike Wolfe - *[AccessImagine: ActiveX Picture Control for Access](https://nolongerset.com/access-imagine/)*, by Mike Wolfe - *[Adding References from VBA](https://nolongerset.com/adding-references-from-vba/)*, by Mike Wolfe - [*Access Job Interview Questions*](https://nolongerset.com/access-job-interview-questions/), by Mike Wolfe #### Videos - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Nav Pane Add-in](https://www.youtube.com/watch?v=SJ-9eBsf3s4) (2:26): *Navigation Pane Helper Add-In* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Send Email](https://www.youtube.com/watch?v=EL4ZFtMhO7w) (13:39): *Send Email from Access \~ DataPig* - [Mouse Move Event](https://www.youtube.com/watch?v=Uerjt2%5FdrVE) (5:37): *Give Web Page feel to Access Forms with the Mouse Move event \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Delete Queries](https://www.youtube.com/watch?v=goHTBaDbWzE) (13:38): *How to Create a Delete Query to Delete Records from Tables in Microsoft Access* - [Year Month Day](https://www.youtube.com/watch?v=l7jnyeqzjQE) (11:18): *How to Use the Year, Month, & Day Functions to Get Parts of a Date in Microsoft Access* - [Sort by Month](https://www.youtube.com/watch?v=MmOO5Zz%5Fg0E) (9:11): *How to Sort by Month in Microsoft Access (Alphabetically and Chronologically) Using Month, MonthName* - [Reports Not Updating](https://www.youtube.com/watch?v=dmv7kHKPGAQ) (9:44): *Reports Not Updating in Microsoft Access? Automatically Refresh Before Print or Preview.* - [New Hire Emails](https://www.youtube.com/watch?v=DC-H3mFKiOw) (18:15): *How to Automatically Assign Email Addresses to New Hires in Microsoft Access* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*Things You Should Know About Databases*](https://architecturenotes.co/things-you-should-know-about-databases/), by Mahdi Yusuf - [*Stop Visual Basic 6 From Changing My Casing*](https://stackoverflow.com/a/1078018/154439), answered by user *wqw* (aka, Vladimir Vissoultchev): The Q&A refer to VB6, but may also apply to VBA (I haven't tested it yet). It has gotten my wheels turning for a potential way to enforce project-wide variable casing consistency with the help of twinBASIC. Possibly more to come...stay tuned. --- ## 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/). - [September 1, 2022](https://accessusergroups.org/pacific/event/257-2022-09-01/): **Jack Stockton** \- Codifying Long Names into Unique Codes - [September 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-09-07/): **Colin Riddington** \- Optimizing Queries and the Use of JETSHOWPLAN - [September 15, 2022](https://www.daaug.org/Presentations/Details/243): **George Hepworth** \- Book Collection Management Using Power Apps (and Access) **(ADDED THIS WEEK!!!)** - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Cataloguing and searching emails with Access - [October 6, 2022](https://accessusergroups.org/pacific/event/257-2022-10-06/): **Brian Krotine** \- Hosting Access Applications "in the cloud" - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts --- ## Access Roadmap *There were *NO CHANGES* to the roadmap between last week (2022-08-20) and this week (2022-08-27).* 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, *[Changes to Our Public Roadmap and How We Communicate Access Feature Priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075)*. 1. Inconsistent Database Error Fix 2. New (Modern) Web Browser Control (to support Chromium Edge) 3. Enabling Large Address Aware (LAA) for 32-Bit Access 4. SQL Monaco Editor 5. New Microsoft Graph Data Connector #### In Development None. #### Rolling Out None. #### Launched - `MAY 2022`: Access Dataverse Connector - `JAN 2021`: Access: ODBC Interface Support (without ACE Redistributable Engine) - `JAN 2021`: Access: DAO Interface Support (without ACE Redistributable Engine)