Originally Posted by
Helen
This is for anyone searching about the same problem.
My file is to be shared on the net with people in different countries, so attending to individual computers isn't an option.
Adding in fancy things like the reference wizard was a bit beyond me.
I found my own solution. The Now() function still works perfectly, so I could use that, but when comparing dates like
EnteredDate = Date() gives YES, but using Now() as
EnteredDate = Now() gives NO if the time component of Now() isn't midnight, which is the default time when JUST a data is entered, so that buggered that!
SOLUTION: Int(Now()) is effectively exactly the same as Date()
and Now() DOES work on the other computers. The interger part of
Now() is just the date part. The decimal part is just the time.
I tried CVDate(Now()) and it didn't do the job when doing the abovmentioned comparison. Hope this helps someone else wrestling with referencing issues and it's a bit beyond them, as it was for me.