Tuesday, September 24, 2013

Microsoft Access 2007 - VBA functions breaks with missing reference

I have had some issues with applications written in Microsoft Access 2007. I was wondering why all of a sudden this functions will break and would have missing references. Had a bit of research on this error and find this URL from Microsoft :

Visual Basic for Applications (VBA) functions break in a database with missing references


The resolution the page had to remove the missing reference is to follow these steps:
  1. Open your database.
  2. Press ALT+F11 to open the Visual Basic Editor.
  3. On the Tools menu, click References.
  4. Click to clear the check box for the type library or object library marked as MISSING: .