Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Automatically linking OLE Objects

Discussion in 'Information Technology' started by ckendricks7@yahoo.com, Jul 28, 2006.

  1. ckendricks7@yahoo.com

    ckendricks7@yahoo.com
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    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




    "ckendricks7@yahoo.com" 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
    >
    >
     
  4. ckendricks7@yahoo.com

    ckendricks7@yahoo.com
    Expand Collapse
    Guest

    Thanks, but your response does not seem to answer my particular question
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page