Yes, they're probably related, as having a broken reference will lead to
Access not being able to find functions even if the function(s) in question
are not actually contained in the file to which the broken reference is
supposed to be pointing.
With any code module open, select Tools | References from the menu bar.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"SteveC" <scadusch@kyneton.net.au> wrote in message
news:441ea18f.0411011459.559b8176@posting.google.c om...[color=blue]
> I have just uprgraded from Office 97 to Office 2003 and have a problem
> with a database I created. When I open the database, Access reports
> that database contains missing or broken reference to file EYEDOG.OCX
> version 1. After I click OK the database opens but when I try to view
> reports which contain a TRIM function on two name fields it asks me to
> input parameter value. It was working fine before the upgrade. Are
> these two things related and is there an easy way to fix it?[/color]
