> ## 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: June 18, 2022 - URL: https://nolongerset.com/week-in-review-2022-06-18/ - Published: 2022-06-19T02:22:51.000Z - Updated: 2026-05-08T12:56:57.000Z - Description: Highlights include building custom progress bars, creating organizational charts, and yet another Access bug [sigh]. - 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 - [*Build 15225.20288 Causing Attachment Problems!*](https://www.devhut.net/access-build-15225-20288-causing-attachment-problems/) by Daniel Pineault - [*Organizational Charts*](https://www.devhut.net/access-organizational-charts/)*,* by Daniel Pineault - [*Happy 4th Birthday ‘Inconsistent State’ Bug*](https://www.devhut.net/access-happy-4th-birthday-inconsistent-state-bug/)*,* by Daniel Pineault - *[Progress Bar](https://isladogs.co.uk/progress-bar/index.html)*, by Colin Riddington #### Discussions - [Updating Two different tables through one form](https://www.access-programmers.co.uk/forums/threads/updating-two-different-tables-through-one-form.323603/) - [Database Structure](https://www.access-programmers.co.uk/forums/threads/database-structure.323675/) - [Run-time error 5 - Invalid procedure call or argument](https://www.access-programmers.co.uk/forums/threads/run-time-error-5-invalid-procedure-call-or-argument.323680/): *Includes some good [notes from The\_Doc\_Man](https://www.access-programmers.co.uk/forums/threads/run-time-error-5-invalid-procedure-call-or-argument.323680/page-2#post-1831838) on writing code while active form timers are running (tl;dr: don't do it)* #### Videos - **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA)) \- [Building a Progress Bar in Access](https://www.youtube.com/watch?v=F4Vjw8kPzIk) (13:51) - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Top Values per Group](https://www.youtube.com/watch?v=xaPpGcGR6QI) (5:27): *Get Top Values per Group using a Subquery in Access \~ DataPig* \- [Top Values: Number or %](https://www.youtube.com/watch?v=JDewLt7UySg) (2:03): *Using TOP Values in an Access Query \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Value List Combo Boxes](https://www.youtube.com/watch?v=L3B-ji4GSf4) (16:50): *How to Create a Value List Combo Box Microsoft Access* \- [Fast Tips: WeekDay](https://www.youtube.com/watch?v=aW55f6kyVfY) (8:46): *How to Display the Day of the Week that a Particular Date Falls On in Microsoft Access (Weekday)* \- [Find Record](https://www.youtube.com/watch?v=qQYOwYHU5jw) (22:15): *Microsoft Access Search: Find a Record on My Form Based on the Value I Selected in my Combo Box* \- [Access Amort 2.0](https://www.youtube.com/watch?v=hgljeispsm4) (12:29): *Microsoft Access Loan Amortization Template 2.0 - Introduction for New Users. Welcome!* \- [Access Amort 2.0 Upgrade](https://www.youtube.com/watch?v=xRSzVBD0pEU) (25:00): *Microsoft Access Loan Amortization Template 2.0 - Upgrade Video for Current Users* \- [Access Beginner 2, Level 3](https://www.youtube.com/watch?v=3QoJyEaUfBY) (12:52): *Form Formatting, The Grid, Properties, Themes* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/channel/UCOm7X-WFABGXg00dMS5I9dw/featured)) \- [Number Formatting](https://www.youtube.com/watch?v=HBI5ZOCgyuA) (7:28): *Microsoft Access Number Formatting* *NOTE: The new videos posted to Crystal's YouTube page are part of an [effort to preserve the Access content of retiring creators](https://www.access-programmers.co.uk/forums/threads/status-of-databaseanswers-org.322983/).* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [VBA-Web](https://github.com/VBA-tools/VBA-Web): A Github repo maintained by Tim Hall that, "makes working with complex webservices and APIs easy with VBA" - [Excel is like a pickup truck, Access is like a freight train](https://qr.ae/pvHihB): Clever analogy in this Quora answer from Jim Christmas --- ## 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/). - [July 6, 2022](https://accessusergroups.org/europe/event/access-europe-2022-07-06/): **Mike Wolfe** \- Building Ribbon Interfaces in Code - [July 21, 2022](https://www.daaug.org/Presentations/Details/239): Richard Rost - Custom List Box Columns - [August 3, 2022](https://accessusergroups.org/europe/event/access-europe-2022-08-03/): **Peter Cole** \- Automating 32-bit to 64-bit VBA Conversion - [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 - [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-06-11) and this week (2022-06-18).* 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)*. - Inconsistent Database Error Fix - New (Modern) Web Browser Control (to support Chromium Edge) - Enabling Large Address Aware (LAA) for 32-Bit Access - SQL Monaco Editor - 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)