> ## 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: July 29, 2023
- URL: https://nolongerset.com/week-in-review-2023-07-29/
- Published: 2023-07-29T15:30:45.000Z
- Updated: 2026-05-08T12:34:32.000Z
- Description: Highlights include Richard Rost's series on tracking account balances, barcode scanning via PowerApps, improving image quality, and a SQL formatting add-in.
- 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

- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))

  - [Streamlining Form Module Code - Part Eight](https://www.msaccesstips.com/2023/07/streamlining-form-module-code-part-eight.html)
- **[Access Experts](https://accessexperts.com/access-developer-blog/)**

  - [Managing Microsoft Access Autonumber Fields](https://accessexperts.com/blog/2023/07/26/managing-microsoft-access-autonumber-fields/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [Access Images Pixelated/Poor Quality](https://www.devhut.net/access-images-pixelated-poor-quality/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Count Jobs in Print Queue](https://isladogs.co.uk/print-queue-jobs/index.html) *(updated)*
  - [Available Connections Add-In](https://isladogs.co.uk/available-connections-addin/index.html) *(updated)*
  - [Available Connections](https://isladogs.co.uk/available-connections/index.html) *(updated)*
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [SQL Spacer add-in tool for Access](https://msaccessgurus.com/tool/Addin%5FSQLSpacer.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Logic Puzzle Solution Part 3: Counting the Possible Configurations](https://nolongerset.com/counting-permutations/)
  - [3 Situations for Using Named Arguments in VBA](https://nolongerset.com/named-arguments/)
  - [Evolution of a Function: ShowForm() Part 4](https://nolongerset.com/showform-part-4/)
  - [Evolution of a Function: ShowForm() Part 3](https://nolongerset.com/showform-part-3/)
  - [Archive Collection: Field Descriptions](https://nolongerset.com/archive-field-descriptions/)

#### Videos‌

- **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ))

  - [Extending Access with a PowerApps Barcode Scanner](https://www.youtube.com/watch?v=m1zOzN-hGSY) (1:10:42): *with George Hepworth*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [Account Balances: Part 3](https://www.youtube.com/watch?v=8uycBNoh-ow) (20:02): *Split database into front-end and back-end*
  - [Account Balances: Part 4](https://www.youtube.com/watch?v=bS-qkU5c8Tk) (22:49): *Recalculate actual balance*
  - [Account Balances: Part 5](https://www.youtube.com/watch?v=GPEBPjaJTDA) (37:34): *Create an \[Add Account\] button*
  - [Account Balances: Part 6](https://www.youtube.com/watch?v=novCnq1Dfvo) (35:42): *Safely delete accounts*
  - [Address Block Format](https://www.youtube.com/watch?v=t5Bh1w0a91w) (15:18): *How to Add Formatting to Your Report Address Block in Microsoft Access*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))

  - [Use a Tab Control](https://www.youtube.com/watch?v=dOlHlPqHmqY) (5:49): *How to Use Tab Control to Streamline Your Interface*
  - [Combo / List Box](https://www.youtube.com/watch?v=irLA3pOyEBw) (8:27): *Combo and List Boxes: Setup and Formatting in Access Databases*
  - [Add Items to a Combo Box](https://www.youtube.com/watch?v=P30w76tchLA) (5:23): *Adding Data to a Combo Box During Execution in Microsoft Access*

---

## New to Me

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

- *Nothing new 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/).

- [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- An Access Developer Guide to creating applications in Blazor
- [August 3, 2023](https://accessusergroups.org/pacific/event/global-error-handlers-with-tom-van-stiphout-and-kim-young/): **Tom van Stiphout** and **Kim Young** \- Global Error Handlers
- [August 17, 2023](https://www.daaug.org/Presentations/Details/251): **Richard Rost** \- Custom Data Entry Filter Functions in Access
- [August 29, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-08-29/): **Lenni Lobel** \- Introduction to Azure Cosmos DB
- ~~September 6, 2023~~: **Thomas Möller** \- Better Access Charts in the new Edge browser control (**SESSION POSTPONED; a different session will be scheduled in its place**)
- [September 7, 2023](https://accessusergroups.org/pacific/event/event-driven-programming-with-john-colby/): **John Colby** \- Event Driven Programming
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access
- [October 19, 2023](https://www.daaug.org/Presentations/Details/252): **Alessandro Grimaldi** \- "VBA Pills" - Access Tips and Tricks
- [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)
- [January 3, 2023](https://accessusergroups.org/europe/event/access-europe-2024-01-03/): **Ramachandran (A.P.R.) Pillai** \- Streamlining the Form Module Code in the standalone Class Module

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-07-22) and this one (2023-07-29).*

*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.

**UPDATE \[2023-07-31\]*: Updated status of Thomas Möller's Better Access Charts session.*