MS Access 2016 Treeview error: "No object in this control element. Runtime error 438"

Asked 21/8, 2017 at 18:25 Answered 22/3, 2018 at 5:47

vba ms-access vb6 treeview ms-access-2016

I have a problem to open the treeview in MS Access. I think it's since the last windows update.

I'm getting an error message when I start the program:

"There is no object in this control element. Runtime error 438: Object does not support this property or method."

The debugger marks one line yellow in the vba code: CreateTree TreeView0.Nodes.

I didn't change anything since the last time. There it has still worked. I did the following steps, but they all didn't help:

reinstalled MS Access
repaired MS Access
exchanged the C:\Windows\SysWOW64\MSCOMCTL.ocx, unregistered and registered it
updated VB6 to the latest version
added the database again

I hope that someone can help me!

Burse answered 21/8, 2017 at 18:25 Comment(2)

Is MS-Access 32 or 64 bits? – Guidon 21/8, 2017 at 20:14

This is because you have 64bit version of MS Office installed. Install 32bit version and you'll see TreeView and others again. – Pic 22/3, 2018 at 5:47

This is a known new bug in mscomctl.ocx in many localisations - if not all, including English.

From one of the reportings:

Now they are experiencing the problem also with MSI installations of Office 2016 which have been updated by the Windows update of Aug 1. On these systems mscomctl.oxc seems to not have been updated as it still showed version 6.1.98.46.

They had to disinstall the update of Aug 1 (KB4011051 -> no mention there of this issue) to get rid of the problem.

There is at this moment no info from MS when and how it will be corrected.

Pachysandra answered 21/8, 2017 at 20:15 Comment(3)

Could you link to the reporting that you pulled it from? I'd like to read it, myself. – Tantivy 7/9, 2017 at 18:43

Sorry, it is a snippet from an MVP closed group posting. – Pachysandra 7/9, 2017 at 20:33

did not help. There is no KB4011051 on my computer. – Pic 22/3, 2018 at 3:41

This may be a better long term solution for you. https://www.access-treeview.com/ Wish you the best

Sverige answered 21/8, 2017 at 21:29 Comment(1)

please avoid link-only answers because in future, the link could be broken – Khichabia 21/8, 2017 at 21:41

Another alternative TreeView control is here: http://www.vbforums.com/showthread.php?698563-CommonControls-(Replacement-of-the-MS-common-controls)

Birkle answered 22/8, 2017 at 11:13 Comment(0)

This is because you have 64bit version of MS Office installed. Install 32bit version and you'll see TreeView and others again.

Pic answered 22/3, 2018 at 5:47 Comment(0)

Recommended topics

Hot tags