Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Leap year in Access date field

Status
Not open for further replies.

33216CLC

Programmer
Aug 17, 2000
173
0
0
BS
Hi,

I attempted to update a record in an Access database through my vb program. However, when the pointer gets to the record where a leap year is in the date, I get a type mismatch error. I could not understand why I got this error with only this record and not the others. Then I went into Access and attempted to manually enter the date (02/29/1999). When I attempt to move to another record, I get, "The value you entered is not valid for this field."

Is there any way around this problem?

Thanks for any help.
 
I'm sorry, 1999 was not a leap year. Please ingore.
 
I'm sorry, 1999 was not a leap year. Please igore.
 
I think u want to say something else
and to this thread as u got from another pgmmers
if u have any other problem then do mails
Dinesh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top