DateTime Picker Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ian_journeaux@hotmail.com - 15 Aug 2005 21:38 GMT

There are many articles on the limitations of the Microsoft datetime
picker and it not accepting null values. I am probablt in the same boat
but I am not sure I understand why.

I am using Access to access a set of SQL tables. The Table has a date
field and I have configured the default value of the date field to be
Today().

In access I have a form that is bound to the table (including the date
field). WHen I use the form to add a new record, I get an error "Can't
set value to null.....".

Why is it null since I have configured the SQL Table to populate it
with today's date?

Reply to this Message

Alex Dybenko - 16 Aug 2005 08:10 GMT

Hi,
the problem with this control that it does not accept null value, that is
why you get this error.
so you can either make in unbound, and add code to update a textbox with
date after datepicker entry, or use some other solution, for example this
one:
http://www.pointltd.com/Downloads/Details.asp?dlID=32

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> There are many articles on the limitations of the Microsoft datetime
> picker and it not accepting null values. I am probablt in the same boat
[quoted text clipped - 10 lines]
> Why is it null since I have configured the SQL Table to populate it
> with today's date?

Reply to this Message