Problem with Date() function

DaneRanch

Registered User.
Local time
Today, 05:12
Joined
Dec 31, 2005
Messages
18
Since I use Access2000 my Date() function returns always the error "#name". Is there a fix for that?
I switched to using now() which is working, but it stores the date and time in the fields. Then the date searching is not accurate since the attached time increases the date by one day when I search for dates. I have to get the date() function back to work since I am also unable to format now() in a way that it kills the time portion of it. Any Ideas?
 
try
=Date()

If this is in a field in a table, format the field for the date format you prefer
 
And make sure that your field name is NOT called Date.
Rename is to something like Thisdate or Specdate etc.
 
Date()

I just read your post and have just experienced similar issues.Here is some other info that you may want to watch out for. I downloaded an updated mdb on a computer that had the database previously installed on it. I noticed of all things that the Date() and format function would produce and error on that computer but not on mine. I looked at the references and the problem was caused by Visual Basic Regular Expressions 5.3. My computer had 5.5 and no issues. I changed the 5.3 to 5.5 had the Date() and Format function now works properly.
 
Last edited:
=Date() come up with the same error "#name?" I am trying to use the function straight in a form, just to auto insert the current date.
 
I have no idea about references. I tried to look this up but do not get anywhere with it. I use only built-in functions and Macros to run the applications. No VB. I want to get to the bottom of this nuisance.....Tried again and found Microsoft Visual Basic for Applications Extensibility 5.3 whatever that means. If this is what you upgraded, how do I do that?
 
Last edited:
I guarantee the references are the problem

Open up a form in design view. In one of your controls (such as a command button) go to it's properties. Open one of your Event procedures so that you see the VB code.

Go to Tools>References. You will see a list of references. If you see Microsoft Visual basic For Applications extensibility 5.3 has a check next to it then change it to 5.5 by scrolling down in the references and choosing it.

Your problem definitely lies in here. See the attachment
 

Attachments

I checked the reference list up and down and found no 5.5 version only 5.3. I am running Access 2000 SP3 (but also SP1 did not work). Thanks for your help perhaps you are on the way to figure this out.
 
5.3 is your problem. Do you have Visual Basic For Applications in your reference list? If so, uncheck 5.3 and choose it. After changing your Reference remember to exit out of Access and then come back in.
 
I searched the reference list up and down, there is no 5.5 version available. I run Access 2000 SP3 (but SP1 did not work either). Thanks you are leading the right way I guess.
 
Visual Basic for Applications is available and checked. I unchecked the 5.3 checked again. No cure. I unchecked 5.3, closed Access and restarted no success. 5.3 checked itself on by itself.
 
Check down the list for any marked as "missing" and clear them

Peter
 
utility.mda is checked and missing. When I uncheck it and close Access it comes back with a check mark.
 
Thanks Bat17 for reminding the Missing Reference.

Are you still having the Date() issue?
 
Hallelujah, the missing utility.mda was my problem in the last 2 years. Thanks so much guys. Happy new Year.
 
Happy newyear to you too :)
Glad you have it sorted!

Peter
 
I'm having the same problem.I have 5.3 in the list but no 5.5.
Is there some update or service pack I can download to add 5.5?
 

Users who are viewing this thread

Back
Top Bottom