[AccessD] Broken Reference

William Hindman wdhindman at dejpolsystems.com
Mon Aug 7 10:50:38 CDT 2006


Rocky

...Neal Kling has a references sample mdb that I use in modified form ...you 
can run it at your app open and check for broken references since it uses no 
references itself ...it lets you fix or remove them ...no reason you 
couldn't call the function using the known reference and do whatever you 
needed to with it.

http://www.geocities.com/nealakling/index.html

William

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, August 07, 2006 10:59 AM
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
> 






More information about the AccessD mailing list