Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date field append problems on recset.update
Message
From
03/06/2002 11:37:31
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Date field append problems on recset.update
Miscellaneous
Thread ID:
00664084
Message ID:
00664084
Views:
73
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
Map
View

Click here to load this message in the networking platform