undefined function 'Date' in expression - Help!

[Bridget]

I have a bizarre problem. I have a query that uses this
criteria for field Print Date:

=Date()-1

On 4 PCs this is no problem...but on 3 it gives the error
listed above.

I also have a form that contains an unbound textbox that
uses the default value of Date(). Again, works fine for 4
PCs, but the others give "#Name?" in the box.

What am I missing?

I'm having to create workarounds and it's becoming a mess!

 

[SimonB]

I am having a similar problem, and was told I needed to
fix a broken reference that produced an error message on
the problem PC's.

 

[Brian Camire]

Microsoft Knowledge Base Article 208218 titled "ACC2000: VBA Functions Break
in Database with Missing References" at:

http://support.microsoft.com/support/kb/articles/Q208/2/18.ASP

may help.

 

[Bridget]

Thanks for the quick response, Brian...that took care of
it!