2147352567 Runtime Error
VBA Code & Other Help Access Help Keep getting Run-time error -2147352567(80020009) msg, Need Help! If this is your first visit, be sure to check out the FAQ by clicking the link above. runtime error 80020009 You may have to register before you can post: click the register runtime error 2147352567 access link above to proceed. To start viewing messages, select the forum that you want to visit from the selection run time error 2147352567 below. Results 1 to 6 of 6 Thread: Keep getting Run-time error -2147352567(80020009) msg, Need Help! Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-16-2008,05:55 AM #1 keek2a4 View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Sep 2007 Posts 24 Keep getting Run-time error -2147352567(80020009) msg, Need Help! Hello Everyone! I have a table called tblStudent with fields studentID, studentName, studentAddress and dateUpdated. I have a form that displays a record of the table tblStudent. In the BeforeUpdate event of the form, I have the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Text206 = Now() End Sub Formatting tags added by mark007 which says, any changed made to any fields in the form, Before updating the record, update the field "dateUpdated" with the current date. The field "dateUpdated" is called Me.Text206 in the form. However, whenever I edit or make changes to the form, I keep getting the following error message: Run-time error '-2147352567(80020009)': You can 't assign a value to this object. Formatting tags added by mark007 Its quite strange because, I have the same code for the subject form which is linked to the subject table and it works fine. I can't figure out why I keep getting this error, any help plz Thanks, Reply With Quote 01-16-2008,01:12 PM #2 rconverse View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Jan 2008 Posts 48 Location Is Me.Text206 set to a date format? Reply With Quote 01-18-2008,03:22 AM #3 DarkSprout View Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Oct 2007 Location Essex, Eng
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 01:39:38 GMT by s_bd40 (squid/3.5.20)
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 Learn more http://stackoverflow.com/questions/22009852/odd-runtime-error-in-vba-2147352567 about Stack Overflow the company Business Learn more about hiring developers or posting ads http://www.utteraccess.com/forum/Run-time-Error-21473525-t1986935.html 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 Odd runtime error in VBA: -2147352567 [closed] up vote 1 down vote favorite time error Morning, I encountered this odd runtime error when I tried to perform an update to a field: This occurred when the VBA code attempted to set a field (which is a normal textbox and doesn't have a date format set) to a text value from a table. It should set that textbox to "somename" to signify who made the change. The second sentence seems wrong to me as the time error 2147352567 value returned is a string. The VBA code that returns the error is actually a BeforeUpdate routine - could this be why? Private Sub Stat_Code_BeforeUpdate(Cancel As Integer) where Stat_Code is a combo-box on the same subform. I looked about but couldn't find any solution that would explain this. Any ideas? vba ms-access share|improve this question asked Feb 25 '14 at 9:29 Katana24 2,35993769 closed as off-topic by Gord Thompson, chris neilsen, mehow, psubsee2003, Albzi Mar 4 '14 at 10:22 This question appears to be off-topic. The users who voted to close gave this specific reason:"This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Gord Thompson, chris neilsen, Community, AlbziIf this question can be reworded to fit the rules in the help center, please edit the question. add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Turns out that the source table that the form was set up to write to was incorrec
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Run-time Error '-2147352567 (80020009)' 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 tobabyguView Member Profile May 11 2012, 11:18 AM Post#1Posts: 212Joined: 9-November 11I'm using access 2010.I'm getting Run-time error '-2147352567 (80020009)': The value you entered isn't valid for this field.Here's the VB in the background. Private Sub LoanNbr_AfterUpdate()Me.FDICAssetNumber = DLookup("[AssetID]", "FDICAssetIDS", "[BankH