Format Error from MS2000 to 2007

  • Thread starter Thread starter Brian
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upgrade from Access 2003 to 2007 1
Date Format in a Text Box 2
"mid" function error in Access 2007 runtime 4
Dir function in 2007 24
Unable to make design changes in .adp connected to SQL server 2008 1
Access #Error & Excel Pivot 0
Format$ 2
MDE problem in Access 2007 12

Back
Top