"Missing or Broken References..." as Transition to 2007 from 2003

[MJ]

I have seen a number of different issues out here about broken references and
coding. While I understand that the VB has NOT changed and should not be an
issue with our conversion, I have run across a problem with "missing or
broken references to the file 'utility.mda'.

The "Show help" button was anything but helpful. Can any of the
experts/peers out here tell me how we are supposed to fix this problem?

DoCmd.TransferText acExportDelim, _
"Latechrg Phase 5 Export Spec", "Qry3_BatchFile Phase5 FINAL", _
"\\1mpfs01\Databases$\Mainframe_Files\CLPLTCG5_" & _
Right(Format(Date, "yymmdd"), 5) & ".txt", True, ""

The Date is not recognized any longer. It looks like this error may be
related to this broken reference error (see the code above). If not, can you
tell me how to fix, it would be appreciated.

Thank you in advance for your assistance.

 

[Douglas J. Steele]

Go into the VB Editor, choose Tools | References from the menu bar and
uncheck the reference to utility.mda. That's an obsolete reference from
several versions ago: presumably your application was built in some other
version and then converted to Access 2003.

The reason your functions aren't being recognized (realistically, not only
Date, but also Right and Format) is because Access looks in the VBA
reference last (this is so that you can replace VBA functions with your own
versions should you want to). Whenever Access encounters a broken reference
in its search sequence, it stops looking, so it never gets to the VBA
library to find those functions.