I've got a whack of photos from my digital camera that I'd like to link to in a database. (I can add descriptions etc.) If I can get the filenames into a table, how can I link the actual file to a db record?

I'm trying to avoid the manual "Right-Click", "Insert Object", Link, "Browse" etc..

Use the application.filesearch method and just populate a field in the
table with the filenames.

VBA help shows you an example.

Hmmm. I reviewed the help file and I don't think I made my needs clear.

Lets say I have a table called Photos, with the following fields:
PhotoID - Autonumber
Taken - Date
Location - text
WhoOf - text
Desc - memo
filename - text
Pic - OLE

I can use code to populate the filenames. What I'm trying to do is link the photo with that filename to the Pic field, so that when I use a form to go through the records, the picture will be displayed. I don't want to create all those links by hand...

Also, I was hoping this could be done in A97..
--
Brian
[color=blue][color=green][color=darkred]
>>> Ozzone<ozzonelayyer@yahoo.com> June 9, 2005 1:10 pm >>>[/color][/color][/color]
Use the application.filesearch method and just populate a field in the
table with the filenames.

VBA help shows you an example.