Home > error 2162 > error 2162 access

Error 2162 Access

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Craig Borysowich Dennis Stevenson DukeGanote Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question Microsoft Access The Microsoft Access group is for the discussion of issues that arise during the implementation, configuration, administration, or daily use of MS Access. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Findrecord Gives Runtime Error 2162 Guest_PK asked Oct 31, 2013 | Replies (2) I am getting run time error 2162 "A macro set to one of the current field properties failed because of an error in a FindRecord action argument" when the control transfers from Search Form to View-Update Form. What I am trying to do is, based on the search result in Search Form, I'm trying to populate details on the View-Update Form

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 Rate Thread Display Modes 09-16-2014, 09:09 AM #1 fat controller Slightly round the bend.. Join Date: Apr 2011 Posts: 671 Thanks: 347 Thanked 5 Times in 5 Posts Runtime error 2162 - intermittent I am really confused now - I have some code which works perfectly well for the vast majority of the time, however once in a while it will throw its toys out of the pram and give me an error message 'Runtime Error 2162' and states that this is http://database.ittoolbox.com/groups/technical-functional/access-l/findrecord-gives-runtime-error-2162-5355030 due to an error in the FindRecord Statement; when debugged, it highlights the line of code (below) which is the FindRecord Statement: Code: DoCmd.FindRecord EmpNo, acEntire, , acSearchAll, False, acCurrent Yet, I can see nothing wrong with this code? Surely if the code was duff, it wouldn't work at all? The problem seems more likely to happen if the database has not long been opened, if that makes any sort of difference? I'd be grateful for http://www.access-programmers.co.uk/forums/showthread.php?t=269261 any help that can be given, as I am not keen on releasing the database into use knowing that its a bit buggy. fat controller View Public Profile Find More Posts by fat controller 09-16-2014, 10:06 AM #2 fat controller Slightly round the bend.. Join Date: Apr 2011 Posts: 671 Thanks: 347 Thanked 5 Times in 5 Posts Re: Runtime error 2162 - intermittent I think I have solved it by adding a 1 second pause to the code just as it starts (and well before it gets to the FindRecord command) - although I have no idea why this would make a difference? EDIT - nah, it didn't. Logged out for a couple of minutes and logged back in and the problem is still there. So frustrating, not least because it is not happening all the time. Last edited by fat controller; 09-16-2014 at 10:12 AM. fat controller View Public Profile Find More Posts by fat controller 09-16-2014, 10:25 AM #3 MarkK Super Moderator Join Date: Mar 2004 Location: Vancouver BC Posts: 6,346 Thanks: 4 Thanked 931 Times in 891 Posts One problem with DoCmd is that it doesn't specify an object on which to operate, so it could be that you need to DoCmd.SelectObject or explicitly .SetFocus to something first. L

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 https://www.experts-exchange.com/questions/21815776/Using-DoCMD-FindRecord-getting-runtime-error-2162.html to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts http://www.utteraccess.com/forum/index.php?showtopic=365359 Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Using DoCMD.FindRecord getting runtime error 2162 Want to Advertise Here? Solved Using DoCMD.FindRecord getting runtime error 2162 Posted on 2006-04-16 MS Access 1 Verified Solution 12 Comments 2,196 Views Last Modified: 2008-01-09 I have a form on which there is error 2162 a combo box, which gets its data from a number field in a table, which has been sorted distinctly into descending order. What I want to be able to do is if the user changes the combo box number to something else then it moves to that record. The code I wrote looks like this: Private Sub Shipment_Number_Change() Dim ShipmentNumber As Integer [Shipment Number].SetFocus error 2162 access ShipmentNumber = [Shipment Number].Value Debug.Print ShipmentNumber DoCmd.FindRecord ([ShipmentNumber]) End Sub I put the debug.print in there so I could check that the code correctly gets the right number (which it does), but because the control is not bound to anything I believe this is my problem. So, here's my problem. I want to get distinct values into a combo box (I have already managed this bit) from a table, and if the user changes the combo box, find the first occurance of that record in a table called ChillOrders. I am somewhat mystified why I cannot bind the combo box to the table (the field is called "ShipmentNumber"), and having written this sort of thing many times before in MSSQL I can't see why this cannot simply be done. Anyone got any suggestions? 0 Question by:zaphod_beeblebrox Facebook Twitter LinkedIn Google LVL 58 Best Solution byharfang Hello, > (do I need these -- is this the problem?) Yes, you need key fields. For single-table stuff, Access doesn't need them, but if you want to create editable multi-table queries, key fields Go to Solution 12 Comments LVL 58 Overall: Level 58 MS Access 52 Message Expert Comment by:harfang2006-04-16 Hello, Perhaps you sho

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 after this line. The error message is Run time error 2162. A macro set to one of the current fields properties failed because of an error in a FindRecord action argument.CODEDoCmd.FindRecord SchVal, acAnywhere, False, acSearchAll, _False, acCurrent, False T

 

Related content

error #2162 extraneous return value

Error Extraneous Return Value p that code Some of them are style and some are function A do-while loop puts the conditions for the end at the bottom where it is less visible to the programmer When doing an infinite loop it is better to use relatedl a while loop or a for loop so that the programmer sees what it is at the beginning of the loop and does not have to search for the loop end if adrs exit If you are debugging such a line you will not see if the target of the if statement is

error 2162 findrecord

Error Findrecord table id toc tbody tr td div id toctitle Contents div ul li a href Docmd Findrecord Error a li ul td tr tbody table p Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy relatedl Java Knowledge Management Linux Networking Oracle PeopleSoft Project p h id Docmd Findrecord Error p and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic runtime error access Web Design and Development Windows Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP News

error 2162

Error table id toc tbody tr td div id toctitle Contents div ul li a href Vba Access Runtime Error a li li a href Ms Access Runtime a li ul td tr tbody table p Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us Are you aComputer IT professional Join Tek-Tips Forums Talk With Other Members relatedl Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access access run time error To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All It's Free Join p h id Vba Access Runtime Error p Us Tek-Tips's functionality depends on