[AccessD] Can't delete or change missing references

Thanks Marty - I will try to use this......for the moment I can't even *type* or copy/paste into the vbe window - when I try to do so, I get error 'Error in loading dll'.

aaarrrgh....

I've tried a reset but it makes no difference. 
Kath
  ----- Original Message ----- 
  From: MartyConnelly 
  To: Access Developers discussion and problem solving 
  Sent: Friday, November 05, 2004 1:54 PM
  Subject: Re: [AccessD] Can't delete or change missing references


  Try some variation of this code to remove reference

  It tests for broken reference lists by name and path to dll etc.
  If broken removes reference
  or use commented out code to delete by name

  Sub RemoveBrokenReferences()
  Dim refCurr As Reference
  Dim intLoop As Integer

     For intLoop = References.Count To 1 Step -1
        Set refCurr = References(intLoop)
        Debug.Print References.Item(intLoop).Name & " - " & 
  References.Item(intLoop).FullPath
       
        If refCurr.IsBroken = True Then
           References.Remove refCurr
        End If
      'example forcibly remove DAO reference by name if cannot err 3109
      'DAO - C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll
     ' If References.Item(intLoop).Name = "DAO" Then
     '     References.Remove refCurr
     ' End If
     Next intLoop

  End Sub

  Kath Pelletti wrote:

  >Michael - thanks for this by the way - no luck there either. Even when I delete the form and all code referring to Frontpage I am still unable to remove or change those missing references. 
  >
  >Kath
  >  ----- Original Message ----- 
  >  From: Michael R Mattys 
  >  To: Access Developers discussion and problem solving 
  >  Sent: Thursday, November 04, 2004 3:17 PM
  >  Subject: Re: [AccessD] OT: Online Access groups
  >
  >
  >  ----- Original Message ----- 
  >  From: "Kath Pelletti" <KP at sdsonline.net>
  >  To: "Access Developers discussion and problem solving"
  >  <accessd at databaseadvisors.com>
  >  Sent: Wednesday, November 03, 2004 10:52 PM
  >  Subject: [AccessD] OT: Online Access groups
  >
  >
  >  Lonnie - just a quick OT - I notice that your post also went to other Access
  >  groups - do you find them as useful as AccessD?
  >
  >  Kath
  >    ----- Original Message ----- 
  >    From: Lonnie Johnson
  >    To: 'MS-ACCESS-L at lists.missouri.edu' ; AccessDevelopers ; ms_access ;
  >  AccessD solving'
  >
  >
  >  Now hold on there, Kath, let's see ... um, hm ... try this:
  >
  >  Application.SaveAsText acForm, "FormName", "DesiredPath"
  >
  >  I'm thinking that if there's a FrontPage control on this form that
  >  you can just delete it from the text file, delete the form, remove the
  >  bad ref, and then import that file right back in as a form.
  >
  >  ----
  >
  >  Michael R. Mattys
  >  Mattys MapLib for Microsoft MapPoint
  >  http://www.mattysconsulting.com
  >
  >  -- 
  >  _______________________________________________
  >  AccessD mailing list
  >  AccessD at databaseadvisors.com
  >  http://databaseadvisors.com/mailman/listinfo/accessd
  >  Website: http://www.databaseadvisors.com
  >  
  >

  -- 
  Marty Connelly
  Victoria, B.C.
  Canada



  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com