[AccessD] Broken Reference

I'll tell you what we did to handle a similar situation with Redemption
and the CDO libraries:  We put all the direct calls to the redemption
dll into a code library compiled as an mde.  When the CDO library is
missing, the redemption library sinks the broken reference.  Our Access
code makes calls to the mde, which the regular application to go on
about its business without a broken reference, and we do a test for the
CDO library in our regular app and disable the email capabilities if
it's not present.  No calls to redemption, no broken reference errors.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Monday, August 07, 2006 8:00 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Broken Reference

Dear List:

I have a client who prints bar coded labels through an application
called Bartender (cute, huh?).  I wrote a production management system
for them which contains all the information in the db that they are
inputting manually into Bartender.  So the client asked me to add a
function to the app to run Bartender from the production system and that
is working great. 

To do this I downloaded and installed the trial version of Bartender and
so was able to set a reference to it in the VBA code so I could run
Bartender from the client's app (stuff like Public BtApp As
BarTender.Application and Public BtFormat As BarTender.Format and Set
BtApp = CreateObject("BarTender.Application")).

Problem is that the app won't run on any machine which doesn't have
Bartender loaded - it gets a broken reference error when the app opens.

So I'm wondering how to handle this.  Perhaps I unset the reference in
the Tools-->References and set it when the bar code form opens?  Or is
there a way to trap and get around this error when the app loads?

What's the best way to handle this?

MTIA,

Rocky

--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com