Accesss Vba Forms Runtime Error 2185 2115
Contents |
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 run time error 2185 Learn more about Stack Overflow the company Business Learn more about hiring developers or
You Cannot Reference A Property Or Method For A Control Unless The Control Has The Focus
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; it only takes a minute: Sign up Run time error 2185 up vote 2 down vote favorite I getting a run time error 2185, "You can't reference a property or method for a control unless the control has the focus ...". This is my code that I am using. Private Sub Command5_Click() Dim cardno As Integer cardno = cardnumber.Text DoCmd.OpenForm "search_card_number", acNormal, , WHERE & cardno = [Account Number] End Sub ms-access access-vba share|improve this question edited Dec 20 '13 at 16:30 HansUp 79.1k114371 asked Dec 20 '13 at 12:17 Steve 431211 add a comment| 3 Answers 3 active oldest votes up vote 3 down vote Referencing the .Text property of a control requires it to have focus. Simply drop that and it should work (the default is .Value) OR Try putting in the SetFocus method as advised by Access, i.e. Private Sub Command5_Click() Dim cardno As Integer cardnumber.SetFocus <-------Use this line to set the focus cardno = cardnumber.Text DoCmd.OpenForm "search_card_number", acNormal, , WHERE & cardno = [Account Number] End Sub share|improve this answer answered Dec 20 '13 at 12:35 agnes 1,20441435 I get a runtime error 6, overflow. but the carnumber.text did get the value I was enter in textbox –Steve Dec 20 '13 at 12:42 I guess data can no longer be held by an integer. Try changing the line Dim cardno As Integer to Dim cardno As Long should fix the immediate problem. –agnes Dec 20 '13 at 12:49 I get a 2465 runtime error, and is highlighted the Docmd section in yellow. –Steve Dec 20 '13 at 12:55 add a comment| up vote 1 down vote That run time error means You ca
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 29 Sep 2016 17:15:15 GMT by s_hv972 (squid/3.5.20)
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join http://www.tek-tips.com/viewthread.cfm?qid=483583 Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework error 2185 and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules (VBA time error 2185 Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) Forum Can't Reference Property unless Control has the focus...??? 2 thread705-483583 Forum Search FAQs Links MVPs Can't Reference Property unless Control has the focus...??? Can't Reference Property unless Control has the focus...??? sanders720 (Programmer) (OP) 24 Feb 03 09:58 This just seems sop simple.I have one line of code when I click on a combo box.This is supposed to place a value of "1" in a corresponding textbox.It looks like this...me.txtITJobNo.Text="1"and produces this error...Runtime Error 2185 - You can't reference a property or method unless the control has the focus.So...Just for fun, I added a setfocus to the textbox prior to trying to change the textbox, which looks like this...me.txtITJobNo.SetFocusme.txtITJobNo.Text="1"which produces this error...Runtime Error 2115 - The Macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field.I don't follow.Th