undefined function 'date' in expression - Still not solved!

[Bridget]

I have resolved any missing references in VBA, but I still
can not create a query or a default value in a form using
Date() or Format...I can the above error.

Does anyone have any idea what I could be missing?

 

[Mark Phillipson]

Hi,

Just a thought...

Does your project reference an Add-In which in turn has missing references?

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Van T. Dinh]

Checking for missing References only is not enough occasionally: The
References Collection may be corrupted which doesn't mark any References as
"MISSING" but References are still not linked correctly into your database.

See Douglas J. Steele's article for more comprehensive fixes:

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

especially the method of deselecting a Reference, getting out, getting in
the References Dialog again and re-selecting the Reference.

 

[bridget]

It's a straight db...no problem on several others PCs, but
a few others just won't acknowledge these functions. I am
completely frustrated with this and don't understand what
is missing.