Updating records with empty date fields

[VBVines]

I have an access 97 database that has several date fields and text fields. I am using VB6 ado 2.5 to enter data into the fields. Basically text boxes and combo boxes are bound to the database by an adodc. The users don't enter dates into the date fields all the time. Some of the date fields are left blank. WHen this happens I get an error when I try to save. My save button is just an adodc1.recordset.movenext command. Any idea on how I can save updates that include recordsets with fields that have empty date fields.

Thanks aspvbwannab

 

[link9]

If I'm not mistaken, the change will have to take place in your database. You will have to change the attributes of the field so that it will accept a null value.

good luck!
Paul Prewett

 

[edderic]

With Table

!fieldDate = 0
.Update

End With Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com