Ms Access Vba Error 438
Contents |
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums run time error 438 object doesn't support this property or method Show Threads Show Posts Tag Search Advanced Search Find All run time error 438 excel macro Thanked Posts Go to Page... Thread Tools Rating: Display Modes 09-24-2008, 07:13 AM access error 438 object doesn't support #1 Glowackattack Registered User Join Date: Feb 2008 Posts: 126 Thanks: 0 Thanked 0 Times in 0 Posts Run Time error 438 - Object doesnt support this
Microsoft Visual Basic Runtime Error 438 Excel
property or method Hi, I am having problems with an access database i created a couple months ago, and i should probably start by saying i recently got a new computer and this is my first time using the database since(i am running access 03 on the new one too). Here is a breif overview microsoft visual basic runtime error 438 object doesn't support this property or method of my setup, I have a form, and within it is a subform, and within the subform is another subform, i guess an easy way to describe is like this we have a case(main form info), which breaks down into policies(first subform), which breaks down into payment information for each policy (2nd subform). I have fields on the first subform that sums payment information for each policy, when i update information on the 2nd subform, i have the following code. Code: Private Sub Premium_Amount_AfterUpdate() '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim record As Integer Dim ParentRecord As Integer record = Me.CurrentRecord ParentRecord = Me.Parent.CurrentRecord Forms![Frm_CaseOverview]![Frm_PolicyOverview_subform].Form.Requery Forms![Frm_CaseOverview]![Frm_PolicyOverview_subform].SetFocus DoCmd.GoToRecord , , acGoTo, (ParentRecord) [Frm_PolicyBreakdown_subform].Form.Requery Forms![Frm_CaseOverview]![Frm_PolicyOverview_subform]![Frm_PolicyBreakdown_subform].SetFocus DoCmd.GoToRecord , , acGoTo, (record + 1) [Type of Premium].SetFocus Everything worked fine in the past, and the field i wanted (type of premium) had focus after the update, now when i run this i get the error, if i comment out the last line, the premium amount field of the next record gets foc
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 run time error 438 vba excel 2010 Overflow the company Business Learn more about hiring developers or posting ads with us
Runtime Error 438 Access
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a
438 Object Doesn't Support This Property Or Method Vba
community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Programmatically setting textbox value but returning run-time error 438 up vote 1 down vote favorite http://www.access-programmers.co.uk/forums/showthread.php?t=157503 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 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 http://stackoverflow.com/questions/20556859/programmatically-setting-textbox-value-but-returning-run-time-error-438 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. You need to qualify it with Form to refer to objects within it. share|improve this answer answered Dec 13 '13 at 0:46 user2165401 182 I changed all instances of controls to use that additional 'Form' qualifier. Now I get the following error: "Run-time error '-2147217904 (80040e10)': No value given for one or more required parameters." –tysonwright Dec 13 '13
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 http://www.vbforums.com/showthread.php?460591-RESOLVED-Runtime-error-438-Object-doesn-t-support-this-property-or-method 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 error 438 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 time error 438 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 consists of a Visual Basic client and an ActiveX DLL is released to the user community. At a later time, additional functionality is to be added to the DLL component. The necessary modifications are made, and the ActiveX DLL is compiled without maintaining binary compatibility. When the DLL is released, the client that is trying to use the DLL will throw run time error 438. The reason this occurs is that when the DLL was compiled, a fresh set of GUIDs was compiled into the DLL, and the client has no reference to these new