Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Aug 8 13:27:19 CDT 2006
Marty: If I put in a debug MsgBox refCurr.Name that errors out with Method 'Name' of object 'Reference' failed, I think because there's nothing in refCurr.Name Rocky MartyConnelly wrote: > Should be References.Remove refCurr.name > needs a path string to reference not an object > > Rocky Smolin - Beach Access Software wrote: > > >> 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