error 3075 "no such function"

[funda]

Hello, my problem is access 97 started not to recognise the built-in
functions suddenly, such as month() or year(). Could anyone help me how to
resolve this? Do you know what the reason might be? I need urgent help...

 

[Maurice]

Maybe a reference missing? Look under tools references in VB Editor and if
they are missing it is stated this way : MISSING
Find the appropriate library by scrolling down and check the checkbox. Save
and close the VBE

hth

 

[Ofer Cohen]

Have you looked at the answer given by Douglas in your previous post?

http://www.microsoft.com/office/com...cess&mid=2c68153d-5712-44e8-bfac-45f79627e1d4

When build in functions are not recognize in a requery, it usualy indicate
on a broken reference