Re: [MSAccessProfessionals] Access 2007 issue

I can add the field, but I want it to automatically update to the date the record was appended to the file.  No data entry in that field.

 

Carol

 

Sent from Mail for Windows 10

 

From: Duane Hookom
Sent: Friday, July 30, 2021 7:35 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access 2007 issue

 

Did you try without setting the default value?

 

Duane

Sent from my mobile

On Jul 30, 2021, at 9:29 PM, cash.ghwa@gmail.com wrote:



I am having a hard time adding a new field – "Date Input" to an existing file "Patterns".

 

I have successfully created this field in another database "Inventory" years ago, and it works great!  So I thought I would add that type field to "Patterns".  But all I get is an error .  I create the new field as a Date/Time field with these specs and get the message shown when trying to save the change to the database. 

 

It is driving me crazy.

 

<AE9CDBD4A2CF406E97EA45DAE8782856.jpg>

 

I have tried using several Date functions – each comes back with the same Unknown function 'Date' error.

 

Can you help, please.  THANK YOU SO MUCH. 

 

Carol Higbee