MartyConnelly
martyconnelly at shaw.ca
Thu Nov 4 20:54:42 CST 2004
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