hello p2p friends,
I think this problem has no solution.but please try.
I have a html form in which we accept the request and give few actions.
requisition is done on a single attempt and hence no problem.but
each action will be filled in different dates but in the same form.
For example each action includes
a) problem textarea(html) memo(ms access)
b) action owner textfield text
c) email id textfield text
d) target date textfield date/time
e)implementation date textfield date/time
it has more than ten actions.
In many cases the action owners may differ or even the single
owner may fill the implementation dates in more than one attempt.here
arises the problem.In MS-ACCESS we don't have provision to allow zero
length for date.
so exception(ms-access driver datatype mismatch exception) will be
caught for null values of dates. we can't give default date there,
because when the form is opened next time for updation (or just for
viewing)
the default implementation date will be displayed in the form which will
make no sense.also handling these default dates for more than ten
fields is really complex.
do you find any way to solve this problem?
Or atleast some better ideas?
if so please help.
Eagerly awaiting the reply,
--bye from priya.