> ## 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: April 15, 2023 - URL: https://nolongerset.com/week-in-review-2023-04-15/ - Published: 2023-04-15T21:59:40.000Z - Updated: 2026-05-08T12:50:29.000Z - Description: Highlights include drawing stoplights and dials on reports, a SQL-to-VBA-to-SQL utility, creating calendar reports, and migrating Access tables to SQL Server. - 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/)) - [Reusing Form Module VBA Code for New Projects](https://www.msaccesstips.com/2023/04/reusing-form-module-vba-code-for-new.html) - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [VBA – Open Image With Windows Photo Viewer](https://www.devhut.net/vba-open-image-with-windows-photo-viewer/) - [VBA – WIA – Check If A File Is In An Acceptable Format](https://www.devhut.net/vba-wia-check-if-a-file-is-in-an-acceptable-format/) - [Access – This database is attempting to establish a connection with a remote SQL server](https://www.devhut.net/access-this-database-is-attempting-to-establish-a-connection-with-a-remote-sql-server/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [SQL to VBA & Back Again](https://isladogs.co.uk/sql-to-vba-back-again/index.html) - **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*) - [Draw Dial in Access](https://msaccessgurus.com/VBA/Draw%5FDial.htm) - [Draw a Stoplight in Access](https://msaccessgurus.com/VBA/Draw%5FStoplight.htm) - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [B-BEAR: Quick and Dirty SQL Server Testing](https://nolongerset.com/quick-and-dirty-sql-server-testing/) - [Setting Column-Specific Colors in Microsoft Access List Boxes and Combo Boxes](https://nolongerset.com/column-colors/) - [Efficient Querying: Finding Maximum Values for Each Distinct Value in a Column](https://nolongerset.com/max-values-for-another-column/) - [Installing Multiple Versions of SQL Server Side-by-Side on a Development Machine](https://nolongerset.com/side-by-side-sql-server/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [Creating Calendar Format Reports](https://www.youtube.com/watch?v=M6vsACrw%5FdI) (46:39): *by Duane Hookom* - [Migrating Access Tables to SQL Server, Comparison of Methods](https://www.youtube.com/watch?v=ROT1ogVm8a8) (1:42:18): *by Tom Wickerath and George Hepworth* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Quick Queries #9](https://www.youtube.com/watch?v=h0otzsVqfNs) (55:14): *General Read Error, Price Changes, ChatGPT Stuff, ACCDR, More!* - [Double-Entry Accounting](https://www.youtube.com/watch?v=7N7Z0boSXXM) (19:23): *Double-Entry Accounting in Microsoft Access* - [Next Business Day](https://www.youtube.com/watch?v=QrKRv1SEGUs) (18:01): *How to Find the Next or Previous Business Day in Microsoft Access* - [Tech Help + Fast Tips](https://www.youtube.com/watch?v=gJGDAlVjz%5Fc) (2:12): *TechHelp and Fast Tips are Merging Into One Series!* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [Random Sample Dataset](https://www.youtube.com/shorts/eFT1ze6gNrw) (Short): *How to Create a Random Sample Dataset in Microsoft Access* - [Synchronize Combo Boxes](https://www.youtube.com/watch?v=aZOUVZG38k4) (7:35): *Streamline User Selection with Synchronized Combo Boxes in Microsoft Access* - [Frequency Distributions](https://www.youtube.com/shorts/wZbwBWJBYxU) (Short): *Create Frequency Distributions in Microsoft Access with the Partition Function* - [Database Templates](https://www.youtube.com/watch?v=u-SGM3XTQxo) (5:48): *Discover Time-Saving Templates in Microsoft Access for Your Applications* --- ## 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/). - [April 20, 2023](https://www.daaug.org/Presentations/Details/250): **Tom van Stiphout** \- Northwind 2.0 Is Here! - [April 25, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-04-25/): **Maria Barnes** \- What's New with Access? - [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna** - [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server - [May 4, 2023](https://accessusergroups.org/pacific/event/standardizing-form-and-list-filtering-using-vba-classes-with-eric-blomquist/): **Eric Blomquist** \- Standardizing Form and List Filtering using VBA Classes **(JUST ADDED)** - [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access - [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow) - [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp - [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access - [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) --- ‌ ## Access Roadmap *There were *NO CHANGES* to the roadmap between the last Week in Review (2023-04-08) and this one (2023-04-15).* *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.