Results 1 to 2 of 2
  1. #1
    GraemeG is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    152

    Attaching Linking Photographs froma network drive

    Hello.



    I was wondering if the following was possible.

    I have 10000+ records with a unique 'propref' number in the database.
    I also have tens of thousands of photographs on a network drive all with the propref encorporated into the title.

    is there a way to get some sort of link so that users can be directed or attached the right photographs to the right address?

    Thanks.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    At the moment what, if anything, ties the unique 'propref' number in a database table
    to the picture?

    If you know where the picture is located
    eg. //server1/folderX/picture_proprefNumber.jpg

    and you have something like

    Dim myRef as string
    myRef = " //server1/folderX/picture_"


    You can use
    application.followHyperlink myref & proprefNumber & ".jpg"

    You would get info (proprefNumber) out of the table based on some selection on a form to get to the picture. It will open with the default program you have for opening jpgs

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 06-04-2012, 05:11 PM
  2. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 03:06 PM
  3. Attaching Files
    By jlclark4 in forum Forms
    Replies: 7
    Last Post: 01-20-2011, 03:01 PM
  4. Attaching a file to a record
    By ildanach in forum Forms
    Replies: 0
    Last Post: 08-16-2008, 07:57 PM
  5. Delete query, deleting customers froma table.
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-14-2006, 11:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums