undefined function 'Format' in expression

[Dave Smith]

hi,
i am building a database on my pc (access2000) for my laptop (access
2003 installed). i transferred the database to the laptop & everything is
fine except for the "Visit Date" text box has #Name in it. i deleted my
Default value of "Date()" & now the current date shows in that text box as
expected (i don't understand it but hey...)this didn't change the fact that
my chart wont display in normal mode, it comes up with an error "undefined
function 'Format' in expression". the chart is visible in design mode, when
i go into my properties and look in my row source line it has this
expression

SELECT (Format([VisitDate],"WW 'YY")),Max([Weight]) AS
[MaxOfWeight],Max([BodyFat]) AS [MaxOfBodyFat],Max([Exercise]) AS
[MaxOfExercise] FROM [tblVisitTable] GROUP BY (Year([VisitDate])*CLng(54)
+ DatePart("ww",[VisitDate],0)-1),(Format([VisitDate],"WW 'YY"));

i suspect it cant format each "time interval" by week & is looking for more
information in the Format but i don't know what.

i have tried deleting the chart on my laptop & going thru the chart wizard
again, hoping it would write the expression in the way it needs to see it
but the same thing happens.

the OLE class on the laptop is Microsoft Graph 2000 Chart, the Database is
running in (Access 2000 file format) in Access 2003.

hope this is enough info for someone to help me...

Dave Smith

 

[Ken Snell [MVP]]

If any of the database's references are messed up on a PC -- you can get
that error.

Try following these steps (from a post by Douglas Steele, MVP):

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
ttp://www.accessmvp.com/djsteele/AccessReferenceErrors.html

--

Ken Snell
<MS ACCESS MVP>

hi,
i am building a database on my pc (access2000) for my laptop (access
2003 installed). i transferred the database to the laptop & everything is
fine except for the "Visit Date" text box has #Name in it. i deleted my
Default value of "Date()" & now the current date shows in that text box as
expected (i don't understand it but hey...)this didn't change the fact
that
my chart wont display in normal mode, it comes up with an error "undefined
function 'Format' in expression". the chart is visible in design mode,
when
i go into my properties and look in my row source line it has this
expression

SELECT (Format([VisitDate],"WW 'YY")),Max([Weight]) AS
[MaxOfWeight],Max([BodyFat]) AS [MaxOfBodyFat],Max([Exercise]) AS
[MaxOfExercise] FROM [tblVisitTable] GROUP BY
(Year([VisitDate])*CLng(54)
+ DatePart("ww",[VisitDate],0)-1),(Format([VisitDate],"WW 'YY"));

i suspect it cant format each "time interval" by week & is looking for
more
information in the Format but i don't know what.

i have tried deleting the chart on my laptop & going thru the chart wizard
again, hoping it would write the expression in the way it needs to see it
but the same thing happens.

the OLE class on the laptop is Microsoft Graph 2000 Chart, the Database is
running in (Access 2000 file format) in Access 2003.

hope this is enough info for someone to help me...

Dave Smith

 

[Dave Smith]

thank you very much that solved it.

Dave Smith

If any of the database's references are messed up on a PC -- you can get
that error.

Try following these steps (from a post by Douglas Steele, MVP):

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
ttp://www.accessmvp.com/djsteele/AccessReferenceErrors.html

--

Ken Snell
<MS ACCESS MVP>

hi,
i am building a database on my pc (access2000) for my laptop (access
2003 installed). i transferred the database to the laptop & everything is
fine except for the "Visit Date" text box has #Name in it. i deleted my
Default value of "Date()" & now the current date shows in that text box as
expected (i don't understand it but hey...)this didn't change the fact
that
my chart wont display in normal mode, it comes up with an error "undefined
function 'Format' in expression". the chart is visible in design mode,
when
i go into my properties and look in my row source line it has this
expression

SELECT (Format([VisitDate],"WW 'YY")),Max([Weight]) AS
[MaxOfWeight],Max([BodyFat]) AS [MaxOfBodyFat],Max([Exercise]) AS
[MaxOfExercise] FROM [tblVisitTable] GROUP BY
(Year([VisitDate])*CLng(54)
+ DatePart("ww",[VisitDate],0)-1),(Format([VisitDate],"WW 'YY"));

i suspect it cant format each "time interval" by week & is looking for
more
information in the Format but i don't know what.

i have tried deleting the chart on my laptop & going thru the chart wizard
again, hoping it would write the expression in the way it needs to see it
but the same thing happens.

the OLE class on the laptop is Microsoft Graph 2000 Chart, the Database is
running in (Access 2000 file format) in Access 2003.

hope this is enough info for someone to help me...

Dave Smith