By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,557 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,557 IT Pros & Developers. It's quick & easy.

Link OLE objects to Records

P: n/a
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..
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Use the application.filesearch method and just populate a field in the
table with the filenames.

VBA help shows you an example.

Nov 13 '05 #2

P: n/a
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
Ozzone<oz**********@yahoo.com> June 9, 2005 1:10 pm >>>

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

VBA help shows you an example.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.