Error 2137
Custom Search UtterAccess Forums>Microsoft® Access>Access Errors + Error Handling Runtime Error - 2137 - You Can't Use Find And Replace Now Help, Access 2007 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options p_n_guinView Member Profile Sep 30 2013, 01:00 PM Post#1Posts: 2Joined: 30-September 13Hello, 'd appreciate any advice on the following code - it works correctly the first time I use it and switch between Combo63 values (different fiscal years worth of data); however, after working in a recordset and trying to switch to another fiscal year - so choosing a different value from Combo63, I get error 2137 - you can't use find and replace now. Now I know this error often occurs when there is no data in my table that matches the find record requested, but the data does exist matching the fiscal year requseted, the fun
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 Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > run-time error '2137' Want to Advertise Here? Solved run-time error '2137' Posted on 2007-07-16 MS Access 3 Verified Solutions 15 Comments 1,591 Views Last Modified: 2013-11-28 I have a database that keeps track of tests that http://www.utteraccess.com/forum/index.php?showtopic=2009788 employees are required to take on a yearly basis. At the beginning of a new year, I save the previous years data so that it is still accessable and add a link to the previous years page for that purpose. The form has a command that activates the find control. When I go to activate the find control in the previous years data it get 'run time https://www.experts-exchange.com/questions/22699237/run-time-error-'2137'.html error 2137' message. The VBA code below works in all the forms except the one that access the most current previous years data. Private Sub cmdfind_Click() On Error GoTo Err_cmdfind_Click DoCmd.Maximize Me.txtName.SetFocus 'Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Exit_cmdfind_Click: Exit Sub Err_cmdfind_Click: MsgBox Err.Description Resume Exit_cmdfind_Click End Sub The error occurs on the following line: DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 I'm pretty sure I'm not explaining this in a clear way, but if anyone could help with this error I would greatly appreciate it!! 0 Question by:Jeanniem Facebook Twitter LinkedIn Google LVL 119 Active today Best Solution byRey Obrero error 2137- generated for the following reasons You can't use Find or Replace now.@The fields are not searchable due to one of the following: * The fields are controls (such as buttons or OLE objects). Go to Solution 15 Comments LVL 142 Overall: Level 142 MS Access 27 Message Active today Assisted Solution by:Guy Hengel [angelIII / a3]2007-07-16 if there is no current record, the Edit/Find menu is disabled, hence that error message. 0 LVL 75 Overall: Level 75 MS Access 75 Message be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 21:04:54 GMT by s_ac15 (squid/3.5.20) be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 21:04:54 GMT by s_ac15 (squid/3.5.20)