[RESOLVED] Saving Date as NULL

[hafizfarooq]

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.

            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

[RhinoBull]

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:

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.

[techgnome]

*koff*parameters*koff*koff*

-tg

[Zvoni]

*koff*parameters*koff*koff*

-tg

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

[RhinoBull]

*koff*parameters*koff*koff*

-tg

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

[techgnome]

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

-tg

[hafizfarooq]

Thanks RhinoBull, issue resolved

[RhinoBull]

You're welcome.