Error 2185 Vb
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 you cannot reference a property or method for a control unless the control has the focus us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow runtime error 424 Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Access 2010 Runtime Error 2185 up vote 1 down vote favorite Hi I have an application created in Access 2007, it's front-end and back-end is split. I am trying to open the database using Access 2010 runtime, however the application crashes when I change selected item of a combo box. I receive the following error: "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down." After researching the problem, a few people mentioned running the compact and repair, and found that fixed their problem, however it made no difference to mine. However, I found most people to come back and say put some error logging in place. So I have done that, and when running on 2010 runtime, a receive a pop up message saying the following: Error number: 2185, You can't reference a property or method for a control unless the control has the focus. However when running in Access 2007, there is no error and the code works fine. This is the code I have been using: Private Sub ComboBox1_Change() If Not ComboBox1.Text = "" Then ComboBox1.Dropdown End If End Sub My question is, why would this suddenly become an issue running on 2010 runtime, when there is no error in Access 2007? ms-access ms-access-2007 runtime-error ms-access-2010 share|improve this question asked Mar 22 '13 at 11:15 Mike 815 I had a few odd problems switching my test databases to 2010, but decompile sorted them out, or worst case scenario, importing to a new db. –Fionnuala Mar 22 '13 at 21:00 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted change If Not ComboBox1.Text = "" Then to If Not ComboBox1 = "" Then For whatever reason Access does not like you use the .Text property outside of it's strict control. share|improve this answer answered Mar 22 '13 at 17:50 Brad 7,85321951 You can use text when a control has the focus, and as this is the change event for the control, it has the focus. –Fionnuala Mar 22 '13 at 20:58 I thought `change might be able to have it fire if you changed the text/record programmatically but I guess not! –Brad Mar 22
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 14:10:30 GMT by s_wx1131 (squid/3.5.20)
applications Pocket PC API Network ActiveX VBA (Access, Excel, Word, ...) Multimedia Other .NET Languages ASP.NET C# VB Anything Non-English ONLY Off-Topic Today's active posts Search Source http://www.andreavb.com/forum/viewtopic_7080.html Code API Calls List Beginner's corner Miscellaneous source code Miscellaneous API Files and disks code COM and LPT ports Form's API Windows NT/2000/XP Printing in Visual Basic Registry and INI Files Video, bitmaps and colors Winsock, NetAPI and internet VB and VBA for Word and Access Database management VB Script and ASP Articles and tutorials Downloads Visual Basic for beginners error 2185 Miscellaneous source code API - Application Program Interface Files and disks Bluetooth, COM, LPT, USB ports Printing in Visual Basic Graphics Winsock, NetAPI and internet VBA - Visual Basic for Applications Database Full controls e-Books Visual Basic games Submit your code News Visual Basic books News for programmers AndreaVB downloads - news and comments Search/offer jobs Links Partners Marco Bortolani error 2185 vb robertoventurelli.com Links Directory ...Other links Contacts Advertise with us Feedback Drop us a comment Link to us AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile AndreaVB Forum : Database : Run-time Error assigning text to/from textbox - error 2185 Poster Message ba1959nhLevel: ScholarRegistered: 10-05-2006Posts: 30 Run-time Error assigning text to/from textbox - error 2185 I am getting the following error when I try to assign the value of a textbox to an integer in my Spin Button's SpinUp event handler. This error also occurs if I try to assign the textbox.text property to a string variable...... Run-time error 2185: You can't reference a propert or method for a control unless the control has focus. Perhaps this is a stupid question, but I just do NOT understand why this is happening. H E L P! ! ! CODE: Sub SpinBtnDonationAmt_SpinUp() Dim iValue As Integer Dim iIncrementer As Integer iIncrementer = 5 'Get the value out of the text box and store it in a variable iValue