Brilene

[Brilene]

I am using Access 2002. I have one column named Date. On my form i have a Month Calendar. I have the column as Date/Time. My problem is it will not save the date to the access. I have The Calendar linked to the column named Date. Although it did save it one time. What am i doing wrong

[orange]

I am using Access 2002. I have one column named Date. On my form i have a Month Calendar. I have the column as Date/Time. My problem is it will not save the date to the access. I have The Calendar linked to the column named Date. Although it did save it one time. What am i doing wrong

Date is a reserved word in Access.

[Brilene]

well to someone that just started yesterday that answer is clear as mud. How can i save the date in my database?

[RuralGuy]

well to someone that just started yesterday that answer is clear as mud.

In that case as Orange suggests, do not name any object (field, form, table, query, etc.) a reserved word name or you can get unexpected results. http://www.allenbrowne.com/AppIssueBadWord.html

[Brilene]

The way to get around this word date is as i did. I changed my field name and set it to text. This seems to work.