Re: [MSAccessProfessionals] Access 2007 issue

Thank you for all the suggestions.  I did the  check references steps and came up with "MISSING utility.mda".  Well that was interesting. Now what?

 

I am just a 78 yo lady working on personal databases, nothing fancy.  I have not used Visual Basic programming for many years, and SQL is also a thing of the past.  Anyway, I do not have any user designed functions.   If I look at the inventory file, there is nothing listed as a missing utility.mda.

 

So, after about an hour of looking, checking, thinking, and more, I decided what happens if I just create a blank database  -- that was step one.  Step two was to import all info from the patterns file!!  Then I went into that new file and tried to add a new field – dateenterd – as a date/time field.  Then on down and set default value to DATE().      WORKS LIKE A CHARM!!!!!!!!!!!!.   Back to the basic sometimes works best. 

 

THANK YOU!!!  I APPRECIATE YOUR SUGGESTIONS AND DID LEARN A NEW BIT OF ACCESS 7.

 

Carol

 

Sent from Mail for Windows 10

 

From: Duane Hookom
Sent: Saturday, July 31, 2021 6:22 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access 2007 issue

 

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