Ms 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 - Run time Error run time error 438 object doesn't support this property or method '438' Microsoft Office > Office 2010 - IT Pro General run time error 438 access vba Discussions Question 0 Sign in to vote When I click on the Reports sub-menu in our RecruitmentHR.mdb run time error 438 excel macro from the Switchboard menu, I get the following error message: Run-time error '438' Object doesn't support this property or method I performed all of my Microsoft updates, access error 438 object doesn't support 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 reference in Tools|References (Alt-F11). Run Debug|Compile to see
Microsoft Visual Basic Runtime Error 438 Excel
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 Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security Virtualization Up
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit
Microsoft Visual Basic Runtime Error 438 Object Doesn't Support This Property Or Method
Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing run time error 438 vba excel 2010 Store Headlines Experts Exchange > Questions > How to resolve the error "Run time error 438. Object doesn't support this property or method" 438 object doesn't support this property or method vba in Access 2010 under Windows 7? Want to Advertise Here? Solved How to resolve the error "Run time error 438. Object doesn't support this property or method" in Access 2010 under Windows 7? Posted on 2012-10-10 MS Access https://social.technet.microsoft.com/Forums/office/en-US/1230d020-f122-4882-afd3-4417d17a24ee/access-2010-run-time-error-438?forum=officeitproprevious 1 Verified Solution 2 Comments 6,767 Views Last Modified: 2012-10-11 I am developing an Access application with Access 2003. I upgraded the application to Access 2010. When I run the application in Windows 7, when the compiler reaches the line commonDlg.Filter = "All Files (*.*)|*.*" shown below, I get the compiler error: Run time error 438. Object doesn't support this property or method. Private Sub cmdBrowse_Click() filenm = "" commonDlg.Filter = "All Files (*.*)|*.*" 0 https://www.experts-exchange.com/questions/27895946/How-to-resolve-the-error-Run-time-error-438-Object-doesn't-support-this-property-or-method-in-Access-2010-under-Windows-7.html Question by:zimmer9 Facebook Twitter LinkedIn Google LVL 119 Active today Best Solution byRey Obrero try this first ADD Microsoft Office 14.0 Object Library to your References Tools > References (CODE) Go to Solution 2 Comments LVL 75 Overall: Level 75 MS Access 75 Message Active today Expert Comment by:DatabaseMX (Joe Anderson - Access MVP)2012-10-10 How about using the newer method .. Code commented out are just other examples. Public Function msoFileFolderBrowse() As Boolean ' With Application.FileDialog(4) ' .InitialFileName = "P:\invoices" ' start in this folder ' .AllowMultiSelect = False ' .Show ' ' If .SelectedItems.Count > 0 Then ' MsgBox .SelectedItems(1) ' End If ' ' End With ' ' With Application.FileDialog(3) ' 3=msoFileDialogFilePicker ' If .Show Then Debug.Print .SelectedItems(1) ' ' more code ' ' End With With Application.FileDialog(4) '4=msoFileDialogFolderPicker If .Show Then Debug.Print .SelectedItems(1) 'more code End With End Function 0 LVL 119 Overall: Level 119 MS Access 119 Message Active today Accepted Solution by:Rey Obrero2012-10-10 try this first ADD Microsoft Office 14.0 Object Library to your References Tools > References Private Sub cmd
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/20556859/programmatically-setting-textbox-value-but-returning-run-time-error-438 policies of this site About Us Learn more about Stack Overflow the http://www.vbforums.com/showthread.php?460591-RESOLVED-Runtime-error-438-Object-doesn-t-support-this-property-or-method company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 error 438 takes a minute: Sign up Programmatically setting textbox value but returning run-time error 438 up vote 1 down vote favorite I am trying to set the value of a text box based on the value I select in a combo box and a pre-existing value in another text box. Both the controls are in a continuous subform within a form. When time error 438 I select a value in the combo box, I get the following: Run-time error '438': Object doesn't support this property or method My code looks like this: Private Sub Combo1_Dirty(Cancel As Integer) Dim con As ADODB.Connection Set con = Application.CurrentProject.Connection Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset ssql = "(SELECT TABLE1.DESCRIPTION As d1 " & _ "FROM TABLE1 " & _ "INNER JOIN TABLE2 ON " & _ "(TABLE1.CATEGORY = TABLE2.CATEGORY) " & _ "AND (TABLE1.LEVEL = TABLE2.LEVEL) " & _ "WHERE " & _ "(((TABLE1.LEVEL)= " & [Forms]![MainForm].[Subform].[Combo1] & ") " & _ "AND ((TABLE2.CATEGORY)= '" & [Forms]![MainForm].[Subform].[CATEGORY] & "'));)" rs.Open ssql, con Do Until rs.EOF = True [Forms]![MainForm].[Subform].TextBox1.SetFocus [Forms]![MainForm].[Subform].TextBox1.Text = rs.Fields!d1 rs.MoveNext Loop End Sub I've searched quite a bit online, and can't quite figure out what I'm doing wrong. Any help is greatly appreciated. Thanks! vba ms-access share|improve this question asked Dec 13 '13 at 0:13 tysonwright 104 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted Try referring instead to [Forms]![MainForm].[Subform].Form.TextBox1 [Subform] refers to the object on Mainform.
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 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 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, 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 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 361 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 con