Hi everyone... this is my first message here.

I have been working in this project of mine using Access 2000. My problem is that I cannot get the function Date() working. I have looked every where for an answer but I never got it to work. I tried in 4 diferent machines running the funcion Date() and on run time I get something like #None? as the returning value.

Could someone give me a hand on this?

If I run the funcion =Now(), it does work though I do not need the time, only the date. I could change the format of the returning value of Now() though it would become a string. If I can get it to work, my program would become so much more practical, you know. More calculations could be done, less user interaction and so on...

I tried getting help on tek-tips.com but no one got it to work.

Thanks guys...

C.

Without seeing your database it's hard to answer this, but I can take a stab at it. Open any VBA code for any procedure and click on TOOLS > REFERENCES. In the references dialog box that opens, look at what you have checked. Here is what I have checked; and my DATE() function works fine.

• Visual Basic for Applications
• Microsoft Access 10.0 Object Library
• Microsoft DAO 3.6 Object Library
• OLE Automation
• Microsoft ActiveX Data Objects 2.5 Library
• Microsoft Office XP Web Components

Note that the list order is also important.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

WOWWWWWWWWWWWWWWW!!!!!!!

Apparently it works fine now!!!!!!!!!! I am amazed by it!!! It works like a charm!

Thanks a lot man!!! Thank you!!!

One more thing, would I have to set those references in every computer I put my DB on or it becomes standard for my program?

Thanks again! :D

"When a boy sits next to a girl for a hour, it feels like a minute. Though, when he sits on a hot stove for a minute, it feels like an hour. That's relativity!"
~ A. Einstein

You're welcome. :)

That should now translate to all computers, but in case it doesn't, be aware of how to fix it in case it comes up again. I'm curious... which library was it you didn't have checked before that you have checked now?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

As matter of fact, I had many references set. I unchecked the ones I knew were not necessary. The following references were not checked:

OLE Automation
Microsoft ActiveX Data Objects 2.5 Library

I belive OLE Automation is the one that was giving my trouble with Date() function. I might be wrong.

I could not find the referance Microsoft Office XP Web Components in my list. I am still on Win98 ;).

Thanks again!

"When a boy sits next to a girl for a hour, it feels like a minute. Though, when he sits on a hot stove for a minute, it feels like an hour. That's relativity!"
~ A. Einstein