Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

Possible to add reference to library through VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ReMeE - 09 Nov 2006 15:11 GMT
Is it possible to add a reference to a library through VBA if the reference
isn't already added. Or am I wrong here and will the library's automaticly
added to my application on no wether what computer I will run it?
Douglas J. Steele - 09 Nov 2006 15:25 GMT
References are contained in the MDB file. If the same version of the
referenced library exists on the computer, there's no problem. If the same
version of the referenced library doesn't exist on the computer, there will
be problems (and you won't be able to set a reference anyhow if the library
doesn't exist...). It's not as though you add references to msaccess.exe.

There are 2 methods of the References collection that allow you to add
references (AddFromFile, and AddFromGUID), but I'm not really sure whether
you need them.

What exactly is the situation about which you're worried?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is it possible to add a reference to a library through VBA if the
> reference
> isn't already added. Or am I wrong here and will the library's automaticly
> added to my application on no wether what computer I will run it?
ReMeE - 09 Nov 2006 19:38 GMT
Suppose a library doesn't exist on the computer, what do I do then. Because
my application won't run without it.

> References are contained in the MDB file. If the same version of the
> referenced library exists on the computer, there's no problem. If the same
[quoted text clipped - 12 lines]
> > isn't already added. Or am I wrong here and will the library's automaticly
> > added to my application on no wether what computer I will run it?
Douglas J. Steele - 09 Nov 2006 21:40 GMT
You have to copy the missing file(s) to the computer (if you can legally),
and make sure they're properly registered.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Suppose a library doesn't exist on the computer, what do I do then.
> Because
[quoted text clipped - 21 lines]
>> > automaticly
>> > added to my application on no wether what computer I will run it?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.