Conrad Systems Development

Conrad Systems Development



  Client List

Access Information
  App Close Button
  Macro Security
  Kick Them Off
  Database Splitting
  Combo Boxes
  Tab Colors
  Progress Bars
  Command Buttons
  Demo Database
  Form Resize
  TreeView Control
  Switchboard FAQ
  Matching Games
  Top 10 Lists
  CSD Tools
  Technical Articles
  Document Tables
  Shift Key Bypass
  Epson Printer Info
  Newsgroup Help

  Contact Us

                                 Fixing Missing References 

The arch-nemesis of Access is missing references. Listed below is some information on fixing broken or missing references in your database.

To fix the References problem follow these steps:
- Open any module in Design view.
- On the Tools menu, click References.
- At least one Reference should say "Missing". WRITE down the one(s) missing.
- Click to clear the check box for the type library or object library marked as "Missing:."
- Close the References Window box.
- Open the References Window back up. Hopefully, nothing should say Missing this time.
- Now go find that library/project(s) in the list that was missing.
- If more than one were missing, find the others and check them as well.
- Close the References box again.
- Now re-compile again. Debug--Compile.
- Hopefully you should not see any more compile errors.

If you'd like to read more about References, here's more info than you could possibly ever want to know:

References that you must set when you use Microsoft Office Access 2003: 

ACC2002: References That You Must Set When You Work with Microsoft Access: 

ACC2000: How Access 2000 Resolves Visual Basic for Applications References 

ACC2000: How to Resolve Reference Issues in an Access Database

List of the references that you must set when you work with Access 2000 or Access 97 database: 

ACC97: References That You Must Set When You Work with Microsoft Access 

ACC: VBA Functions Break in Database with Missing References


Top Top

Copyright 2005-2010 Conrad Systems Development - All Rights Reserved

This page was last updated on Sunday, September 19, 2010.

Site created with FrontPage