Missing Reference

L

Laurie Eaton

Hi,

My work has a MSAccess application that works fine at work but needs some
adjustment - which I would like to do at home. But when I run the
application at home I get an error msg 'Missing or broken reference to
DomObj.tlb' and simple VBA functions such as 'Mid()' no longer work. Although
if I make another DB with 'Mid()' in the code it works fine. I have tried
reloading MSAccess but its still the same. It appears some VBA dll files have
not been correctly linked but I am stumped as to how to fix it. Any ideas
would be much appreciated.

regards
Laurie
 
A

Allen Browne

Open a code window, and choose References from the Tools menu.

Look for anything marked, "MISSING".
You will need to either uncheck that library (if it is not needed), or bring
in home and installed it with regsvr32.

More info:
http://allenbrowne.com/ser-38.html
 
L

Laurie Eaton

Brilliant..!!

I wish I hadn't waited 3 weeks wasting time before asking the question.
Thanks Allen Browne.

regards

Laurie Eaton
 
Top