Ms Access Treeview Control Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company
There Was An Error Loading An Activex Control On One Of Your Forms Or Reports
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ms12-060 Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MS Access Treeview error loading ActiveX control [duplicate] up vote 0 down vote favorite Possible Duplicate: MS-access doesn't catch treeview events after win sec-update recently an error appeared with a Treeview element in my access form. The expression Expand you entered as the event property setting produced the following error: There was an error laoding an ActiveX control on one of your forms or reports. When I click "OK" (only opportunity) the next error appears (Expand is replaced by MouseMove, MouseDown/Up, DblClick etc.), when I press Keys the KeyDown/Up/Press Message appears etc. When I interact with the TreeView then the "Expand" is replaced by e.g. NodeClick or Collapse. Every message only appears once, when I performed every possible Event no message pops up - but the treeview doesnt work, it doesnt open any form (the treeview is used as a menu). The mysterious thing to me is - last week those Access Databases all worked fine - we have a database for every customer (frontend and data together) and now suddenly every database 'crashes'. I assumed that the ActiveX Treeview Control was changed by a Windows Update or something similar but also an old WinXP laptop throws the same error messages. Even a database that hasnt been opened for 2 weeks and definitely worked back then doesnt work anymore. So from my point of view there cant be anything in the code that is wrong. Nevertheless I tried to set a breakpoint in the Form_Load event, but the Expand Error already pops up before the first line of OnLoad is executed. The OnLoad Event is the only event that is specified (GUI says "Event Procedure", its VBA Code only) and all other fields are blank (and no code specified). I created a blank VBA for e.g. MouseMove, but the error still appears. What is this error and where does it come from? Hope anyone can help. Regard
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Error in treeview control (VBA Access) Microsoft Office for Developers > Access for Developers Question 0 Sign in to vote Everytime my http://stackoverflow.com/questions/12037965/ms-access-treeview-error-loading-activex-control mouse goes near a treeview control on an Access form, I get the following error: "There was an error loading an ActiveX control on one of your forms or reports" I perused the literature, which indicated that the link below contained a fix. I downloaded the "fix" but, alas, the problem persists! http://support.microsoft.com/kb/2687441 Hugely grateful for any help! DragonForest Thursday, October 18, 2012 8:22 AM https://social.msdn.microsoft.com/Forums/office/en-US/b4700d45-1fcf-484e-8000-bba78b05ca03/error-in-treeview-control-vba-access?forum=accessdev Reply | Quote All replies 0 Sign in to vote Did you delete the specified Registry key and then re-register the ocx, or did you create the specified bat file and run it as an administrator on the PC in question? Have you recompiled the database?Daniel Pineault, 2010 Microsoft MVP http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net Thursday, October 18, 2012 10:38 AM Reply | Quote 1 Sign in to vote I've experienced the same a while ago and fixed it by doing as following: 1. Double click the TreeView ActiveX Control to display it's setting. 2. Simply change any settings, click apply. Then change back, and click apply and done. I guess is like resetting everything again. No idea why but worked for me. Also will be good to decompile the db. Hope that helps!The computing scientist's main challenge is not to get confused by the complexities of his own making. Thursday, October 18, 2012 1:16 PM Reply | Quote 0 Sign in to vote Many thanks. Unfortunately, that didn't work for me. Any other ideas?DragonForest Friday, October 19, 2012 1:05 AM Reply | Quote 0 Sign in to vote Thi
Visual SourceBook Total Access Speller Total Access Startup Total Access Statistics Multi-Product Suites >> Overview of Suites Total Access Ultimate Suite http://www.fmsinc.com/microsoftaccess/controls/mscomctl/ Total Access Developer Suite Total Visual Developer Suite Visual Basic 6 http://www.utteraccess.com/forum/Treeview-Control-Stopped-t1992047.html >> Total Visual Agent Total Visual CodeTools Total Visual SourceBook Total VB Statistics Multi-Product Suites >> Overview of Suites Total Visual Developer Suite Total Visual Enterprise Suite Sentinel Visualizer Total ZipCode Database Catalog and Fliers Product Awards Product Reviews Product User Matrix Pre-Sale FAQs ms access Version Compatibility Chart Language Support User Manuals Order News Announcements Current Newsletter Upcoming Events Product Reviews Media Videos Free Resources Overview Product Demos Microsoft Access Developer Help Center Microsoft Access Query Help Center Microsoft Access to SQL Server Upsizing Microsoft Outlook Tips Technical Whitepapers Tips and Techniques Technical Videos Consulting Overview Success Stories Technical ms access treeview Expertise Microsoft Access About About Us Contact Us Why Choose FMS? Awards Quality Pledge Total Access Components Microsoft Access 2000-2016 Version is Shipping! Supports 32 and 64-bit versions of Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, and 2000! Also available for Access 97/95 All Our Microsoft Access Products Components Info: PDF Fact Sheet (0.5 MB) Tour of the Controls Easy Redistribution Developer Questions FAQs User Manual Best Access Add-In Rave Reviews Why Components? "Add some zing to your apps!" Diane Winger, Access Advisor Review Convince your Boss Additional Info: Check for Updates License Terms Fixing the Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update New Security Update for Microsoft Office On August 14, 2012, Microsoft released a security update that included an update to the Windows Common Control MSCOMCTL.OCX: File name File version File size Date Time Mscomctl.ocx 6.01.9834 1,070,152 07-Jun-2012 03:59 Notice the control's date is from June but it was in the August security update. Microsoft K
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Treeview Control Stopped Working After Updated Pc, Access 2007 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options adaytayView Member Profile Aug 15 2012, 10:20 AM Post#1UtterAccess VIPPosts: 3,707Joined: 7-October 03From: Yorkshire, England.This is not a question, but a work-around incase you have this problem.He