why this message dispaly "you tried to assign null value to a variable that is n

I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

I'm assuming that you are entering these dates in a form and not driectly
into the table. Therefore there's probably some code behind the form for that
field. Open the form in design more and look at the Event properties for that
field. Is there any code listed? If not check the properties for the entire
form.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"sharmamk1966" wrote:

I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

On Tue, 28 Jul 2009 10:06:36 GMT, "sharmamk1966" u53612@uwe wrote:

I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

What's the context? That error message appears to be one that you would get in
a VBA code module, not in a table. How are you doing the delete? What's the
context?
--

John W. Vinson [MVP]

"sharmamk1966" u53612@uwe wrote in news:99be54cf95550@uwe:

I create ms access database. In field level i get problem in
date/time field when i enter any date manually it accepted, if i
delete it display this message "you tried to assign null value to
a variable that is not a variant data type" why?

Funny you should post on this. I'm working on an app I just took
over for a client, and it was developed a long time ago (mid-90s,
Access 2). One subform has a join between two tables and when I
delete the value in the child table that joins that record to the
parent, I get exactly that error.

Is the field you're getting the error with possibly being used in a
JOIN?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

thanks for reply.
I resolve this problem at the same day after e-mail on monster. you are right
to say that
check the properies. I set the table properties and get every thing is ok.
but one query is there arise when we transfer data in date field the date
store in "MM/ddyyyy" formate where as i use and set regional date in
"dd/MM/yyyy" format. why this Happen.
regard.


Jerry Whittle wrote:
I'm assuming that you are entering these dates in a form and not driectly
into the table. Therefore there's probably some code behind the form for that
field. Open the form in design more and look at the Event properties for that
field. Is there any code listed? If not check the properties for the entire
form.
I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

--
Message posted via http://www.accessmonster.com