Why is the Fomat function not supported in Access 2003?

[Guest]

Why is the Fomat function not supported in Access 2003?

 

[Dirk Goldgar]

Why is the Fomat function not supported in Access 2003?

There is no "Fomat" function, but if you meant to type "Format", it is
supported. You may have a broken reference, interfering with Access's
ability to find things in the VBA library. See if Doug Steele's
instructions here help:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[Guest]

I meant "Format". I looked up your solution but the reference is not "missing".

I'm trying to use the the function to get fiscal week from a date
Format([Date],"ww",1,1).

I'm getting this error message "Undefined function "Format" in expression"

The preferences are pointing to the MSACC.OLB file.

The function works fine in all previous versions of Access.

 

[Dirk Goldgar]

I meant "Format". I looked up your solution but the reference is not
"missing".

I'm trying to use the the function to get fiscal week from a date
Format([Date],"ww",1,1).

I'm getting this error message "Undefined function "Format" in
expression"

The preferences are pointing to the MSACC.OLB file.

The function works fine in all previous versions of Access.

Why is the Fomat function not supported in Access 2003?

Sometimes no reference is recognized as MISSING, but one is broken
nonetheless. Do what the article suggests: pick a reference from among
the ones that are currently selected, note it down, uncheck it, close
the dialog, open the References dialog again, find that reference (which
will have moved), and select it again. Then close the dialog and see if
the problem has gone away.

If that doesn't fix it, please post back with more of the context in
which you are using the expression -- controlsource, calculated field,
VBA code, etc. I don't see anything wrong with your expression as you
posted it -- except that "Date" used as anything but the built-in Date()
function can confuse Access -- but there may be something I've
overlooked.

 

[Tim Ferguson]

Sometimes no reference is recognized as MISSING, but one is broken
nonetheless. Do what the article suggests: pick a reference from among
the ones that are currently selected, note it down, uncheck it, close
the dialog, open the References dialog again, find that reference (which
will have moved), and select it again. Then close the dialog and see if
the problem has gone away.

It also helps to take a black cat to a crossroads at midnight under a full
moon, turn three times to your left then three times to your right, singing
the Witches' chorus from Macbeth under your breath...


All the best


Tim F

 

[Dirk Goldgar]

It also helps to take a black cat to a crossroads at midnight under a
full moon, turn three times to your left then three times to your
right, singing the Witches' chorus from Macbeth under your breath...

No, no, no! You have to circle three times widdershins, then once
deosil.

 

[David C. Holley]

Fomat? or Format()? Format() is

 

[David C. Holley]

I typically dance around in nothing but pink undies singing 'You are the
Sun' by Lionel Ritchie to a life-size image of Martha Stewart. Oh, what
that's only when I'm trying to look up something in Microsoft Help.

David H