05-26-2009, 04:02 PM #3 Liz Registered User Join Date: May 2009 Posts: 6 Thanks: 0 Thanked Mar 2 '11 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Im not sure if the coding is correct, any help or suggestions would be much appreciated. pbaldy View Public Profile Find More Posts by pbaldy 05-27-2009, 03:11 PM #7 Liz Registered User Join Date: May 2009 Posts: 6 Thanks: 0 Thanked

On the equality of derivatives of two functions. Do you know how I can resolve this error? Debugging is easier when you have a database to play with. One benefit of that approach is you could avoid problems due to value delimiters.

However, in some cases financial institutions require reducing ALL numeric values to a specific number of decimal places. In this case it wasn't so; the error pretty much said what the problem is. Whether you use Double or Single, floating point calculations normally keep as many decimal places as possible (15-16 digits for a Double, 7 digits for a Single).

Was This Post Helpful? 1 Back to top MultiQuote Quote + Reply #5 donnellkar New D.I.C Head Reputation: 0 Posts: 15 Joined: 28-February 12 Re: VB6 Runtime Error -2147217900 (80040e14)

Answering that question would let us know what type of connection as well as other things. Top This thread has been closed due to inactivity. CONN.Errors.Count = 0 2. My Profile | RSS | Privacy | Legal | Contact NI © 2014 National Instruments Corporation.

Thanks for adding to my reputation by clicking the scales. Yes, my password is: Forgot your password? Post your question and get tips & solutions from a community of 418,416 IT Pros & Developers. The only differences are commented out.

When I going to save data into database, at at cmdSave_Click event, VB giving me error(Error mentioned at heading)after clicking on SAVE button and Highlighting the statement which are as follows..... It takes to much time. __________________ To view links or images in signatures your post count must be 10 or greater. AM/PM2 Mar 2 '11 #2 reply P: 5 rahul more Very Very Thanx a lot debasisdas..... Previously unreserved words may become reserved in later versions of Access or Jet causing working programs to stop functioning.

All rights reserved. | Search: Advanced Forum Search Forums Programming Web Development Computers Tutorials Snippets Dev Blogs Jobs Lounge Login Join! Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. If you get this error, you can then iterate the Errors collection, use the Source property to figure out which layer of the attempt to make the connection caused the error, runtime error 2147217900 (80040e14) syntax error in INSERT INTO statement I am gettin the above error when i try to insert into a table by clickin on save button i have

But if the error is "Application-defined or object-defined error" that isn't going to be much help. The error then shuts down the application which is NEVER a good thing. If this code supports your position in your environment (error won't trap), I'd be most interested to hear about it. can u tell me how to have numeric tat takes 2decimal place (eg : 3.67)?

Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #12 astrodon New D.I.C Head Reputation: 0 Posts: 24 Joined: 14-February 09 Re: VB6 Runtime Error -2147217900 (80040e14) What is the data type of Date_Year? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote June 5th, 2012 #5 cytop View Profile View Forum Posts . I can only assume it to be some other event than by an ADODB.Connection, because CONN.Errors.Count = 0 by every strategically placed Debug.Print CONN.Errors.Count.

Please help. I'm trying to create a > recordset from an access table. I did try passing the tag values as individual parameters a couple of times in a couple of different ways.