Why is the Fomat function not supported in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
John said:
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.

John said:
Why is the Fomat function not supported in Access 2003?
Click to expand...
Click to expand...

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.
 
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.
Click to expand...

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
 
Tim Ferguson said:
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...
Click to expand...

No, no, no! You have to circle three times widdershins, then once
deosil.
 
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
 
Back
Top