woods,
Here is some code I have used. It came from Tony Toews
Code:
'---------------------------------------------------------------------------------------
' Procedure : DebugPrintReferencesIDE
' Author : Jack
' Created : 10/7/2009
' Purpose :From Tony Toews, to get a list of references in current database/project.
'------------------------------------------------------------------------------------------------
' Last Modified:
'
' Inputs: N/A
' Dependency: N/A
'------------------------------------------------------------------------------
'
Sub DebugPrintReferencesIDE()
Dim refIDE As Object
10 For Each refIDE In Access.Application.VBE.ActiveVBProject.References
20 Debug.Print IIf(refIDE.IsBroken, "Broken ", "") & _
refIDE.name & " " & vbTab & refIDE.Major & "." & refIDE.Minor & vbTab & _
refIDE.Description & vbCrLf & vbTab & vbTab & vbTab & vbTab & refIDE.FullPath & vbCrLf
30 Next refIDE
End Sub
I just ran it on my PC and database:
Output is:
Code:
VBA 4.1 Visual Basic For Applications
C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL
Access 9.0 Microsoft Access 14.0 Object Library
C:\Program Files (x86)\Microsoft Office 2010\Office14\MSACC.OLB
stdole 2.0 OLE Automation
C:\Windows\SysWOW64\stdole2.tlb
SHDocVw 1.1 Microsoft Internet Controls
C:\Windows\SysWOW64\ieframe.dll
Excel 1.7 Microsoft Excel 14.0 Object Library
C:\Program Files (x86)\Microsoft Office 2010\Office14\EXCEL.EXE
Scripting 1.0 Microsoft Scripting Runtime
C:\Windows\SysWOW64\scrrun.dll
MSXML2 6.0 Microsoft XML, v6.0
C:\Windows\SysWOW64\msxml6.dll
ADODB 6.1 Microsoft ActiveX Data Objects 6.1 Library
C:\Program Files (x86)\Common Files\System\ado\msado15.dll
Word 8.5 Microsoft Word 14.0 Object Library
C:\Program Files (x86)\Microsoft Office 2010\Office14\MSWORD.OLB
VBScript_RegExp_55 5.5 Microsoft VBScript Regular Expressions 5.5
C:\Windows\SysWOW64\vbscript.dll\3
Outlook 9.4 Microsoft Outlook 14.0 Object Library
C:\Program Files (x86)\Microsoft Office 2010\Office14\MSOUTL.OLB
MSHTML 4.0 Microsoft HTML Object Library
C:\Windows\SysWOW64\mshtml.tlb
Office 2.8 Microsoft Office 16.0 Object Library
C:\Program Files (x86)\Microsoft Office\Root\VFS\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\MSO.DLL
ADOX 2.8 Microsoft ADO Ext. 2.8 for DDL and Security
C:\Program Files (x86)\Common Files\System\ado\msadox28.tlb
WIA 1.0 Microsoft Windows Image Acquisition Library v2.0
C:\WINDOWS\System32\wiaaut.dll
WbemScripting 1.2 Microsoft WMI Scripting V1.2 Library
C:\Windows\SysWOW64\wbem\wbemdisp.TLB
WSHControllerLibrary 1.0
C:\Windows\SysWOW64\wshcon.dll
WinHttp 5.1 Microsoft WinHTTP Services, version 5.1
C:\WINDOWS\system32\winhttpcom.dll
Project1 0.0
C:\Users\mellon\Documents\jGold01_A2K.mda
Shell32 1.0 Microsoft Shell Controls And Automation
C:\Windows\SysWOW64\shell32.dll
DAO 12.0 Microsoft Office 16.0 Access database engine Object Library
C:\Program Files (x86)\Microsoft Office\Root\VFS\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\ACEDAO.DLL
VBIDE 5.3 Microsoft Visual Basic for Applications Extensibility 5.3
C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
MSScriptControl 1.0 Microsoft Script Control 1.0
C:\Windows\SysWOW64\msscript.ocx