Now, I don't know what happened, but when I added the date to the database at one point (June 9-12 is what was recorded before it wasn't used again) it mixed up the day and month, so instead of 6/9/2002 it was 9/6/2002, and therfore messed up my db.
All the did to add the date in the db was use Now(), I fixed my problem by using:
StrWhen = Month(Now()) & "/" & Day(Now()) & "/" & Year(Now()) & " " & FormatDateTime(Now(), vbLongTime)
It recorded in the db and i had no problem, but I can't really test my problem to see if it happens again. It must be some kind of random error.
I have try to turn my data to something like december 6 2002 or june 1 2002. It doesn't have a problem with them at all.
Anyone else have this problem? or know why it might do that at all? Have you fixed the problem in a better and tested way, other then mine?