A adi32 Registered User. Local time Today, 15:39 Joined Dec 6, 2000 Messages 82 Jun 2, 2006 #1 i have a table with a date field with default value for new records date() when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
i have a table with a date field with default value for new records date() when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
statsman Active member Local time Today, 10:39 Joined Aug 22, 2004 Messages 2,082 Jun 2, 2006 #2 Check the table in design view. Ensure that the date field will accept duplicates. By the way is should be Date() with a capital "D".
Check the table in design view. Ensure that the date field will accept duplicates. By the way is should be Date() with a capital "D".
