Type mismatch error - Setting Hyperlink Base property

[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

 

[Douglas J. Steele]

Make sure you've got a

Dim prpLoop As DAO.Property

 

[JohnC]

That was the problem. Thanks Doug.

John

Make sure you've got a

Dim prpLoop As DAO.Property

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele/AccessIndex.html
Co-author: "Access 2010 Solutions", published by Wiley
(no private e-mails, please)