PC Review


Reply
Thread Tools Rate Thread

Automatically linking OLE Objects

 
 
ckendricks7@yahoo.com
Guest
Posts: n/a
 
      18th May 2006
I have a table that contains fields (among others) for client SSN, and
an OLE object which I want to be linked to the clients photo. If I
place client photos in a specific folder, and give each photo the file
name of the client's SSN, how can I programatically, link the clients
picture to the OLE field for his particular record. I don't want to
have to go in and manually link each photo individually, as I am having
to do now

 
Reply With Quote
 
 
 
 
=?Utf-8?B?V2F5bmUtaW4tTWFuY2hlc3Rlcg==?=
Guest
Posts: n/a
 
      18th May 2006
1 Ensure that the bound OLE on the form has its format set to photo (either
use this to bring in the OLE on to the form or create a new object on the
form and format it as Photo and then bind it to the OLE field.

2 Embed the link (path) within the OLE field on the table (or use a query or
form field)

For more info search this forum for "how to display a gif or jpg picture in
a form”
When reading that thread note that it gives a method to embed the picture -
you want to "link" so on the 2nd section use the "link" button not the
"Create from new"

Hope this helps

--
Wayne




"(E-Mail Removed)" wrote:

> I have a table that contains fields (among others) for client SSN, and
> an OLE object which I want to be linked to the clients photo. If I
> place client photos in a specific folder, and give each photo the file
> name of the client's SSN, how can I programatically, link the clients
> picture to the OLE field for his particular record. I don't want to
> have to go in and manually link each photo individually, as I am having
> to do now
>
>

 
Reply With Quote
 
ckendricks7@yahoo.com
Guest
Posts: n/a
 
      18th May 2006
Thanks, but your response does not seem to answer my particular question

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Objects Humble09 Microsoft Excel Worksheet Functions 0 16th Jun 2009 03:54 PM
Linking Objects =?Utf-8?B?QlJQdGFjZWs=?= Microsoft Word Document Management 0 15th Aug 2005 11:22 PM
Linking objects docsql Microsoft Access 1 3rd May 2005 10:22 PM
Linking Objects =?Utf-8?B?Q2FibGVnaG9zdA==?= Microsoft Word Document Management 0 17th Mar 2004 02:46 PM
Re: linking objects Max Microsoft Excel Worksheet Functions 1 10th Jul 2003 10:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:18 PM.