I've got as little form that will list all the references a database
has selected in a textbox, because we all know that when you click
Tools/References in a VBA Editor window you sometimes can't see the
whole path.

My question is, is there a way to see the nice definition that the
References dialog box shows? For example, the References dialog box
shows "Microsoft Excel 10.0 Object Library", and using refItem.Name
all I see is "Excel".

Hi Manning,

Is this what you want?
Just call the Function DisplayRefInfo from a button on a form.


'Displays all the references used by the database
Public Function DisplayRef() As String
Dim intCurrRef As Integer
For intCurrRef = 1 To References.Count

DisplayRef = DisplayRef & " Name: " &
References(intCurrRef).Name & CR & _
"Full Path: " &
References(intCurrRef).FullPath & CR & _
" Broken?: " &
References(intCurrRef).IsBroken & CR & CR

Next intCurrRef

End Function

Public Function DisplayRefInfo()

DisplayRef
MsgBox DisplayRef, vbInformation, DLookup("strApplicationName",
"tblSplash") & " Reference Information"

End Function

Cheers,
Barry


On Aug 13, 9:51*am, ManningFan <manning... (AT) gmail (DOT) com> wrote:

On Fri, 13 Aug 2010 06:51:13 -0700 (PDT), ManningFan
<manningfan (AT) gmail (DOT) com> wrote:

Watch for word wrap on several lines.

Sub DebugPrintReferencesIDE()

' For the following line of code to refIDE to work a reference must be
set to
' Microsoft Visual Basic for Applications Extensibility 5.3
'Dim refIDE As VBIDE.Reference
' Or you can use late binding as per the following line
Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." &
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

Now I don't know if the runtime ships with the VBE6EXT.OLB or not. I
rather doubt it and it might not be legally redistributable.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Aug 16, 7:53*pm, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:
Tony -
This was it. I had similar code to what Barry had, but it looks
like the VBE gives you a bit more information. Thanks!