Error 2185 Access Vba

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 you cannot reference a property or method for a control unless the control has the focus Learn more about Stack Overflow the company Business Learn more about hiring developers runtime error 424 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; 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,20741435 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| Did you find this question interesting? Try our n

Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 10-06-2010, 08:00 AM #1 Rx_ Nothing In Moderation Join Date: Oct 2009 Location: Denver, Colorado Posts: 2,633 Thanks: 557 Thanked 308 Times in 282 Posts [solved] Error 2185 You can't reference a property or method for a control Trying to read the Text in a combobox. The Value (usually an index) is available, but is not always what http://stackoverflow.com/questions/20703479/run-time-error-2185 is needed. Sometimes we want the text. The Text property is not available unless the control has the focus. Here is an alternative Run-time error '2185': You can't reference a property or method for a control unless the control has the focus. Read several quetions and feel that this is what people were asking for. Did not readily find a post that puts the answer up front. This might help the http://www.access-programmers.co.uk/forums/showthread.php?t=199905 search. Immediate Window example: ' combobox- retrieving Values ? Me!id_area.value 24 ? Me!id_area.Text *** SEE ERROR GENERATED --->>> 2185 Alternate Method ? Me!ID_Area.Column(0) 24 ? Me!ID_Area.Column(1) ND - Main Store Note: Column(1) is a contrived value from two or more fields Example: msgbox "Thank You for choosing " & Me!ID_Area.Column(1), VBOKOnly, "Thanks Bonehead - for purchasing a T-Rex skull" Also See: http://www.access-programmers.co.uk/...d.php?t=199489 Attached Images Error 2185 solved.png (12.4 KB, 310 views) __________________ Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved. This will help others later who search to find solutions. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Clicking the THANKS and clicking on the SCALES can be a bonus! The volunteers will often remember your appreciation and help again. Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading." Sitting is the new Smoking - Cut down on it and live longer Rx_ View Public Profile Find More Posts by Rx_ Tags 2185 , combobox , control , error , focus « Previous Thread | N

Question Need help? Post your question and get tips & solutions from a community of 418,509 https://bytes.com/topic/access/answers/761914-runtime-error-2185-control-has-focus IT Pros & Developers. It's quick & easy. Runtime Error '2185' on control that has focus 100+ P: 675 OldBirdman I've spent all day on this, and can't see http://www.vbforums.com/showthread.php?557698-RESOLVED-Access-2007-Referencing-Controls-Without-Focus what I'm doing wrong. I've Googled and all I find have the same mistake, using .Text when they should use .Value. In this case, .Text is correct. Expand|Select|Wrap|Line error 2185 Numbers PrivateSubtxtSearch_Change() DimwkAsString wk=Me.txtSearch.Text'ThisisthestatementthatgetsRuntimeError'2185' ... EndSub I tried wk = txtSearch.Text to no avail. I tried txtSearch.SetFocus before the use/assignment, also didn't work. Obviously, the control has the focus, as I am typing in it, and want to monitor what is entered, as it is entered. Trying to trick Access into doing my bidding, I tried Expand|Select|Wrap|Line error 2185 access Numbers PrivateSubtxtSearch_Change() DimwkAsString cmdExit.SetFocus wk=txtSearch txtSearch.SetFocus txtSearch.SelStart=255 ... EndSub Now wk has the correct information, but the error occurs on the .SelStart = 255 statement. Leaving that out means that the entire string in the TextBox is selected. Not acceptable. I copied the code for this control to a new database, new form with one control only. The code works. I copied the form to the new database, removed the RecordSource so I wouldn't have to duplicate the entire program. Works fine. I don't want the code debugged, as the code works. I'm looking for ideas about what, on a form, might conflict with the "Got Focus". You know, like if the TextBox Backcolor is light blue, the moon is full, and the form is modal, there is trouble, so change on of these. That kind of idea. OldBirdman Jan 22 '08 #1 Post Reply Share this Question 6 Replies Expert 2.5K+ P: 3,532 missinglinq Expand|Select|Wrap|Line Numbers PrivateSubtxtSearch_Change() DimwkAsString wk=Me.txtSearch.Text'ThisisthestatementthatgetsRuntimeError'2185' ... EndSub The .Text property is, indeed, appropria

Without Focus If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: [RESOLVED] Access 2007 Referencing Controls Without Focus Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 13th, 2009,09:11 AM #1 Sam_R View Profile View Forum Posts Thread Starter Junior Member Join Date Jan 2008 Posts 30 [RESOLVED] Access 2007 Referencing Controls Without Focus I am writing a database in Access 2007 that references several databases written in Access 03. Each '03 database contains sales data for a specific month and is named as such. For example, December 2008 sales is 0821.mdb, January 2009 is 0901.mdb, etc. I created a form with text fields formatted as dates so that the user can pick a range for monthly sales to view. Once the dates have been entered, there is a "Run Sales" command button. On the click event of the "Run Sales" button I have written a VBA module that parses the month and year from the dates using Left() and Mid() commands set equal to a string variable, then I intended to use that variable (probably converted to integer) to create a FOR NEXT loop to import all the databases. I did not get as far as the loop. I created a "test" text box to see whether the code was storing the correct values in the variables. When I clicked the "Run Sales" button, the program reported: Runtime error '2185'. You can't reference a property or method for a control unless that control has focus. I'm sure there must be a way to reference controls without focus, or else how could a person create, say, a calculator program with a "Total" button or a button that changes the background color of a control or form? Then again, maybe I am totally going about this the wrong way. Code: Private Sub btnR