I agree with Giorgio about attempting to compile your code and check references. I would also search your code for any user-defined function with the name Date() for instance:
Public Function Date() as Date
You might also want to make sure there are no modules that have the same name as a function or sub.
Maybe try create a new, blank Access file with a table containing a date field with a default of:
Default Value: Date()
Does this work?
Regards,
Duane
From: Giorgio Rovelli
Open a code window (Alt+F11) and check Tools > References. Are any missing?
On 07/31/2021 4:25 AM 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.
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
Tidak ada komentar:
Posting Komentar