Unanswered: Expression Works in MA 97 but not 2000
I have a MA database that has to be updated to MA2000. It works fine in '97 but am being forced to upgrade for other reasons.
All expressions that include the Date() being compared to a table doesn't seem to work. The following are a couple that give off #Error in 2000 but it displays perfect in '97. Any suggestions, hints would be highly appreciative.
=dsum(nz("AmtFin","Paw5","[PicdUp]=2 and [Date]>Date()-60")
Open one of your forms in design and view the code.
Use menu option Tools|References...
See if any of them say "Missing". If you have the problem you have to browse and locate the file associated with the reference.
If none of them say "Missing" then you have some other problem but I cannot think what.
It could also be a reference to a different version of the same file.
For example, I've had that same thing happen after making a reference to outlook objects and then moving the database to a computer with a different version of outlook. The reference wasn't missing, but was now referring to the same filename, different version. The Date() and Now() functions stopped working.
StarTrekker....I believe that is what has happened. It doesn't seem to recognize the Date() function. Wherever that is mentioned it spits out the Error instead of a number. How would one go about correcting that problem? I can't seem to find the Tools--> References as pointed out in a previous post in the 2000 edition of access.