Bill Feder
asked on
Opening References
I have always had this problem of getting into a situation were
I need to see the references being used by my access 2003 program
I am usually in the debug mode because I am missing a needed reference
and yet the references link is grayed out. I have to go through numerous
steps to make the link to references available again.
My question: Is there an easy way to access the list of references being used
by my program and why is it sometimes grayed out?
I need to see the references being used by my access 2003 program
I am usually in the debug mode because I am missing a needed reference
and yet the references link is grayed out. I have to go through numerous
steps to make the link to references available again.
My question: Is there an easy way to access the list of references being used
by my program and why is it sometimes grayed out?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"The Square Button" It only makes sense. I should have known this 20 years ago.
Thanks for the answer.
Bill
Thanks for the answer.
Bill
"Is there an easy way to access the list of references being used
by my program"
Yes ... as I showed above.
by my program"
Yes ... as I showed above.
Billxxxx,
Please consider reopening this question to redistribute the points. In case you don't know how do this follow the instructions below.
This way the work done by DatabaseMX also gets appreciated.
Thanks,
Mike
----------
1. Go to: https://www.experts-exchange.com/Community_Support/General
2. From the menu at the top, select Solve/As a Question.
3. For sublect add: Reopen Question
4. For the body of message enter:
https://www.experts-exchange.com/questions/28553526/Opening-References.html?anchorAnswerId=40430587#a40430587
This is the url of your question.
5. Click on Submit
Thanks,
Mike
Please consider reopening this question to redistribute the points. In case you don't know how do this follow the instructions below.
This way the work done by DatabaseMX also gets appreciated.
Thanks,
Mike
----------
1. Go to: https://www.experts-exchange.com/Community_Support/General
2. From the menu at the top, select Solve/As a Question.
3. For sublect add: Reopen Question
4. For the body of message enter:
https://www.experts-exchange.com/questions/28553526/Opening-References.html?anchorAnswerId=40430587#a40430587
This is the url of your question.
5. Click on Submit
Thanks,
Mike
Public Function mListReferences() As Boolean
Dim ref As Reference
For Each ref In Application.References
Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major & "." & ref.Minor
'If ref.Name = "MSForms" Then
'ref("MSForms").Remove
'End If
Next ref
End Function
Function ReferenceIsBroken(sRef As String) As Boolean
Dim chkRef As Reference ' A reference.
' Check through the selected references in the References dialog box.
For Each chkRef In Application.References
Debug.Print chkRef.Name ' ** Display the references
If sRef = chkRef.Name And chkRef.IsBroken Then
'if the ref matches the found ref and it is broken
ReferenceIsBroken = True
Exit Function
End If
Next
ReferenceIsBroken = False
End Function
As eghtebas noted, about the only time a the Reference toolbar item will be grayed out is if you are currently executing (maybe you stopped at a Breakpoint) OR ... you are in an MDE or ACCDE.