Re: [MSAccessProfessionals] Access 2007 issue

For default value, you can trt:

Date()

or

=Date()

On Sat, Jul 31, 2021, 12:31 PM <cash.ghwa@gmail.com> wrote:

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

 

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116032) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_