> ## 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 2, 2022 - URL: https://nolongerset.com/week-in-review-2022-07-02/ - Published: 2022-07-03T03:42:20.000Z - Updated: 2026-05-08T12:56:37.000Z - Description: Highlights include a deep dive into the Autoexec macro, compacting the current database via VBA, and a massive Access drawing reference. - 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 Issues Fixed in the May 2022 Monthly Release*](https://techcommunity.microsoft.com/t5/access-blog/access-issues-fixed-in-the-may-2022-monthly-release/ba-p/3535339), by Michael Aldridge - [*Bug – Report Borders Not Showing*](https://www.devhut.net/access-bug-report-borders-not-showing/), by Daniel Pineault - [*Compact the Current Database*](https://www.devhut.net/access-vba-compact-the-current-database/), by Daniel Pineault - [*To Flow, or Not To Flow, That is the Question!*](https://www.devhut.net/to-flow-or-not-to-flow-that-is-the-question/) by Daniel Pineault - [*Distribute Database Via PowerShell*](https://www.devhut.net/distribute-database-via-powershell/), by Daniel Pineault - [*Changes to Access Roadmap*](https://isladogs.co.uk/access-roadmap/index.html), by Colin Riddington - [*Access Issues Fixed*](https://isladogs.co.uk/access-fixes/index.html), by Colin Riddington - [*Debunking Myths about the Autoexec Macro*](https://isladogs.co.uk/autoexec-myths/index.html), by Colin Riddington - [*Listbox Mouse Move Item Tooltips*](https://isladogs.co.uk/listbox-tooltip/index.html), by Colin Riddington - *[Drawing Circles on Access Reports](https://www.linkedin.com/pulse/drawing-circles-access-reports-crystal-strive4peace-?trk=news-guest%5Fshare-article)*, by Crystal Long (strive4peace) #### Discussions - [Single or multiple spaces same as empty string in Access](https://stackoverflow.com/q/72784795/154439) - [Transfer Field to Array in VBA](https://stackoverflow.com/q/72793065/154439) - [Selecting a VB6 DLL reference in one Access file somehow selects it in another](https://stackoverflow.com/q/72723898/154439) - [](https://stackoverflow.com/questions/72759655/transfering-attached-documents-in-access-to-a-word-template)[Transfering attached documents in Access to a Word Template](https://stackoverflow.com/q/72759655/154439) - [](https://stackoverflow.com/questions/72704041/shorthand-to-create-an-array-of-integers-n1-n2)[Shorthand to Create an Array of Integers n1-n2](https://stackoverflow.com/q/72704041/154439) - [](https://stackoverflow.com/questions/72719614/assing-values-directly-to-an-array-in-vba)[Assign Values "directly" to an array in VBA](https://stackoverflow.com/q/72719614/154439) - [Upload files to a DB table using a button on a form](https://www.access-programmers.co.uk/forums/threads/upload-files-to-a-db-table-using-a-button-on-a-form.323816/) #### Videos - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Big Checkbox for Yes/No](https://www.youtube.com/watch?v=bQcJWW1AvB0) (2:19): *Big Checkbox in Access with Conditional Formatting* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Date Criteria](https://www.youtube.com/watch?v=TB1rhTVolaM) (18:00): *Create a Query Showing Records Between Two Dates in Microsoft Access. Properly Using Date Criteria.* \- [Sales Chart](https://www.youtube.com/watch?v=PzKCtyT8djA) (21:58): *Create a Chart Showing Monthly Sales in Microsoft Access using Modern Charts, Forecast in Excel* \- [Access Beginner 2, Level 5](https://www.youtube.com/watch?v=A0fAe%5FG81sc) (20:25): *Trusted Locations, Form Design, Relationships, Combo Boxes* \- [Rounding Errors](https://www.youtube.com/watch?v=NZQ0CD%5FLf3U) (10:49): *How to Fix Rounding Errors in Microsoft Access when Calculating Commissions, Sales Tax, etc.* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/channel/UCOm7X-WFABGXg00dMS5I9dw/featured)) \- [Table Formatting](https://www.youtube.com/watch?v=%5FisVxONHWsg) (9:05): *Format Datasheets Like Excel Spreadsheets* \- [Referential Integrity](https://www.youtube.com/watch?v=yqdNnwQGEMI) (5:44): *How to Enforce Referential Integrity and Why* \- [Table Relationships](https://www.youtube.com/watch?v=gQHJRZMQ-e4) (8:58) --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[UDT's](http://billmccarthy.com/projects/Archived/PlatformVB/udts.html)*, by Bill McCarthy: *Detailed information about creating UDTs in VBx, especially for use with API calls (includes discussion of differences between `Len()` and `LenB()`).* - [*10 Tips for improving body language during virtual meetings*](https://pumble.com/blog/body-language-virtual-meetings/), by Jelena Fisic - [*CreateObject(“Outlook.Application”) Does Not Work, Now What?*](https://www.devhut.net/createobjectoutlook-application-does-not-work-now-what/) by Daniel Pineault - *[Report Draw Reference and VBA Syntax](http://msaccessgurus.com/VBA/ReportDraw%5FReference.htm)*, by Crystal Long (strive4peace): *This page contains a full reference on all the methods available for drawing custom shapes at runtime on Access reports. It also includes several downloadable samples and a video demonstrating several techniques.* --- ## 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-25) and this week (2022-07-02).* 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)