Calling "Format" function in an expression of a query

[Guest]

I converted an older access application (*.mdb file) to Office Access 2003.
I tried to run this application on two different PCs. On both PCs Access
2003 is installed. I have a query which uses the "format" function for
getting parts of a date as string. On one PC I got the error message that the
function call "format" is not known. On the other PC everything works fine.
Why?

The expression:
Miete:Format([Mietpreis];"#.##0,00;-#.##0,00;0,00;0,00")
or
Sorting: Format([R-Mietende];"jjjjmm")

How can I pic dynamic parts of a date instead?
Of course I can write my own function, but this is much more slowlier!

With kind regards,
Stefan

 

[fredg]

I converted an older access application (*.mdb file) to Office Access 2003.
I tried to run this application on two different PCs. On both PCs Access
2003 is installed. I have a query which uses the "format" function for
getting parts of a date as string. On one PC I got the error message that the
function call "format" is not known. On the other PC everything works fine.
Why?

The expression:
Miete:Format([Mietpreis];"#.##0,00;-#.##0,00;0,00;0,00")
or
Sorting: Format([R-Mietende];"jjjjmm")

How can I pic dynamic parts of a date instead?
Of course I can write my own function, but this is much more slowlier!

With kind regards,
Stefan

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
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.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html