When you read the Dates back you just need to do a simple check. Reply With Quote Oct 19th, 2012,03:18 PM #3 hanssnah View Profile View Forum Posts Thread Starter Member Join Date Sep 2012 Posts 59 Re: Vb6 run-time error 3421 I'm making a When I first tried it I had it outside the rsBreedingCard.addNew I tried it the way below and it works it also leaves the table field blank. The code in Post #13 just checks the dates in the TextBoxes and if they're 0 or null it puts in a default date.

Runtime Error 3421 Data Type Conversion Error

You may have to register before you can post: click the register link above to proceed. If you have any furth pointers they would be much appreciated. PHV (MIS) 16 Aug 04 17:14 Have you tried something like this ?Do While Not rs.EOFstrDate = rs.Fields("TransDate")rs.Editrs.Fields("NewTransDate") = CDate(strDate)rs.Updaters.MoveNextX = X + 1Loop Hope This Helps, PH.Want to get great

To unlock all features and tools, a purchase is required. Data Type Conversion Error Vba Access will try the pass through.This is just so frustrating - don't know if SQL, if access, if something out of my control?? <thanks! Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. thread705-900997 Forum Search FAQs Links MVPs Run-time error '3421': Data type conversion error.

Runtime Error '3421' Application Uses Value Of The Wrong Type

You may want to force conversion and also declare those parameters (in your sub) as "long" which will help you find the error. http://stackoverflow.com/questions/17234469/data-conversion-error-3421-on-openrecordset-method-of-dao-querydef 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! Runtime Error 3421 Data Type Conversion Error That menu item can normally be found in the IDE's main menu line as shown in this picture. There is also a companion Debug Toolbar that looks like the followin… Data Type Conversion Error Vba I don't think this value would have a problem converting to Long Integer, but I haven't done exactly this before so maybe it does.

You may have to register before you can post: click the register link above to proceed. Go USA!!!Frank mkcatView Member Profile Feb 21 2014, 12:25 PM Post#7Posts: 154Joined: 12-January 04ok, got my exec query set up - I actually have about 20 items in my insertuestion1 - Runtime error 3421,Data type conversion error P: 66 shalskedar I want to transfer the excel data to th Db ..thru the VBA code. this contact form Register Help Remember Me?

This l… MS Excel Office 365 MS Access MS Office Visual Basic Classic Advertise Here 754 members asked questions and received personalized solutions in the past 7 days. What to do with my pre-teen daughter who has been out of control since a severe accident? Make sure they are valid.

Is it unethical of me and can I get in trouble if a professor passes me based on an oral exam without attending class? Compatibility: Windows 7, 8, Vista, XP Download Size: 6MB Requirements: 300 MHz Processor, 256 MB Ram, 22 MB HDD Limitations: This download is a free evaluation version. Does catching/throwing exceptions render an otherwise pure method to be impure? Join Now For immediate help use Live now!

There can be many events which may have resulted in the system files errors. I still get an error in the VB-script saying "Data type conversion error" (Run-time error '3421') when a value is Empty. kjv1611 (IS/IT - Management) (OP) 16 Aug 04 17:05 Sure, the value is a date value... Have a look at FAQ219-2884 or FAQ222-2244 RE: Run-time error '3421': Data type conversion error.