VBA References

[Guest]

Hi everyone,

I saw an article recently that described how to programmatically check to
see if the users version of Access had then necessary VBA references
(Microsoft Office 10.0 Object Library etc) If the reference was not found,
the code would add it to the users References on startup.

Does anyone know where I can find it or point me in the right direction for
doing it ?

Cheers
Sion Smith

 

[David Lloyd]

Sion:

The following KB article shows how to check and add references in Word.
Access is very similar, using the References collection of the Application
object as well as the AddFromFile method.

http://support.microsoft.com/default.aspx?scid=kb;en-us;308340

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi everyone,

I saw an article recently that described how to programmatically check to
see if the users version of Access had then necessary VBA references
(Microsoft Office 10.0 Object Library etc) If the reference was not found,
the code would add it to the users References on startup.

Does anyone know where I can find it or point me in the right direction for
doing it ?

Cheers
Sion Smith