Update Date To Blank

  • Thread starter Thread starter jeff Grundy
  • Start date Start date
J

jeff Grundy

How do I insert a blank value into an access97 Date/Time
field via ado?

This is waht I am attempting to do..

Update tblCLient
Set tblClient.NextShipDate = ""
Where ((tblCLient.ClientID) = SomeClientID);

It works fine when I put an actual date into
[NextShipDate] but I need to clear the value out. I would
rather not use a filler date.
 
How do I insert a blank value into an access97 Date/Time
field via ado?

This is waht I am attempting to do..

Update tblCLient
Set tblClient.NextShipDate = ""
Where ((tblCLient.ClientID) = SomeClientID);

It works fine when I put an actual date into
[NextShipDate] but I need to clear the value out. I would
rather not use a filler date.
Click to expand...

Set it to NULL rather than to a zero-length string. A date isn't a
string and won't accept "" as a valid date value.
 
Update tblCLient
Set tblClient.NextShipDate = Null
Where ((tblCLient.ClientID) = SomeClientID);
 
That answered my question "Set tblClient.NextShipDate =
Null"

I couldn't figure out how to insert the null I was trying
zero length strings and vbNull but they did not work.

thanks
-----Original Message-----
Update tblCLient
Set tblClient.NextShipDate = Null
Where ((tblCLient.ClientID) = SomeClientID);

--
Joan Wild
Microsoft Access MVP

jeff Grundy said:
How do I insert a blank value into an access97 Date/Time
field via ado?

This is waht I am attempting to do..

Update tblCLient
Set tblClient.NextShipDate = ""
Where ((tblCLient.ClientID) = SomeClientID);

It works fine when I put an actual date into
[NextShipDate] but I need to clear the value out. I would
rather not use a filler date.
Click to expand...


.
Click to expand...
 
Back
Top