There is no object in this control

[juree]

When i start my database, im now getting this error twice when i start up and my Age function displays the compile error "Cannot find project or library"

Function age(varBirthDate As Variant) As Integer
Dim varAge As Variant
If IsNull(varBirthDate) Then age = 0: Exit Function
varAge = DateDiff("yyyy", varBirthDate, Now)
If Date < DateSerial(year(Now), month(varBirthDate), Day(varBirthDate)) Then
varAge = varAge - 1
End If
age = CInt(varAge)
End Function

...and &quot;Date&quot; is highlighted (5th line down). It asks me whether i would like to continue or go to help. When i try help it access says that the help file veenlr3.hlp cannot be found.

Whats really weird (to me anyway) is that this only happens on this machine. I created the database on another pc and it works, but when i ported it across to show the user the errors above occured. It (so far) has worked on every machine ive tried.

To combat this i just reformatted after a week of scratching my head and getting nowhere. Now to my amazment im still getting the error even though its a brand new OS (nt4 - not 98 as it was previously).

Anybody? Thoughts?

thanks =]

 

[Craig0201]

The old date problem!!!

OK, the solution for some unknown reason is to clear all of your library references, reboot and add them all back in.

Wierd but it works!

Craig

 

[juree]

cheers craig but it looks like I solved my own problem... =]

what had happened is that on the machine i was using to creat the database i had installed everything and anything to do with ms office 97 (i.e. in the installation selected all).

This had obviously installed some components that other machines did not have.

Did it on this machine and hey presto!