Error 2185 Access 2010
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss runtime error 2185 access vba the workings and policies of this site About Us Learn more run time error 2185 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow you cannot reference a property or method for a control unless the control has the focus 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 runtime error 424 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|improv
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 00:08:04 GMT by s_ac15 (squid/3.5.20)
+ Ask a Question Need help? Post your question and get tips & solutions from a community of 418,509 IT Pros & Developers. It's quick & easy. Run-time error '2185' https://bytes.com/topic/access/answers/844004-run-time-error-2185-you-cant-reference-property-method You can't reference a property or method P: 77 Sep410 Hi all, Here is my code: Expand|Select|Wrap|Line Numbers PrivateSubCommand12_Click() DimstrSqlAsString strSql="Deletefromtbl_citywhereCityId="&Val(Me!txtEmail.Text)&";" Setcn=CurrentProject.Connection cn.ExecutestrSql Debug.Print"MyTableViewcreated" Setcn=Nothing EndSub I get the Run-time error '2185' when I run it. You can't reference a property or method for a control unless the control has the focus .!!!!!!! If I put this line after defending of the strsql everything work well but I error 2185 don't want to have this line in my code. Expand|Select|Wrap|Line Numbers 'Me!txtEmail.SetFocus There are some SQL statements which has 2 conditions I can't set the focus for both of them at the same time. Oct 7 '08 #1 Post Reply Share this Question 5 Replies Expert 2.5K+ P: 3,532 missinglinq In Access VBA the Text property is only available when the control has focus, as you've seen .The Text property error 2185 access is seldom used in VBA. Use the .Value Property instead. It doesn't require focus to work. And since it's the Default Property for a textbox/combobox, you don't actually have to include it! txtEmail is the same as txtEmail.Value Linq ;0)> Oct 7 '08 #2 reply P: 77 Sep410 Thank you.It is working now. Oct 7 '08 #3 reply Expert 2.5K+ P: 3,532 missinglinq Glad you got it working! Linq ;0)> Oct 7 '08 #4 reply P: 9 sirdevo I had a couple of textboxes I needed to change the .text property on, but when I would setfocus to update the textbox it would cause problems by activating all my events I had placed on those textboxes. It allows me to change the values without causing events to trigger. Sir Devo Nov 12 '09 #5 reply Expert 2.5K+ P: 3,532 missinglinq As I said previously, there is seldom any reason to use the Text Property in Access VBA, and it certainly shouldn't be used to set value of a textbox! If you need to change the value of a textbox thru code, use the Value Property, which doesn't require setting the focus to the textbox. Me.TextboxName.Value = "Whatever" Since the Value Property is the default property for textboxes, com