> ## 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: October 29, 2022
- URL: https://nolongerset.com/week-in-review-2022-10-29/
- Published: 2022-10-29T19:45:18.000Z
- Updated: 2026-05-08T12:53:51.000Z
- Description: Highlights include a data macros how-to, time zone-aware dates, automating the Access nav pane, and collapsing/expanding the ribbon.
- 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

- *[How I bombed at my last presentation – yes, it happens to all of us](https://accessexperts.com/blog/2022/10/26/how-i-bombed-at-my-last-presentation-yes-it-happens-to-all-of-us/)*, by Juan Soto
- [*Date and Time in Multiple Time Zones*](https://codekabinett.com/rdumps.php?Lang=2&targetDoc=time-zone-vba), by Philipp Stiefel
- *[SQL for Query to list Query Expressions in Access database](https://msaccessgurus.com/VBA/SQL%5FQueryExpressions.htm)*, by Crystal Long
- [*Bring a Window/Application to the Front*](https://www.devhut.net/vba-bring-a-window-application-to-the-front/), by Daniel Pineault
- [*Get UTC DateTime Information*](https://www.devhut.net/vba-get-utc-datetime-information/), by Daniel Pineault \[NOTE: this article includes step-by-step instructions to execute arbitrary **JavaScript code from within VBA**!!!\]
- [*Determine the Current Ribbon State and Change It*](https://www.devhut.net/vba-determine-the-current-ribbon-state-and-change-it/), by Daniel Pineault
- [*UIAutomation – Minimize and Maximize the Office Ribbon*](https://www.devhut.net/vba-uiautomation-minimize-and-maximize-the-office-ribbon/), by Daniel Pineault
- [*UIAutomation – Is The MS Office Ribbon Expanded or Collapse?*](https://www.devhut.net/vba-uiautomation-is-the-ms-office-ribbon-expanded-or-collapse/), by Daniel Pineault
- [*Microsoft Access Navigation Pane Automation Via UIAutomation*](https://www.devhut.net/vba-microsoft-access-navigation-pane-automation-via-uiautomation/), by Daniel Pineault
- [*Microsoft Access Navigation Pane Automation Via UIAutomation Cont’d*](https://www.devhut.net/vba-microsoft-access-navigation-pane-automation-via-uiautomation-contd/), by Daniel Pineault
- [*View Access Help*](https://isladogs.co.uk/access-help/index.html), by Colin Riddington
- *UPDATED: [Access Error Codes](https://isladogs.co.uk/access-error-codes/index.html)*, by Colin Riddington
- [*Is Form Open as a Subform?*](https://isladogs.co.uk/is-subform/index.html) by Colin Riddington
- [*Is Form Loaded?*](https://isladogs.co.uk/is-form-loaded/index.html) by Colin Riddington
- [*Combo Box Auto Dropdown*](https://isladogs.co.uk/combobox-dropdown/index.html), by Colin Riddington
- *UPDATED: [Complex Deep Hidden Attachment Mystery](https://isladogs.co.uk/complex-deephide-mystery/index.html)*, by Colin Riddington
- *UPDATED: [Formatted Message Box](https://isladogs.co.uk/formatted-message-box/index.html)*, by Colin Riddington
- *UPDATED:* [*Access Add-Ins*](https://isladogs.co.uk/add-ins/index.html), by Colin Riddington
- *UPDATED: [School Data Analyser](https://isladogs.co.uk/school-data-analyser/index.html)*, by Colin Riddington
- [*Happy Birthday. Access Is 30!*](https://isladogs.co.uk/access-30/index.html), by Colin Riddington
- *[What is a Data Fabric](https://www.linkedin.com/pulse/what-data-fabric-maria-barnes/)*, by Maria Barnes
- [*Follow-Up: Avoiding Context Switching*](https://nolongerset.com/follow-up-avoiding-context-switching/), by Mike Wolfe
- *[WizHook: A Hidden Access Object With Intriguing Potential](https://nolongerset.com/wizhook/)*, by Mike Wolfe
- *[Wiz(): Never Forget to Set the WizHook Magic Key](https://nolongerset.com/wiz-wizhook-helper/)*, by Mike Wolfe
- *[WizMsg(): A Simple Way to Create a MsgBox with Bold Text](https://nolongerset.com/wizmsg/)*, by Mike Wolfe
- *[Prepare for the Upcoming Death of IE11](https://nolongerset.com/death-of-ie11/)*, by Mike Wolfe

#### Videos‌

- **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA))  
  - [Attachment Mystery](https://www.youtube.com/watch?v=eUuK6s6oNY0) (19:54): *A Deep Hidden And Complex Access Attachment Mystery*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))  
  - [Data Macro](https://www.youtube.com/watch?v=g2-w47iV1g4) (9:30): *Update a Table Field Whenever the Record is Changed using a Data Macro in Microsoft Access*
  - [And Or Not](https://www.youtube.com/watch?v=4JpgI1-itWU) (9:11): *Proper Microsoft Access Query Criteria Logic with And, Or, & Not*
  - [Fill in PDF](https://www.youtube.com/watch?v=5e8nlRnJrTw) (33:06): *How to Fill in PDF Forms with Data from Microsoft Access. Populate PDF Form with Access Data.*
  - [SendKeys](https://www.youtube.com/watch?v=qc-7uYr7kHE) (18:26): *Using the SendKeys Function in Microsoft Access; the King of "Good Enough Sometimes" Functions.*
  - [Follow Hyperlink](https://www.youtube.com/watch?v=jbMCtmsW1R0) (23:31): *Open Websites, Documents, Folders, Email, More Using FollowHyperlink Command in Microsoft Access VBA*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))  
  - [Ribbon Expand/Collapse](https://www.youtube.com/watch?v=wmzJB48FPIc) (13:47): *Expanding and Collapsing The Microsoft Office Ribbon Using UIAutomation*
  - [String Padding](https://www.youtube.com/watch?v=s-97bvD1g5U) (13:50): *Padding a String To A Desired Length*
  - [Nav Pane Automation](https://www.youtube.com/watch?v=X6LDn1vT7lk) (15:23): *Microsoft Access - Navigation Pane Automation Via UIAutomation*
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube MS Access playlist](https://www.youtube.com/playlist?list=PLXgmUCUuTC8vSstRHOTTJ1690Da--vKew))  
  - [Import/Export From/To Excel](https://www.youtube.com/watch?v=F%5FUP0Svqh6Y) (10:41): *Real-Life Examples of Access Imports from and Exports to Excel*

---

## 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/).

- [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers
- [November 3, 2022](https://accessusergroups.org/pacific/event/257-2022-11-03/): **Ned Pajic** \- Hosting Access Applications "in the cloud"
- [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Colin Riddington** \- Annotating Google Maps in Access
- [December 13, 2022](https://accessusergroups.org/sql-server-with-access/event/sql-server-with-access-2022-12-13/): **Juan Soto** \- Access with SQL Server Academy Part II (**JUST ADDED**) - *([review Part I here](https://www.youtube.com/watch?v=y5zTb1GL2x0))*
- [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server
- [January 31, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-01-31/): **Colin Riddington** \- Translate & Speak Using Access
- [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts
- [March 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-03-01/): **Maria Barnes** \- Optimizing Queries in SQL Server
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access

---

‌

## Access Roadmap

*There were two changes to the roadmap between last week (2022-10-22) and this week (2022-10-29). ODBC and DAO Interface Support–launched nearly *two years ago* in January 2021–finally came off of the Access Roadmap. This leaves the only other new "feature" launched in nearly two years the Access Dataverse Connector.*

### Launched:

- ~~`JAN 2021`: Access: ODBC Interface Support (without ACE Redistributable Engine)~~
- ~~`JAN 2021`: Access: DAO Interface Support (without ACE Redistributable Engine)~~

*The development priorities 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

None.

#### Rolling Out

None.

#### Launched

- `MAY 2022`: Access Dataverse Connector