Ms Access Error 2162
your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. docmd.findrecord error 2162 P: 34 RAG2007 Hi Having some problems with docmd.findrecord, getting runtime error 2162, in an adp, sql server back end. On my main form, I have a continuous view subform giving a list of subrecords within the main record. Double clicking on the subrecord changes the subform to a form that gives more detailed information on that specific subrecord. I've been trying to use docmd.findrecord to pull up the info, but I'm getting nowhere. Here's my code: Expand|Select|Wrap|Line Numbers iID=Me.ID.Value Forms!frmInitiative.CommView.SourceObject="frmComm" Setctl=Forms!frmInitiative!CommView.Form!ID DoCmd.GoToControlctl.Name DoCmd.FindRecordiID,acEntire,,acSearchAll,,acCurrent The error is coming in on the docmd.findrecord part. I also tried DoCmd.GoToRecord acActiveDataObject, , acGoTo, iID To no avail. Any suggestions out there? Feb 11 '08 #1 Post Reply Share this Question 4 Replies Expert 100+ P: 108 Minion You may have more luck using a filter instead of trying to goto a specific record. Unfortunately, I'm not entirely sure what event is launching your code or from which form. Still the following should work for you in narrowing the records to show just that one record. I'm assuming the field name that contains the ID is called ID. Expand|Select|Wrap|Line Numbers dimiID iID=me.ID.Value 'Iftherecordsetisattachedtotheformthatlaunchesthecodethenthefollowingwillwork,otherwisechangeittopointattheotherform. me.Filter="ID='"&iID&"'" me.FilterOn=True To go back to being able to see the entire recordset just add code to the reverse event setting FilterOn to False. Hope this helps. - Minion - Hi Having some problems with docmd.findrecord, getting runtime error 2162, in an adp, sql server back end. On my main form, I have a continuous view subform giving a list of subrecords within the main record. Double clicking on the subrecord cha
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join 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 and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To https://bytes.com/topic/access/answers/769692-docmd-findrecord-error-2162-a 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 Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) Forum find record command "error 2162" thread705-855326 Forum Search FAQs Links MVPs find record command "error 2162" find record command "error 2162" davikokar http://www.tek-tips.com/viewthread.cfm?qid=855326 (TechnicalUser) (OP) 7 Jun 04 06:54 Hallo I have a single form. I would like to put an unbound text field to use it as a search text box for the whole recordset. The user write something and then click a small "go" button. The code I put behind the button is this:DoCmd.FindRecord [Txt_search], acAnywherebut there is this runtime error 2162: a macro set to one of the current fields properties failed because of an error in a findrecord action argument.Does someone know what's going on?thanks RE: find record command "error 2162" TCARPENTER (Programmer) 7 Jun 04 08:01 karerda,Try:DoCmdFindRecord Me![Txt_search], acAnywhere.HTHTodd RE: find record command "error 2162" davikokar (TechnicalUser) (OP) 7 Jun 04 08:16 Hallo Tcarpenter,I tried:Me!txt_searchMe.txt_searchMe![txt_search]but none works... RE: find record command "error 2162" TCARPENTER (Programmer) 7 Jun 04 11:49 karerda,Sorry, I'm afraid I don't use FindRecord enough to know the ins and outs, but I suspect your problem may have something to do with this blurb I found in the help file:Quote: However, note that if you use a command button to run a macro containing the FindRecord action, the first ins
DriverDoc WinSweeper SupersonicPC FileViewPro About Support Contact Errors Troubleshooting › Runtime Errors › Microsoft Corporation › Microsoft Access › Error 2162 How To Fix Microsoft Access http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-access/2162-microsoft-access-error-2162/ Error 2162 Error Number: Error 2162 Error Name:Microsoft Access Error http://www.utteraccess.com/forum/Runtime-error-VBA-bre-t365359.html&p=367686 2162 Error Description: A macro set to one of the current field's properties failed because of an error in a FindRecord action argument.@In the Macro window, change the Search As Formatted argument to Yes. If you want the argument setting to remain ms access No, do all of the following: * Developer:Microsoft Corporation Software:Microsoft Access Applies to:Windows XP, Vista, 7, 8 Download NowWinThruster 2015 - Scan your PC for computer errors. Compatible with Windows 10, 8, 7, Vista, XP and 2000 Symptoms of Error 2162 "Error 2162" appears and crashes the active program window. Your PC frequently ms access error crashes with Error 2162 when running the same program. “Microsoft Access Error 2162” is displayed. Windows runs sluggishly and responds slowly to mouse or keyboard input. Your computer periodically “freezes” for a few seconds at a time. These 2162 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 2162 error occurs is a critical piece of information in troubleshooting the problem. Causes of Error 2162 Corrupt download or incomplete installation of Microsoft Access software. Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall). Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files. Another program maliciously or mistakenly deleted Microsoft Access-related files. Runtime Errors such as “Error 2162” can be caused by a variety
Custom Search UtterAccess Forums>Microsoft Access>Access Modules Runtime error in VBA only when using breakpoints 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 parryView Member Profile Jan 13 2004, 05:35 PM Post#1Posts: 125Joined: 20-January 03From: Wellington, NZHi could someone please explain why you sometimes get runtime errors if there is a breakpoint on certain statements in VBA?Is an example the following line bombs if there is a breakpoint on this line, but not if there is a breakpoint before or