Results 1 to 5 of 5
  1. #1
    ayounggun is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3

    Advice on this situation / requirements - linking to directories

    Hi all, I'd very much appreciate your advice with this situation. Reason being is that I don't know much about access but I'm willing to learn if I know its a good solution!



    Situation
    lots of photos are taken at different locations, dates, times for different customers. Photos are stored on a NAS by year/month-day/location/some-other-folders

    The bit that I want to ask you guys is this! Can you integrate access records with a folder that holds a location's or a customer's data? This path could be set when the other customer data is entered into the database. Ideally I want to streamline the input of non-imagery data (customer name etc.) and the access of associated imagery directory from these data.

    The alternative I'm looking at is a tagging filesystem approach with www.lunarfrog.com this may make more sense.

    Thanks very much, apologies if this is already in the forums. I tried searching but was a bit overwhelmed.
    Last edited by ayounggun; 03-27-2012 at 09:28 AM.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,193
    Depends what you mean by 'Can you integrate access records with a folder'. You can store the path to a folder as a hyperlink in a table field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ayounggun is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3
    that sounds great thanks! apologies for the vagueness - yes, I want to locate and open different folders straight from records in a database. I hoped that I would be able to input the directory path name for each record via a form when adding other database data and the path would be parsed into a clickable hyperlink.

    thanks for your reply; it is much appreciated.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,193
    If you use the Hyperlink datatype the field must be populated with the hyperlink dialog. If you store the path as string in a text field, have other options for populating the field.

    Review this for code alternatives to run the hyperlink http://allenbrowne.com/func-GoHyperlink.html
    Last edited by June7; 03-31-2012 at 11:13 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ayounggun is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3
    thanks again June7, I shall bookmark this. I am designing the table at the moment, or at least a rough one.

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

Similar Threads

  1. Rules and Requirements in a Form
    By Kirsti in forum Forms
    Replies: 9
    Last Post: 02-01-2012, 06:37 PM
  2. System Requirements for Complex Large Queries
    By nguyeda in forum Import/Export Data
    Replies: 23
    Last Post: 08-04-2011, 01:30 PM
  3. Need a help on Cross Tab type Situation
    By navensg in forum Access
    Replies: 1
    Last Post: 05-27-2011, 05:00 PM
  4. Export / Import situation
    By svcghost in forum Import/Export Data
    Replies: 7
    Last Post: 10-14-2010, 04:23 PM
  5. Importing Excel into Access with few requirements
    By pickolizac in forum Import/Export Data
    Replies: 1
    Last Post: 02-18-2009, 12:02 AM

Tags for this Thread

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 - Senior Forums