Ms Access 2010 Run Time 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 Discussions run time error 438 access vba 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, microsoft visual basic runtime error 438 excel 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 Object Doesn't Support This Property Or Method
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 Updates Ser
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 Thanked Posts Go to Page... Thread Tools Rating:
Access Error 438 Object Doesn't Support
Display Modes 09-24-2008, 07:13 AM #1 Glowackattack Registered User Join Date: Feb 2008 runtime error 438 access Posts: 126 Thanks: 0 Thanked 0 Times in 0 Posts Run Time error 438 - Object doesnt support this property or method Hi, run time error 438 vba excel 2010 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 https://social.technet.microsoft.com/Forums/office/en-US/1230d020-f122-4882-afd3-4417d17a24ee/access-2010-run-time-error-438?forum=officeitproprevious running access 03 on the new one too). Here is a breif overview 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 http://www.access-programmers.co.uk/forums/showthread.php?t=157503 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 focus, not the "Type of Premium" field which i want....but at least i dont get an error and everything else updates like i want, i just want the Type of premium field to have focus for ease of data entry. Please let me know if i can explain this better, and thanks for your help in advance. Glowackattack View Public Profile Find More Posts by Glowackattack 09-24-2008, 07:27 AM #2 nIGHTmAYOR Newly Registered User Join Date: Sep 2008 Location: Guess Posts: 240 Thanks: 0 Thanked 0 Times in 0 Posts Re: Run Time error 438 - Object doesnt support this property or method ok since u say all the above code r valied however ur true problem lays in [Typ
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 Business Learn http://stackoverflow.com/questions/2767168/microsoft-flexgrid-control-run-time-error-438-object-doesnt-support-this-pro more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags http://stackoverflow.com/questions/20556859/programmatically-setting-textbox-value-but-returning-run-time-error-438 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 Microsoft flexgrid Control : Run-time error '438' Object doesnt support this property or method up vote 2 down vote favorite I am maintaining a legacy error 438 Microsoft Access application that is using the Microsoft Flexgrid 6.0. It recently started causing the following error: Run-time error '438' Object doesn't support this property or method People say that this error can be caused by the KB960715 security update being applied, which sets killbits on various ActiveX control methods which were deemed a security risk. But this or no other security update has been applied recently. Others say that installing Microsoft Visual Basic 6.0 Service time error 438 Pack 6 Cumulative Update will update the flex grid. This requires VB6 to be installed as a prerequisite so I installed that on my PC and then the update, and retrieved the updated MsFlxGrd.ocx file(Version: 6.1.98.12) and copied to the application machine, but the error still prevails. Someone here says you can disable the killbit in the registry. But there are afew hundred nodes in the location they suggest, none of which has the same guid as the one they point out. Any ideas? ms-access vb6 msflexgrid share|improve this question edited May 5 '15 at 16:28 JasonMArcher 6,25183744 asked May 4 '10 at 16:39 Dan 14.3k37120181 1 I know you didn't do it, but using an outside data grid control in an Access app indicates that the orginal developer was basically not really competent as an Access developer. Access doesn't need a non-native data grid because it's own datasheets and continuous forms provide all the flexibility you need, and are fully bound. –David-W-Fenton May 7 '10 at 1:33 @David That is interesting to know. I'm not an Access Developer myself, so was hoping I could just apply a band-aid solution. But I guess if all else fails I can look into removing the flex grid. –Dan May 7 '10 at 8:54 1 My guess is that the original developer was a
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 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 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 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. 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 valu