Load ref libraries in real-time

[Guest]

I have an db which contains code to connect with another app (QuickBooks).
Not all users have it installed on their machines. For some reason the db
generates a runtime error stating a hiddden module (that I've never heard or
seen). I assume that it is liked to the fact that the user does not have the
app on his machine. Is there a way to connect ref library on if when a
specific button is clicked? or another approach to addressing this issue?

Is this case, error refering a hidden module... how can one track down the
source if I can't even see it in the project viewer?

Thank you as always,

Daniel P

 

[Douglas J. Steele]

While you could use the AddFromFile method of the References collection,
you'd probably be better off using Late Binding instead.

Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm