> ## 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: October 1, 2022 - URL: https://nolongerset.com/week-in-review-2022-10-01/ - Published: 2022-10-02T03:59:00.000Z - Updated: 2026-05-08T12:54:27.000Z - Description: Highlights include Pivot Tables and Pivot Charts, exporting all Access tables into Excel, and many changes to future Access User Group presentations. - 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 - *[Exporting All Access Tables into Excel Workbook](https://www.msaccesstips.com/2022/09/exporting-all-access-tables-into-excel.html)*, by a.p.r. pillai - *[SQL for Query to List Object Names in Access database](https://msaccessgurus.com/VBA/Query%5FSQL%5FListObjects.htm)*, by Crystal Long - [*Developing Project Requirements and Specifications*](https://www.devhut.net/developing-project-requirements-and-specifications/), by Daniel Pineault - [*Access Pivot Tables and Pivot Charts*](https://www.devhut.net/access-pivot-tables-and-pivot-charts/), by Daniel Pineault - [*Add References using code*](https://isladogs.co.uk/references-code/index.html), by Colin Riddington - *UPDATED:* [*Currency Exchange Rate Tracker*](https://isladogs.co.uk/cert/index.html), by Colin Riddington - *UPDATED:* [*UK Postal Address Finder*](https://isladogs.co.uk/uk-postal-address-finder/index.html), by Colin Riddington - *UPDATED:* [*JSON Analyse & Transform for Access*](https://isladogs.co.uk/json-analyse-transform/index.html), by Colin Riddington - *[Democratization of your data during design](https://www.linkedin.com/pulse/democratization-your-data-during-design-maria-barnes/)*, by Maria Barnes - *[Timeline for VBA Macros Blocked by Default in Microsoft Office](https://nolongerset.com/timeline-for-vba-macro-blocking/)*, by Mike Wolfe - *[Populating a List Box with the TempVars Collection](https://nolongerset.com/populatelistboxwithtempvars/)*, by Mike Wolfe - *[tblTempVar: Creating and Populating a Table of TempVars](https://nolongerset.com/tempvars-table/)*, by Mike Wolfe - *[VIDEO: Design Patterns with Access](https://nolongerset.com/design-patterns-in-access/)*, by Mike Wolfe - *[Getting the Temp Folder in VBA](https://nolongerset.com/getting-the-temp-folder-in-vba/)*, by Mike Wolfe #### Videos‌ - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) - [Annotate Google Maps in Access](https://www.youtube.com/watch?v=W9GAhehmx%5FM) (48:26): *Originally presented during Access DevCon 2022* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Report Border](https://www.youtube.com/watch?v=UYCgY-v8nE4) (14:08): *How to Draw a Border Around a Report Page in Microsoft Access with the Line Command* - [First Day of the Month](https://www.youtube.com/watch?v=xKM%5Fvc01LRM) (14:06): *How to Find the First and Last Days of This Month, Next Month, Previous Month in Microsoft Access* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [VBA - File and Folder Dialogs](https://www.youtube.com/watch?v=wCiG73yDiZE) (18:44) - [Sending Emails with VBA](https://www.youtube.com/watch?v=N359FgkMhTM) (52:48) - [MS Access Pivot Tables and Charts](https://www.youtube.com/watch?v=2m5xS4HY0HI) (27:13) - [Splitting a Database and Creating Persistent Connections](https://www.youtube.com/watch?v=POvGoJ9n9I0) (24:48) - [Microsoft Access Slow Offline](https://www.youtube.com/watch?v=kvyyVdyxh7w) (2:46) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Convert ISBN10 to ISBN13](https://www.youtube.com/watch?v=KvX5CnW71IA) (9:58): *Using VBA to Convert ISBN10 to ISBN13* - [Form Event Handling](https://www.youtube.com/watch?v=bGwWa1Qi11c) (18:07): *Event Triggers and How To Use Them* - [Expert Wait Screens](https://www.youtube.com/watch?v=p6-mgHHBr%5F8) (12:08): *Real Life Examples and Code for Progress Notification Screens* --- ## New to Me This section includes content I discovered this week that has been around for awhile. *Nothing to show here 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](https://accessusergroups.org/calendar/). - [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"~~ **Linda Ewen** \- Cleaning up Duplicates in Large Data Sets (**UPDATED**) - [October 25, 2022](https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-10-25/): **Duane Hookom** \- Embedding a Table of Contents into a Report (**JUST ADDED**) - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [November 3, 2022](https://accessusergroups.org/pacific/event/257-2022-11-03/): **Ned Pajic** \- Hosting Access Applications "in the cloud" (**JUST ADDED**) - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): ~~**Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access~~ **Colin Riddington** \- Annotating Google Maps in Access (**UPDATED**) - [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-09-24) and this week (2022-10-01). The Access roadmap was last updated on May 31, 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, *[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)