Format() function in Access 2003

[rlkski]

I have a date entry field in a master table set to date/time short date
I use the function Format$() to convert that date to various other formats
such as Month:Format([date],"mmmm",0,0) and it typically returns the date
item as a month
eg. 3/6/09 translates to March

When I open the database on another computer running access 2003 I get an
error message on any query using this format function "undefined format
function Format$ in expression.

even when I pair down the expression to Format([date]),"mmmm") it still fails

why does the query work on one computer and not another?

 

[Stefan Hoffmann]

hi,

When I open the database on another computer running access 2003 I get an
error message on any query using this format function "undefined format
function Format$ in expression.
even when I pair down the expression to Format([date]),"mmmm") it still fails
why does the query work on one computer and not another?

This indicates normally a reference problem. Open the database on the
failing computer, go to the VBA IDE and check the references in the Tool
menu.


mfG
--> stefan <--

 

[rlkski]

I'm not clear on where to open the VBA IDE and check refernces, could you
guide me

also,

why does the Date() function in a query criteria fail the same way?

hi,

When I open the database on another computer running access 2003 I get an
error message on any query using this format function "undefined format
function Format$ in expression.
even when I pair down the expression to Format([date]),"mmmm") it still fails
why does the query work on one computer and not another?

This indicates normally a reference problem. Open the database on the
failing computer, go to the VBA IDE and check the references in the Tool
menu.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

I'm not clear on where to open the VBA IDE and check refernces, could you
guide me
also,
why does the Date() function in a query criteria fail the same way?

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

mfG
--> stefan <--

 

[rlkski]

thank you, you learn something new everyday

hi,


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

mfG
--> stefan <--