Error 438 Vba Access
Contents |
360 games PC games run time error 438 vba access Windows games Windows phone games Entertainment All Entertainment
Run-time Error 438 Vba Object Doesn't Support
Movies & TV Music Business & Education Business Students & educators
Runtime Error 438 Vba Excel
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Vba Runtime Error 438 Object Doesn't Support This Property Or Method
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All run time error 438 object doesn't support this property or method Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 run time error 438 excel macro Project Hire for a Full Time Job Ways to Get Help Expand runtime error 438 excel 2010 Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store microsoft visual basic runtime error 438 excel Headlines Experts Exchange > Questions > How to resolve the error "Run time error 438. Object doesn't support this property or method" in Access 2010 under Windows 7? Want to https://support.microsoft.com/en-us/kb/175616 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 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 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 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 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 App
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/20556859/programmatically-setting-textbox-value-but-returning-run-time-error-438 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 4.7 million programmers, just like you, helping each other. Join them; error 438 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 time error 438 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.Text