Problem with Referencing Office 10.0 Object Library

[blackduck603]

I am running Access 2000 and included the Microsoft Office 10.0 Object Library in my VBA references. I am now sharing the DB on the LAN and one of my users does NOT have the Office 10.0 Object Library. We both have the same version of Access and VBA and the same OS - XP Pro SP 2.

Microsoft Access 2000 (9.0.6926 SP-3)
Microsoft Visual Basic 6.0 Version 8967 VBA Retail 6.0.8714

For some reason, my PC has the Office10 folder and libraries but the other user's PC does NOT have this. I am farily new here and whatever software is on my machine was here when I got here. I do have Visual Studio .Net 2003 installed.

Regardless, I need to figure out how to update this user with the Office 10.0 Object library.

Does anyone know if it is something that can be downloaded and installed?

 

[boblarson]

Actually, Office 10 is OfficeXP (2002) and not 2000. 2000 is Office 9. Apparently you have had some Office 2002 product (for example Visio) and they didn't. What program are you using the reference for? You can change it to late binding so you don't need the references.

 

[blackduck603]

Both PCs have Access 2000 which is 9.0 if I am not mistaken.

My PC also has Visual Studio 2003 installed and I am guessing that this is how the Office 10.0 Object Library stuff ended up on my PC.

I think have narrowed the Reference problem down to a Mid$ function call. When the code executes, I get a runtime error: Can't find object or library on the Mid$() function call. I have assumed that the MISSING Reference for the 10.0 Object Library must be the culprit.

Question:
How do I find out what Reference is required for specific functions or objects?

I have tried to find documentation on Mid$ to determine what reference needs to be included but have not had any luck.

In the meantime, I will see about changing my code to use a different function since the users will not be able to have the Office 10.0 Object Library.

Once again, I appreciate any information.

 

[blackduck603]

Both PCs have Access 2000 which is 9.0 if I am not mistaken.

My PC also has Visual Studio 2003 installed and I am guessing that this is how the Office 10.0 Object Library stuff ended up on my PC.

I think have narrowed the Reference problem down to a Mid$ function call. When the code executes, I get a runtime error: Can't find object or library on the Mid$() function call. I have assumed that the MISSING Reference for the 10.0 Object Library must be the culprit.

Question:
How do I find out what Reference is required for specific functions or objects?

I have tried to find documentation on Mid$ to determine what reference needs to be included but have not had any luck.

In the meantime, I will see about changing my code to use a different function since the users will not be able to have the Office 10.0 Object Library.

Does anyone know what the difference between Mid() and Mid$() are?

Once again, I appreciate any information.

 

[wodger]

Hi there, did you ever figure this out?

I have the same problem with an app I've resurrected. I originally created it with Office XP, it uses the LEFT function. I have office 2003 on this PC and get the "can't find project or library" error with the LEFT function highlighted in the debugger.

The only "missing" reference is the Kodak Image Admin Control, which I wouldn't have thought would cause this problem with that particular function.

Cheers

 

[boblarson]

Hi there, did you ever figure this out?

I have the same problem with an app I've resurrected. I originally created it with Office XP, it uses the LEFT function. I have office 2003 on this PC and get the "can't find project or library" error with the LEFT function highlighted in the debugger.

The only "missing" reference is the Kodak Image Admin Control, which I wouldn't have thought would cause this problem with that particular function.

Cheers

If you have a reference marked MISSING, Uncheck it anyway, close and reopen and then if it is still occuring we can go from there.