Date going strange....

[Kieran]

In my database, i use the "Date()" string for autodate fields and also just to display the date in one of my forms. i created the database on my computer and then i moved it to another computer and everywhere i used "Date()", it just says "#Name?"
I put it on another two computers and the same on these as well.

Just wondering if anyone has any ideas....

Thanks

 

[Estuardo]

Kieran:

That's very strange. It just to happens when the fields has a non existen control source.
Even so, it could happen when running the app in different MS Office Verssions, try to change it to
=Date()
if the Date function is the default value of the control.

good luck

Estuardo

 

[Kieran]

Well i got it working, but didn't really fix the problem, just went a long way around....

it was happening with different versions of Access...
It seemed that my computer that i created it on was the only computer the date function was working on.

i exported everything to a new blank database and reset up all the relationships and everything and it worked. I don't know whether the database itself was corrupted or what....

Thanks fot the help anyway....

 

[Rich]

It's a classic Missing Reference problem, use the search facility here for solutions to the problem