Using "Hyperlink" OR "OLE Object" Datatypes in VB/VBA

[ajames54]

I have hundreds if not thousands of documents in various formats that I
have been asked to organize in such a way as to make it easy for the
people around here to search for them and to group them based on their
own criteria.. it seems like a pretty straightforward project.

I would like to embed links to the various objects in the database
manually I can do it with either OLE or Hyperlinks but there are too
many to do this manually, and I don't want to have to manually edit the
database every time an update is needed.

I can't find any reference to code that I can use to add or edit either
of these datatypes through vb/vba, can someone please point me in the
right direction?

Thanks

[Billie Kennedy Jr]

if you have some common naming protocol for your documents you can use
something similar to this.

If Me.Docname <> "" Then
stGMR = Me.Docname

Set fs = Application.FileSearch
With fs
..LookIn = "\\Pathtodocuments\"
..FileName = stGMR + ".doc"
If .Execute > 0 Then
Me!DocLnk.Visible = True
Me.LabelDocLnk.HyperlinkAddress = "\\Pathtodocuments\" + stGMR +
".doc"

End If

End With
fs = Null
Set fs = Application.FileSearch
With fs
..LookIn = "\\Pathtodocuments"
..FileName = stGMR + ".pdf"
If .Execute > 0 Then
Me!LabelDocLnk.Visible = True
Me.LabelDocLnk.HyperlinkAddress = "\\Pathtodocuments" + stGMR +
".pdf"

End If

End With
End If

[ajames54]

Thanks, I'll give that a try..