Format function returns: Can't find project or library 1

[preebs]

I am developing an Access application that utilizes the "Format" function here and there in VBA code. The code works perfectly on my machine.

When I load the database on my co-workers machine, it fails on every instance of the Format function - error: Can't find project or library.

Our project references and access versions are the same. Anyone have an idea what I am missing? MS Knowledge base and TekTips keyword search lead nowhere.

 

[Maquis]

On your friend's computer, open up Access and view the code in a module (any module will do). Then on the Tools menu select "references". This will pop up a dialog box showing the available references. One of them should have the word "missing" beside it. That's the .dll that your friend needs. He can probably copy it from your PC.

Hope that does it. Maq B-)
<insert witty signature here>

 

[olekr]

The problem is that the installation files differs from PC to PC. The references are in the folder Microsoft Shared\etc. but the path before that can change depending installation.
You can check/connect in VBA using the collection &quot;References&quot;.

 

[Aivars]

Hi, Preebs!

Also you can see at thread702-99187
On this post I showed how to simplify references refreshing.
Aivars

 

[preebs]

Wow Aivars that is some nice code. My problem is fixed - thanks all.