Send Null values in Date and Integer data type ???

[drPavlovic]

Hello guys,

Does anybode has any idea, of how to do that ? I can do it very easy in VB.NET, or C#, but in Access I give up.

So, I have to take data from the form , and send it to Sub.

With data type of String , I have no any problem, use Nz funciton, end everything, goes well.

But with Date and Integer, I can not find solution.

So :

Date

Dim PensionerFromDate as Date

PensionerFromDate = IIf(IsNull(Me.txtPDPensionerFromDate) = True, ????, Me.txtPDPensionerFromDate)

(instead of ???? i tried everything .. dbNull, vbEmpty, vbNull,sqldatenull, and somtimes it works but int the table stores "12/301899")

Integer

Dim CompanyID as integer
CompanyID = IIf(Me.cboCompany.Column(0) = 0, ????? , Me.cboCompany.Column(0))

I tried here instead of ????, tu insert "", ",," , " " , Cint("") itd. itd. . but nothing works.

Has anybody any idea ?

100 x thanks in advance

 

[stopher]

Assign PensionerFromDate as datatype Variant.

Dim PensionerFromDate
or
Dim PensionerFromDate As Variant

then..
PensionerFromDate = Null

hth
Stopher