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

 

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

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]

_._,_._,_

Re: [MSAccessProfessionals] Access 2007 issue

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

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

 

 

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

 

[MSAccessProfessionals] Access 2007 issue

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