Carlos Alberto Alves
caa at highway.com.br
Fri Mar 28 21:45:41 CST 2003
On Tue, 25 Mar 2003 23:36:16 -0700, t tom <ttom at accessyourdata.com> wrote: > Hi All > > > Does anyone know where I get info on the "Available References" found in > Access and VB. > I can use the Object Browser but there must be better documentation > somewhere! > > > TIA > Tomt > You may try this code... *** Function InfoRef() Dim msg As String Dim item_ref As Reference ' On Error Resume Next ' For Each item_ref In References If item_ref.IsBroken Then msg = "Broken reference:" & vbCrLf & item_ref.FullPath Else msg = "Reference: " & item_ref.Name & vbCrLf _ & "Location: " & item_ref.FullPath & vbCrLf & _ "Version: " & item_ref.Major & "." & item_ref.Minor & vbCrLf & _ "GUIDs of broken references:" & item_ref.Guid End If Debug.Print msg Next item_ref End Function *** HTH, -- ************************************** * Carlos Alberto Alves * * Child Neurologist * * Systems Analyst/Programmer * * Rio de Janeiro, Brazil * * mailto:caa at highway.com.br * * http://igspot.ig.com.br/forefront/ * **************************************