> ## 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 9, 2022 - URL: https://nolongerset.com/week-in-review-2022-07-09/ - Published: 2022-07-10T01:05:39.000Z - Updated: 2026-05-08T12:56:27.000Z - Description: Highlights include code to activate a specific ribbon tab, a deep dive into the innards (and dangers) of multivalue fields, and--yes--more Access bugs. - 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 Bug – .Fields Not Working Anymore*](https://www.devhut.net/access-bug-fields-not-working-anymore/), by Daniel Pineault - [*Purpose of the ‘Fixes or workarounds’ Page*](https://www.devhut.net/access-purpose-of-the-fixes-or-workarounds-page/), by Daniel Pineault - [*Access Bug – DoCmd.OutputTo acFormatXLSX Doesn’t Work*](https://www.devhut.net/access-bug-docmd-outputto-acformatxlsx-doesnt-work/), by Daniel Pineault - [*Access Bug – The Case of the Disappearing Status Bar*](https://www.devhut.net/access-bug-the-case-of-the-disappearing-status-bar/), by Daniel Pineault - [*VBA – Activate a Specific Ribbon Tab*](https://www.devhut.net/vba-activate-a-specific-ribbon-tab/), by Daniel Pineault - [*Access – VBA – Set Focus On Specific Document Tab*](https://www.devhut.net/access-vba-set-focus-on-specific-document-tab/), by Daniel Pineault - [*Access – Devastation*](https://www.devhut.net/access-devastation/), by Daniel Pineault - [*Multivalued Fields...& why you shouldn't use them*](https://isladogs.co.uk/multivalued-fields/index.html), by Colin Riddington - *[Synchronise Subform Scrolling](https://isladogs.co.uk/subform-sync-scroll/index.html) (UPDATED)*, by Colin Riddington - *[Folder Image Viewer](https://isladogs.co.uk/folder-image-viewer/index.html) (UPDATED)*, by Colin Riddington #### Discussions - [Wait...what? Using ByVal in parameter of a function CALL?](https://github.com/WaynePhillipsEA/twinbasic/discussions/965) - [Fill PDF form in VBA code from XML file or XFDF file](https://stackoverflow.com/q/72831871/154439) - [Access with breaking changes on Version 2206 (Recordset2.Fields returns DAO.Field3 instead of DAO.Field2) - Error 13](https://stackoverflow.com/q/72831316/154439) - [How MS Access 64 bit import or link from Visual FoxPro database?](https://stackoverflow.com/q/72836309/154439) - [Why do 1/0 and Sqr (-1) throw error in MSOffice VBA, but not in VB.NET?](https://stackoverflow.com/q/72784750/154439) #### Videos - **Crystal Long** ([YouTube channel](https://www.youtube.com/c/LearnAccessByCrystal)) \- [Dependent Combobox](https://www.youtube.com/watch?v=JjTi8dXCdxw) (4:19): *Combobox in Access where values are Dependent on another Combobox (cascading) \~ DataPig* \- [Combobox](https://www.youtube.com/watch?v=d5-jBLi0Kf4) (2:53): *Setting up Combobox on an Access Form in Design View \~ DataPig* \- [Calendar Control](https://www.youtube.com/watch?v=RuRfYmJzB0g) (6:12): *Setting up the Access ActiveX Calendar Control \~ DataPig* \- [Align Control](https://www.youtube.com/watch?v=apDByP2lGDM) (3:41): *Aligning and Sizing Controls on Access Forms \~ DataPig* \- [Slider Control](https://www.youtube.com/watch?v=8TXr-O2pQHE) (7:37): *Step by step set up and usage of the ActiveX Slider Control for Access \~ DataPig* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Triple State](https://www.youtube.com/watch?v=VN2W3unRzvo) (10:49): *Using Triple State Check Boxes in Microsoft Access* \- [Gray Out Fields](https://www.youtube.com/watch?v=bdHYlFgLL9k) (10:50): *How to Gray Out Fields Based on A Selected Value in Microsoft Access Forms* \- [Beginner 2, Lesson 7](https://www.youtube.com/watch?v=DONhg6smwD8) (5:21): *Coming Up Next in Beginner Level 3...* \- [Beginner 2, Lesson 6](https://www.youtube.com/watch?v=tZS3zuFpEi4) (25:12): *Questions From Students, Custom Ribbon, Access on Mac, More* \- [Product Catalog](https://www.youtube.com/watch?v=JeUT5CMPyzc) (30:34): *Creating a Product Catalog Report in Microsoft Access with Multiple Images (Pictures) Per Record* \- [Developer 38](https://www.youtube.com/watch?v=niQj7MGJhAA) (5:36): *VBA for Multivalued Fields, Images in Form Columns. Image Gallery.* - **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/channel/UCOm7X-WFABGXg00dMS5I9dw/featured)) \- [Updateable Queries](https://www.youtube.com/watch?v=QtiqfIDL56o) (5:18): *Using Updateable Queries, Know the Rules* \- [Splitting the Database](https://www.youtube.com/watch?v=r36m5V3DmLw) (6:05): *Improve Multi-user Performance by Creating a Front and Back End* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [Understand star schema and the importance for Power BI](https://docs.microsoft.com/en-us/power-bi/guidance/star-schema) --- ## 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 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-07-02) and this week (2022-07-09).* 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)