Date() Function No Longer Working

[djs45uk]

I have created a database with several forms that work perfectly on my computer.

Since copying the DB onto the network, the queries and fields associated with the date() function are not working.

Eg, the form field that should show today's date using the =date() function now just says "#name?".

Eg, the query that finds all the records < date() now reports "undefined function 'Date' in expression".

Many thanks
Daniel

 

[Betsvigi9]

Do you mean that the date function no longer works when you load the database onto your PC? Or, is it that the date function doesn't work when loaded onto other users PCs?

It may be a completely different issue, but I a similar problem, using Access 97, when upgrading from Win 98 to Win XP. It was solved by refreshing the referencing. However, I still have to be careful when making amendments to the system, because some of the PC's on which the system is used use Win 98 and the references can get mixed up.

 

[jmeadows7]

I get this error from time to tim. Somehow Access or the computer seems to lose the functions somehow.
The easiest thing to try is to replace the comctl32.ocx file in the windows\system32 directory.
Past that - make sure all of your "references" are correct and it hasn't lost any of those.

We've just put it on our intranet sit and told the users to run the zip.exe file if they get the error - it usually solves the problem.

Hope this helps.