Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Aug 8 13:13:53 CDT 2006
Charlotte: The IsBroken is working OK. The problem I'm encountering is when it gets to References.Remove ref - there's nothing in ref. If I put in a debug statement MsgBox ref.Name it errors out. Rocky Charlotte Foust wrote: > Rocky, > > If you search the archives, I went through references problems a couple > of years ago and beat them into submissions. You must have the code to > check in a module all by itself. It must run before any other code. It > must fully reference the VBE library. And if I recall correctly, > IsBroken isn't reliable. > > 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: Tuesday, August 08, 2006 10:46 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Removing a missing reference > > Dear List: > > Still struggling with this references thing. It seem the easiest thing > to do would be to remove the missing reference in the Open event of the > opening form in the event the app is loaded onto a machine which doesn't > have the library. However, all the code that I've seen to remove > missing references fail. Code like: > > Dim refCurr As Reference > For Each refCurr In References > If refCurr.IsBroken Then > References.Remove refCurr > End If > Next > > Seems straightforward but when it comes to the missing reference it > errors out on the .Remove line because it doesn't have a name. So. How > do you remove a missing reference when the application the reference is > referring to doesn't exist? > > 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