Tools-References grayed out

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

A little background to my problem: I developed and
distributed a non-secured Access 2000 application about a
year ago. Since then I built a secured Access app. to
distribute. After this, I received a request for a
modification to be made to the first non-secured app.,
which I made and distributed. The only problem is that
the form I added the change to (just added a checkbox with
a couple of IF/Then/Else statements to the form-nothing
major)will run on my PC but not on the user's PCs. They
get a compile error: can't find project or library. I
assumed this was a Tools-References issue but I can't get
the Tools-References to come up in the VB code window on
the user's PCs - it is grayed out.
I read somewhere that once you setup a secured database
with Access it affects the other Access applications on
your machine -- is this true/the problem? How can I
resolve this issue with my non-secured apps?
TIA,
Al
 
Hi Al,

Don't know if this any use to you but the procedure below
should print the non-built in references to the immediate
window.

Cheers,

Stuart

Private Sub ExtractReferences()

Dim ref As Reference '[Used to loop through all
references in the database]

On Error GoTo Error_Handler

'[Loop through each reference in the database]
For Each ref In References
With ref
'[Don't include built-in references]
If .BuiltIn = False Then
'[Display information about the reference
to the immediate window]
Debug.Print .Name & " (" & .Major & "."
& .Minor & ")" & vbTab & .FullPath
End If
End With
'[Go get the next reference]
Next ref

Exit_Procedure:
'[Release object variable from memory]
Set ref = Nothing
Exit Sub

Error_Handler:
Select Case Err.Number
Case Else
MsgBox Err.Number & vbCrLf & Err.Description,
vbCritical, "EXTRACT REFERENCES"
Resume Exit_Procedure
End Select
End Sub
 
Thank you very much for your response and the code. I ran
it and picked up the references just like you said.

In the meantime, I was able to figure out what had
happened and why the Tools-References were grayed out on
the users app. I was trying to help them over the phone
and not able to see their screen. When the app. blew up
because of missing references, I told them to go to Tools
and References in the VB window... what I forgot to tell
them was to STOP the code from running before they did it!
Thus, it explains the grayed out Reference item. Once the
code was stopped they were able to add the needed
references and problem solved.

Thanks again,
Al
-----Original Message-----
Hi Al,

Don't know if this any use to you but the procedure below
should print the non-built in references to the immediate
window.

Cheers,

Stuart

Private Sub ExtractReferences()

Dim ref As Reference '[Used to loop through all
references in the database]

On Error GoTo Error_Handler

'[Loop through each reference in the database]
For Each ref In References
With ref
'[Don't include built-in references]
If .BuiltIn = False Then
'[Display information about the reference
to the immediate window]
Debug.Print .Name & " (" & .Major & "."
& .Minor & ")" & vbTab & .FullPath
End If
End With
'[Go get the next reference]
Next ref

Exit_Procedure:
'[Release object variable from memory]
Set ref = Nothing
Exit Sub

Error_Handler:
Select Case Err.Number
Case Else
MsgBox Err.Number & vbCrLf & Err.Description,
vbCritical, "EXTRACT REFERENCES"
Resume Exit_Procedure
End Select
End Sub

-----Original Message-----
A little background to my problem: I developed and
distributed a non-secured Access 2000 application about a
year ago. Since then I built a secured Access app. to
distribute. After this, I received a request for a
modification to be made to the first non-secured app.,
which I made and distributed. The only problem is that
the form I added the change to (just added a checkbox with
a couple of IF/Then/Else statements to the form-nothing
major)will run on my PC but not on the user's PCs. They
get a compile error: can't find project or library. I
assumed this was a Tools-References issue but I can't get
the Tools-References to come up in the VB code window on
the user's PCs - it is grayed out.
I read somewhere that once you setup a secured database
with Access it affects the other Access applications on
your machine -- is this true/the problem? How can I
resolve this issue with my non-secured apps?
TIA,
Al

.
Click to expand...
.
Click to expand...
 
Back
Top