Birthdate Screw up

[MJuric]

I found a message here that showed me how to create a query
and report that would ask for a month (the input would be in the three
letter form) and then would pull out all of the people from the data
base that had birthdates in that month.
I got it working fine. However recently I must have screwed up
something because now when I run the report or query I get a
"undefined function 'format' in expression" error. The expresions in
the query are as follows.

Expr1: Format([Birth Date],"mmm")
Expr2: Format([Birth Date],"m/dd")

These expressions are then recalled in the report.

Any help woudl be appreciated

~Matt

 

[Fredg]

Matt,
The machine may have a missing reference.
Open any module in Design view.
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with Microsoft
Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access'
for the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for how to
reset a missing one.

 

[John Vinson]

However recently I must have screwed up
something because now when I run the report or query I get a
"undefined function 'format' in expression" error.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

 

[MJuric]

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
.DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

Thanks that worked. Unfortuntely I clicked one, closed Access
expecting them to be in the same order when I opened it, and couldn't
quit figure out which one I unclicked. none the less I "best guessed"
it and the report works now. I probably screwed something else up
though.

~Matt