Format Error from MS2000 to 2007

B

Brian

I use to use the follwoing expression to extract a month -
Tilte:Format$([adjacent qery],"mmm"). I just migrated to 2007 and I now
receive an error saying that Format$ is an undefined function. I program in
design mode and know very little SQL.

Thanks
 
D

Douglas J. Steele

Format$ is still valid in Access 2007. Odds are that some other referenced
library has changed, though, so that's preventing Access from finding the
Format$ function (it's in the VBA library, which is always the last library
Access checks. If one of the other referenced libraries has a problem,
Access never gets to the VBA library.)

Go into the VB Editor and look at your references. Do any of them have
"MISSING:" in front of them? If so, pay attention to the name, unselect it,
then scroll through the list until you find the entry for that same
reference and reselect it.
 
Top