General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Date field append problems on recset.update
I am binding to an Access datebase with has a date field.
Access2K:
datefld: dataType = date/time
format = shortDate
VB:
ado
provider:msJet4.0, OLEDB Provider
datefld: control: mskEdBox (MS masked edit control 6.0)
mask: ##/##/##
format: mm/dd/yy
error:
Run time error'-214721887(80040e21)' Multiple step generated errors. Check status of each value.
recset.update throws the error.
I have tried many different combination of configurations on both the access side, and VB side in as far as format is concerned. My guess is that their is a conflict between masked edit definitions and the date field. It does work if I use a text field, but then I don't get the mask.
Thanks in advance
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only