Error Message

[Guest]

I went to open my database today and got this message before it opened:
"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'IDrop.ocx' version 1.0.

The "Help" did not help me at all. I cannot run a few of my reports or the
queries that go with them. When I try to open them, I get this message:
Undefined function '[Format$] in expression.

What happened? This was not there yesterday.

Does anyone have a clue?

 

[Guest]

Hi Ronnie -

yes, you've lost a reference library. Go to modules and if there are none
create one (you don't need to enter code) then tools>references on the
toolbar menus and then look for the one that says MISSING. You might want to
do a search on your computer for Idrop.ocx to see where it went to and then
write down the file path where it was located. Then you can update the
missing reference by telling it where to find the missing file. (filepath).
If the file is missing, you might have to re-install something. Or do an
add-in. I'm not at my usual computer right now so its hard for me to give
you an exact fix if its not located. Hope this helps.

 

[John Vinson]

I went to open my database today and got this message before it opened:
"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'IDrop.ocx' version 1.0.

The "Help" did not help me at all. I cannot run a few of my reports or the
queries that go with them. When I try to open them, I get this message:
Undefined function '[Format$] in expression.

What happened? This was not there yesterday.

Does anyone have a clue?

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

If the MISSING refence is to IDrop.ocx, as is likely, try just
deleting the reference and see if your database still works correctly.
It may be that at some point you used an add-in named IDrop, and that
add-in is no longer available on your computer.

The Format$ error is arising because if *any* reference is broken or
missing, *all other* references - including the built-in VBA functions
like Format() - can get messed up.

John W. Vinson[MVP]