> ## 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 13, 2022
- URL: https://nolongerset.com/week-in-review-22-08-13/
- Published: 2022-08-13T18:50:17.000Z
- Updated: 2026-05-08T12:55:34.000Z
- Description: Highlights include Peter Cole's 32 to 64-bit conversion presentation, a deep dive into how Access stores queries, and a sad announcement from MVP Daniel Pineault.
- 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

- [*Reduction of Contributions*](https://www.devhut.net/reduction-of-contributions/), by Daniel Pineault
- [*How Access Stores Queries (Part 2 of 2)*](https://isladogs.co.uk/explaining-queries-2/index.html), by Colin Riddington
- [*PESKY BUGS - How to manage them*](https://www.linkedin.com/pulse/pesky-bugs-how-manage-them-maria-barnes/), by Maria Barnes
- *[GetTempPath: Using the Windows API for Maximum Performance](https://nolongerset.com/gettemppath/)*, by Mike Wolfe
- *[My File System Variable Naming Convention for VBA](https://nolongerset.com/vba-file-system-naming-convention/)*, by Mike Wolfe
- *[LimitTextLength: Enforce Max Text Length for Unbound Text Boxes and Combo Boxes](https://nolongerset.com/limittextlength/)*, by Mike Wolfe
- *[HOW TO: Install twinBASIC](https://nolongerset.com/how-to-install-twinbasic/)*, by Mike Wolfe
- *[MakeSurePathExists: Using the Windows API to Create Missing Subfolders in VBA](https://nolongerset.com/makesurepathexists/)*, by Mike Wolfe

#### Videos

- **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg))  
  - [Building Ribbon Interfaces in Code](https://www.youtube.com/watch?v=MS2yfOXsa-c) (47:50): *by Mike Wolfe*
  - [AEU: 32 to 64-bit Conversion](https://www.youtube.com/watch?v=NE-ixCSkEgI) (1:11:26): *by Peter Cole*
- **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal))  
  - [Auto Expand Form](https://www.youtube.com/watch?v=-s9WExOuQk8) (5:19): *Automatically Expand or Contract an Access form to Show More or Less Controls \~ DataPig*
  - [Enable Disable](https://www.youtube.com/watch?v=Q58ys1hb%5FEs) (6:08): *Enable and Disable Controls in Access \~ DataPig*
  - [Add Record](https://www.youtube.com/watch?v=9aYojSxGxLU) (7:16): *Add Record with Query – data from controls on unbound form \~ DataPig*
  - [Conditional Formatting](https://www.youtube.com/watch?v=aK1LJSysILA) (4:27): *Conditional Formatting on an Access Form \~ DataPig*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))  
  - [Transpose Data](https://www.youtube.com/watch?v=g9GDraMpiwA) (33:01): *Transpose Data in Excel and Properly Normalize it in Microsoft Access*
  - [Crosstab Query](https://www.youtube.com/watch?v=w3RqAuA7CBY) (16:49): *Create a Crosstab Query in Microsoft Access to Summarize Data from Two Fields*
  - [Append Query](https://www.youtube.com/watch?v=I994YhgbeNE) (13:51): *Using an Append Query in Microsoft Access to Add Records to a Table*
  - [Indexing](https://www.youtube.com/watch?v=p4p1Xq4b1jI) (13:57): *Indexing Fields in Microsoft Access Tables for Optimal Database Performance*
  - [Week in Review](https://www.youtube.com/watch?v=gTqkxa3C9N8) (2:14): *Mike Wolfe's Microsoft Access "Week in Review" at NoLongerSet.com - Access News, Tips, Articles*

#### Discussions

- [Order By causes a scan on a large table](https://dba.stackexchange.com/q/315205/6390) (in SQL Server)

---

## New to Me

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

- [*Advice for New Software* ](https://www.dylanpaulus.com/advice-for-new-software-engineers/)[Engineers](https://www.dylanpaulus.com/advice-for-new-software-engineers/), by Dylan Paulus
- *[Solving the Unicode, UTF8, UTF16 and Text Files conundrum in VBA](https://francescofoti.com/2020/01/solving-the-unicode-utf8-utf16-and-text-files-conundrum-in-vba/)*, by Francesco Foti
- [*Access: using .Net strings in VBA for fun and profit*](http://blog.nkadesign.com/2013/09/12/access-using-net-strings-in-vba-for-fun-and-profit/), by Renaud Bompuis

---

## 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/).

- [August 18, 2022](https://www.daaug.org/Presentations/Details/241): **Richard Hanson (Pharos Technologies)** \- Building a Used Book Business with Microsoft Access Automation
- [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
- [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Graphical Interfaces in 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 connections 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-06) and this week (2022-08-13).*

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)

***UPDATE*** *\[2022-08-15\]: Added Richard Hanson to the upcoming presentations list for August 18, 2022.*