[AccessD] Removing a missing reference

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