> ## 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: February 25, 2023 - URL: https://nolongerset.com/week-in-review-2023-02-25/ - Published: 2023-02-25T23:19:39.000Z - Updated: 2026-05-08T12:51:27.000Z - Description: Highlights include a modern date-time picker proof of concept, using SQL Server views from Access, and writing code other people can read. - 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 - **[Access Forever](https://www.accessforever.org/)** - [Video: The Current State of Access](https://www.accessforever.org/post/video-the-current-state-of-access), *by Karl Donaubauer* - **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)) - [Draw the Moon in Access](https://www.linkedin.com/pulse/draw-moon-access-crystal-strive4peace-/) - **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*) - [VBA – Find Disk Drive By Name](https://www.devhut.net/vba-find-disk-drive-by-name/) - [A More Modern Date Time Picker](https://www.devhut.net/a-more-modern-date-time-picker/) - [VBA – Debug.Print – spc, tab, semi-colon, comma and more](https://www.devhut.net/vba-debug-print-spc-tab-semi-colon-comma-and-more/) - [VBA – Retrieve Windows SID And Username](https://www.devhut.net/vba-retrieve-windows-sid-and-username/) - [Access – Reset AutoNumber Counter/Seed](https://www.devhut.net/access-reset-autonumber-counter-seed/) - [WMI Errors Using Count, ItemIndex, …](https://www.devhut.net/wmi-errors-using-count-itemindex/) - **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*) - [Click Me And I Disappear](https://isladogs.co.uk/hide-control-with-focus/index.html) - [The Strange Dotted Square 'Bug'](https://isladogs.co.uk/dotted-square-bug/index.html) - [Maximum Width of Access Forms & Reports](https://isladogs.co.uk/form-width-limit/index.html) *UPDATED* - [Access Specifications Issues](https://isladogs.co.uk/access-specification-issues/index.html) *UPDATED* - **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*) - [Returning Multiple Values from a Function in VBA Using a UDT](https://nolongerset.com/return-multiple-values-udt/) - [Using ByRef to Return Multiple Values from a Sub (or Function)](https://nolongerset.com/return-multiple-values-byref/) - [Creating Form Skeletons with VBA](https://nolongerset.com/designnewform/) - [Detect if an Access Report is in Preview Mode, Report Mode, or Being Sent to the Printer](https://nolongerset.com/detect-report-mode/) - [5 Ways to Build Consistent Form User Interfaces in Microsoft Access](https://nolongerset.com/consistent-form-ui/) #### Videos‌ - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) - [SQL Server with Access Academy - Part IV](https://www.youtube.com/watch?v=VK7H1nWQP5Y) (1:15:56): *Create, link and make views to edit data with Juan Soto* - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) - [Draw Moon](https://www.youtube.com/watch?v=Ifufxq50AhI) (0:30): *Draw the Moon on Access Reports using VBA* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [Lock Specific Field](https://www.youtube.com/watch?v=0HdV4md1YLU) (11:28): *How to Lock a Specific Field Once a Value Has Been Entered in Microsoft Access* - [Association Database, Part 9](https://www.youtube.com/watch?v=YP8i6sFWquI) (25:55): *Major Revision - Replacing Family with Groups* - [Filenames with Weird Characters](https://www.youtube.com/watch?v=Vi8%5F4QUNFNM) (16:28): *Problems Working With Filenames That Have Non-Standard ASCII Characters in Microsoft Access VBA* - [List Box Column Align Right](https://www.youtube.com/watch?v=G-TU9q6y1jc) (20:40): *How to Get a List Box Column to Align Right in Microsoft Access (Text Alignment)* - [Multiple Yes/No](https://www.youtube.com/watch?v=FPSc06hoh6w) (19:08): *How to Replace Multiple Yes/No Fields With Properly Relational Solution in Microsoft Access* - **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ)) - [Modern Date Time Pickers](https://www.youtube.com/watch?v=b2EM8KIsVFw) (6:36) - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew)) - [The 60-Year History of Agile Development](https://www.youtube.com/watch?v=sA5nufn93a8) (11:35): *Agile Development Methods Continue to Evolve* - [Remove Duplicate Records](https://www.youtube.com/watch?v=wsYbqLwaOEk) (11:42): *How to Create Duplicate Queries and Easily Remove Duplicate Records* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*Coding 102: Writing code other people can read*](https://www.notion.so/Coding-102-Writing-code-other-people-can-read-0f71c3737a444f70a343e62d2ad0cde7?pvs=4), by [Max Pekarsky](https://stackoverflow.blog/author/maxpekarsky/) --- ## 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/). - [February 28, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-02-28/): **Crystal Long** \- Loop and Link CSV Files **(JUST ADDED)** - [March 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-03-01/): **Maria Barnes** \- Optimizing Queries in SQL Server - [March 2, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Pat Hartman** \- Bad Data is Bad for Business - [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- Creating calendar format reports **(TOPIC JUST ADDED)** - [April 6, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Tom Wickerath and George Hepworth** \- Migrating Access Tables to SQL Server, a Comparison of Methods - [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 - [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 -** (topic details to follow) - [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- (topic details to follow) - [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-02-18) and this one (2023-02-25). 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 - `MAR 2023`: New Modern Web Browser Form Control #### Rolling Out None. #### Launched None.