calculated problem

[soundsfishy]

This is a weird one!

can some please explain why this is happening.

I have an unbound field using the following to calculate a persons age =DateDiff("yyyy",[DOB],Date())+(DateSerial(Year(Date()),Month([DOB]),Day([DOB]))>=Date())

Now my problem is that for some strange reason the field shows #Name. Ive not played around with this field since I created it and now for some reason its show #name.

The DB is on the shared drive and only I, who is also on the shared drive that doesnt have the #name appear on the form.
Why is that my computer doesnt have the problem and others do.

Ive tried creating new short cuts for user who have the problem but still exists.

Has anyone experience this problem?.

Any help would be appreciated.

 

[soundsfishy]

I got it from utteraccess forum. It is supposed to calculate a persons age based on the DOB that is inputted. I know its not the best but seemed to work Ok up until now. do you think this may be my problem?

 

[Rich]

Almost certainly a Missing Reference problem, search here for solutions.

 

[R. Hicks]

The expression will return the correct age based on the current date ...... I also have a feeling that the Date() function is causing the problem due to a library reference problem.

I use a slight variation of the expression as the Control Source of a txtbox:

= DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month(DOB), Day([DOB])))

RDH

 

[soundsfishy]

Thanks everyone for your reply.

Its highly likely that its a library referrence problem. I'll have a got at searching for the solution. If I dont have any luck, I made need to get some further advice.

 

[raskew]

Pat-

Look again at:

+ (dateserial(year(date()), Month(dob), day(dob)) > date())

It's a boolean expression.

Bob