Access 2010 Runtime Error 438
Contents |
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Access 2010 - runtime error 438 access vba Run time Error '438' Microsoft Office > Office 2010 -
Runtime Error 438 Excel 2010
IT Pro General Discussions Question 0 Sign in to vote When I click on the Reports runtime error 438 object doesn't support this property or method sub-menu in our RecruitmentHR.mdb from the Switchboard menu, I get the following error message: Run-time error '438' Object doesn't support this property or method I performed
Runtime Error 438 Visual Basic
all of my Microsoft updates, but, still get the same error message. Can anyone help? Jigsy50 Brian Roberts Thursday, January 05, 2012 7:59 PM Reply | Quote Answers 0 Sign in to vote This can be "everything". You need someone to debug your application. In the easiest case it's just an invalid runtime error 438 excel 2013 reference in Tools|References (Alt-F11). Run Debug|Compile to see if there's an invalid command. Marked as answer by Rex ZhangModerator Wednesday, January 11, 2012 7:11 AM Friday, January 06, 2012 3:51 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? Privacy statement © 2016 Microsoft. All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback TechNet Products IT Resources Downloads Training Support Products Windows Windows Server System Center Browser Office Office 365 Exchange Server SQL Server SharePoint Products Skype for Business See all products » Resources Evaluation Center Learning Resources Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscription
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All
Excel Runtime Error 438 Fix
Thanked Posts Go to Page... Thread Tools Rating: Display Modes 12-18-2012,
Run Time Error 438 Access
07:09 AM #1 barbados2010 Newly Registered User Join Date: Sep 2012 Posts: 16 Thanks: 0 Thanked 0 run time error 438 excel macro Times in 0 Posts Run-Time error 438- Object doesn't support this property or method Long story short, my DB was working fine until I exported a new form from another DB (same https://social.technet.microsoft.com/Forums/office/en-US/1230d020-f122-4882-afd3-4417d17a24ee/access-2010-run-time-error-438?forum=officeitproprevious DB, just another file) into my current DB and replaced it. Now when I click a record to open it I receive the error "Object doesn't support this property or method" how can i fix this?? the vba opens and this code seems to be a problem: Code: Form_Load_Error: Call ErrorLog(Err.Name, Err.Number, Me.Name, Erl, "Form_Load")
doesn't support this property or method If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can http://www.vbforums.com/showthread.php?460591-RESOLVED-Runtime-error-438-Object-doesn-t-support-this-property-or-method post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: [RESOLVED] Runtime http://www.pcreview.co.uk/threads/run-time-error-438-problem.1148924/ error 438 Object doesn't support this property or method Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Mar 30th, error 438 2007,04:42 AM #1 marktheman View Profile View Forum Posts Thread Starter Lively Member Join Date Feb 2007 Location Dublin, Ireland Posts 120 [RESOLVED] Runtime error 438 Object doesn't support this property or method Hi, I'm doing a simple excel project and part of it is updating fields in a table. Say the recordset has 500 entries. For some entries, when I update I have no issue time error 438 but when I update older entries from an access database, I get the following error. "Runtime error 438 Object doesn't support this property or method". I'm using ADO connectivity and excel as a database Example: Code: rs.Open "SELECT * FROM [tblfissection$] Where RequestNo = " & requestNoSubstringed, conn, adOpenStatic, adLockOptimistic, adCmdText On Error GoTo updateFISTable 'rs.Fields(1) = "" 'rs.Fields(2) = DTEvaluationDate.Value rs.Fields(3) = TextProposedSolOutline.Text Any ideas Reply With Quote Mar 30th, 2007,08:44 AM #2 sparbag View Profile View Forum Posts Hyperactive Member Join Date May 2006 Posts 360 Re: Runtime error 438 Object doesn't support this property or method Hello, From Microsoft website: Run Time Error 438 - Object Doesn't Support this Property or Method The most common cause of error 438 is not maintaining binary compatibility between successive versions of your components. Each COM interface has an associated GUID that is called an interface ID (IID). Each coclass has an associated GUID that is called class ID (CLSID). When you compile an ActiveX component in Visual Basic, the CLSIDs and IIDs are compiled into the component's type library. Example A program that consists of a Visual Basic client and an ActiveX DLL is released t
after some form, report, and VBA code modifications now fails to work on one machine. The main switchboard form comes up, but when you select an option from it, the following VBA error is raised: Run-Time Error '438': Object doesn't support this property or method When "Debug" is selected, a VBA window opens with code from a sub-form of the form that is supposed to have opened. The line of code, for what it is worth, is: cbCancelSupervisorChanges.Enabled = False Given that the code works on three other machines, it would seem that the object really does support the property or method. Two observations: 1) The form being opened (the one that causes the run-time error) has an Open event. The switchboard form and splash screen do not. That is to say, this is the first form where VBA code is encountered and run. 2) In the VBA IDE, the Tools->Compile button is always greyed out on the offending machine. This all leads me to believe there is some sort of VBA problem. I did a search on the error number, and it sighted component mis-match as a possible cause as well as some system DLL issues (vague references to MSNConnectionVProxy.dll and pksocx.dll). As I have seen something similar to this before and the problem there was a mis-match of versions in the VBA References (in a VBA window Tools->References), I reviewed that. The offending machine had the following: Visual Basic for Applications Microsoft Access 10.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft Visual Basic for Applications Extensibility 5.3 Whereas the 3 other machine that work have: Visual Basic for Applications Microsoft Access 9.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft Visual Basic for Applications Extensibility 5.3 The difference being the version of the M