Error 438 Access Vba
Contents |
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums vba error 438 object doesn't support Show Threads Show Posts Tag Search Advanced Search Find All
Vba Runtime Error 438
Thanked Posts Go to Page... Thread Tools Rating: Display Modes 09-24-2008, 07:13 AM vba runtime error 438 object doesn't support this property or method #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
Excel Vba Error 438
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 run-time error 438 vba 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 focus
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
Run Time Error 438 Object Doesn't Support This Property Or Method
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Run Time Error 438 Excel Macro
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, runtime error 438 excel 2010 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 http://www.access-programmers.co.uk/forums/showthread.php?t=157503 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 = http://stackoverflow.com/questions/20556859/programmatically-setting-textbox-value-but-returning-run-time-error-438 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 at 2:13 And when I run the debugger, it highlights the following line of code: r
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 Close 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 Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How to resolve the error "Run time error 438. Object doesn't support this property or method" in http://www.pcreview.co.uk/threads/run-time-error-438-problem.1148924/ 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 1 error 438 Verified Solution 2 Comments 6,721 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 Question by:zimmer9 time error 438 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 cmdBrowse_Click() Dim f
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 Microsoft Access Object Library (10.0 vs. 9.0). The offending machine is running Win2000 with OfficeXP. One of the "good" machines is XP with Office XP. The other machines are Win2000/Office 2000 (for sure!). Any ideas on how to whack this bug will be greatly appreciated!!! Thanks!! Don Don, Mar 9, 2004 #1 Advertisements TC Guest Didn't you ask this a few days ago el