Results 1 to 4 of 4
  1. #1
    Svein is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    5

    Instead of writing the whole path for each photos, but only the name; photo0000001.jpg how can I

    I have more than 100,000 photos stored in a catalog on my computer.




    they have names like this; photo0000001.jpg and so on.


    Instead of writing the whole path for each photos, but only the name; photo0000001.jpg


    How can I do this in case I move the catalog, than can I only change the path to the new catalog !



    PS... sorry about my poor english

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,325
    the table can have 2 columns for this: FOLDER, FILENAME

    c:\photos\Birthday\ , photo0000001.jpg

    then code can assemble it
    txtFile = folder & Filename

    then open txtFile


  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,366
    if the catalog is a single folder without subfolders then you can just hardcode the path or for more flexibility store the path in a table

    either
    tblCatalogPath
    CatalogPath
    C:\Catalog

    or if you have subfolders

    tblCatalogPaths
    ID....CatalogPath
    1.....C:\Catalog
    2.....C:\Catalog\2014
    3.....C:\Catalog\2014\Holidays
    etc

    then store the ID of the path in a field for your photoname

  4. #4
    Svein is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    5
    I found a solution, in the ControlSource I wrote:


    ="M:\Photos\" & [PhotoName]



    Thanks for answer and suggestions.

    Svein

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

Similar Threads

  1. Replies: 1
    Last Post: 01-30-2020, 08:48 PM
  2. Replies: 2
    Last Post: 08-22-2018, 12:15 PM
  3. Replies: 11
    Last Post: 08-26-2016, 11:51 AM
  4. Replies: 6
    Last Post: 05-27-2014, 05:41 AM
  5. Replies: 3
    Last Post: 11-24-2012, 08:56 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 - Senior Forums