Results 1 to 4 of 4

Thread: OLE Object

  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: OLE Object

    Hi,

    I have a list of 100 pictures in a folder and I want to link them on a table via OLE Object. Is there a way I can do this in 1 go instead of linking each picture.
    Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You don't need an OLE object. You only need a text field to hold the path to the picture or a memo field if the path is > 255 characters.

    As far as automating the connection, you'd have to have some logical way to connect each picture to each record.

    If the ID of the record matches the name of the file, you don't even need ANY fields to connect them and so you won't have to link them... not one by one nor in one process.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You can give this neat little utility I made a try: http://www.dbforums.com/showpost.php...8&postcount=40

    Take out of it what you need but it does exactly what you want to do (without storing the OLE object but instead the path to it and the ability to click on it and open it.) It has a routine to find all the files (of the type you specify and the folder you specify (including subfolders)) and automatically store them into the table and then view/sort/search them via a listing on a form. You can even click on a file in the listing and make it a desktop shortcut. There's a lot of nice goodies you can play around with in this example. All code open for you to utilize.
    Last edited by pkstormy; 08-29-08 at 10:20.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Jan 2002
    Location
    London
    Posts
    73
    Hi thanks for your help and links to example datbase.

    I tried opening the first zip file called MainMenuforStoringOpeningFiles.Zip, but could not open it due to SQL tables and link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •