Thank you so much everyone for your assistance. I still can not find my
issue though after trying all your suggestions and reading attached websites.

I've added a random reference and removed it to refresh the references and it
still doesn't work. I've compiled it. I've looked at the references in the
original version and made sure they are all EXACTLY as the previous designer
had it. I've also tried it on a few difference computers. All to no avail.
I've still not seen any "Missing" references in this database.

MGFoster,
I do have the parenthesis on it; I've used Access pretty in depth, though I'm
definitely no Douglas Steele or Klatuu. Also I do have VBA checked in my
references. There are 2 databases because of poor design not because of any
thought of front end/back end. One does the Access queries/code and the
other is just a "scrape" that takes information from our mainframe which you
have to manually import the results into the other database.

I tried adding a Left statement in the code just to see if it would run and
it produces the same error. The following are the references I have checked:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library (I've tried it with and with out
this one)
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
and one for our mainframe for the "scrape"

Thank you all again for your assistance and any more thought you may have on
this would be GREATLY appreciated.

--
Message posted via http://www.accessmonster.com