Type mismatch error - Setting Hyperlink Base property

  • Thread starter Thread starter JohnC
  • Start date Start date
J

JohnC

I've upgraded an Access 2003 file to 2007. I'm getting a Type mismatch
error on the code used to set the Hyperlink Base value.

The error occurs on this line "For Each prpLoop In .Properties"

Here is parts of the code.

Dim dbs As DAO.Database


With dbs.Containers!Databases
With .Documents("SummaryInfo")
For Each prpLoop In .Properties
If prpLoop.Name = "Hyperlink Base" Then
prpLoop = strPath
End If
Next prpLoop
On Error GoTo 0
End With
End With

Any ideas?
Thanks much
John
 
Back
Top