Search results

Thanks JANR I tried the first one and it worked perfectly... I'll have to look into this as I don't really understand it. However I read another post where a developer stored all his dates yyyymmdd as a double ...linked to a calender you could show the date in any format you liked but use the...

Thanks Spikepl You are absolutely correct of course but how to fix it...following Mr Browne's advice I have set my regional setting to dd/MM/yyyy however the problem continues... I notice he says "delimit dates with the "#" symbol. Regardless or your regional settings, Access expects these...

Code: Dim CheckDate As Long CheckDate = DCount("[ACTUALDATE]", "tblDATEOpen", "[ACTUALDATE] = #" & Forms!frmAddIBTData_local!IBTDATE & "#") txtCheckDate.Value = CheckDate Code/ The above code keeps returning a '0'...it was working for several weeks and now suddenly stopped...even though...