Project or library not found

[R Riness]

I'm getting an error when the Date function is used in code. I have a
routine that tests for null in a field, and if null assigns the current date
to the field. I know I've had this problem before but cannot remember the
solution. I'm using Access 2000. Thanks in advance.

 

[Dirk Goldgar]

I'm getting an error when the Date function is used in code. I have a
routine that tests for null in a field, and if null assigns the
current date to the field. I know I've had this problem before but
cannot remember the solution. I'm using Access 2000. Thanks in
advance.

It sounds like you have a broken reference. Here's a good discussion of
how this happens and what to do to fix it:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[R Riness]

Thanks - I knew I'd dealt with it before, but this is the first time in a couple of years that it's come up.