[RESOLVED] Saving Date as NULL

Hi,
I want to save the red highlighted date as null, using VB 6 and Access 2003 as back end, my code is as under, but not giving the desired result.

Code:

---

            mSQL = "Insert into tblChqMaster Values(" & mChqMasterId & ", #" & txtDate & "#, " & fgData.TextMatrix(sRow, 4) & ", #" & txtDate & "#, " & Val(PartyId) & ", #" & txtDate & "#, " & 0 & ", '" & "Own" & "', '" & "-" & "', " & Val(UserId) & ")"
            mSQL = Replace(mSQL, "##", "NULL")
db.Execute mSQL

---

Please help me

If your date field allows null value then what I would do is mto include list of fields in your sql statement excluding the date field:

Code:

---

insert in tblChqMaster
    (fld1, fld2, fld5)
values
    (val1, val2, val5)

---

This way you can control which fields are getting values inserted. On the other hand if list of fields is omitted then the entire list is applied.

*koff*parameters*koff*koff*

-tg

Quote:

---

Originally Posted by techgnome

*koff*parameters*koff*koff*

-tg

---

I would offer you some cough drops.....

Quote:

---

Originally Posted by techgnome

*koff*parameters*koff*koff*

-tg

---

LOL ... Was that address at my "sample"? I left some work for OP to finish...

hehehe... No... it was directed at the OP... there's plenty of ways to skin this cat...

-tg

Thanks RhinoBull, issue resolved

You're welcome.