Solved

Cannot view Treeview controls in Access (2010) after upgrading to Autodesk 2015 and VBA 7 (previously Autodesk 2013 with VBA 6)

Posted on 2014-12-28
5
323 Views
Last Modified: 2015-01-18
Hi,

I have an Access database and it consists of few forms. When I try to view a form which has a tree view control in it, I get "There is no object in this control" error.

This machine previously had Autodesk 2013 (VBA 6) installed,  and later upgraded to Autodesk 2015 (VBA 7.1)

It is a Windows 7 (Professional) 32-bit operating system

It is very much appreciated if anyone can help me to fix this issue.

Thank you
0
Comment
Question by:managedsol
5 Comments
 
LVL 10

Expert Comment

by:Jamie Garroch
ID: 40521469
There is no 64 bit version of the MSComCtl in VBA7 and hence the Tree View control is deprecated as per this MSFT article:

http://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx#odc_office2010_Compatibility32bit64bit_ActiveXControlCOMAddinCompatibility
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40521581
although Jamie is correct, you don't indicate whether you are using 32 bit or 64 bit Office.  Since 32 bit Office will run (and is actually recommended by Microsoft) on 64 bit operating systems, I would encourage you to use the 32 bit version of Office if you can.
0
 
LVL 84
ID: 40521734
I would bet that the update modified the files on which that treeview library depends, which renders your app unusable.

Get rid of the treeview, or use something like this: http://www.jkp-ads.com/articles/treeview.asp or use a valid 3rd party control like the Bennet-Tec TList: http://www.bennet-tec.com/btProducts/TList/TList.htm or DBi-Tec's ctTree; http://www.dbi-tech.com/ComponentPage_ctTree.aspx. I've used both of the last two, and they work well in my limited testing.
0
 

Accepted Solution

by:
managedsol earned 0 total points
ID: 40548143
Hi,

Thank you for all your comments. Error occurred due to an incorrect version of  MSCOMCTL.OCX.  Everything worked ok once I replaced that file.

Regards
0
 

Author Closing Comment

by:managedsol
ID: 40556003
It was due to an incorrect ocx file in the system.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dsum Function for List Box Data 7 45
Migrating Macro Menu’s From Access 2003 to Access 2013 2 27
Question about DB Schema 27 52
update all email addresses SQL 1 23
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question