[AccessD] Broken Reference

Thanks.  Looks like it will do the job.

Rocky


William Hindman wrote:
> 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
>>
>>     
>
>
>
>   

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