Linking picture files to an Access database

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ม.ค. 2014

ความคิดเห็น • 40

  • @RedFlyer350
    @RedFlyer350 3 ปีที่แล้ว +1

    Good Lord! Thank you so much for this! I was going crazy looking at all these other tutorials that WERE NOT WORKING!!! 🤪

  • @christophernoble5757
    @christophernoble5757 7 ปีที่แล้ว +1

    Helpful video!!! You should mention to make sure the file extension is added at the end of the file path...an easy thing to forget!!!

    • @lucidatedataworks3699
      @lucidatedataworks3699  7 ปีที่แล้ว

      Many thanks - will incorporate into the "reboot"

    • @andrewmayne6772
      @andrewmayne6772 6 ปีที่แล้ว

      Thanks for this comment - it was only after reading this and adding the file extension that I got it to work! It is indeed clearly shown by Lucidate Dataworks in the video - which is much appreciated as I could not find any other help anywhere on this simple but rather important capability - but as you say CN it would help first-timers like me to specifically remind to include the file extension.

  • @pjutub
    @pjutub 4 ปีที่แล้ว +1

    Thank you, it was very helpful, solved my problem!

  • @wbesack
    @wbesack 9 ปีที่แล้ว

    Awesome! Just what I was looking for and very simple to follow. Great!

    • @tbazzer
      @tbazzer 9 ปีที่แล้ว

      Thanks!

  • @astrophile5
    @astrophile5 5 ปีที่แล้ว +1

    Thank you so much Sir! very helpful!

  • @andrewfranks8328
    @andrewfranks8328 8 ปีที่แล้ว

    Thanks. That was very helpful!

  • @MrWyng
    @MrWyng 7 ปีที่แล้ว

    thanks, it was very helpful for me.... keep on sharing your knowledge... thanks again.

  • @dannicarobles1558
    @dannicarobles1558 7 ปีที่แล้ว +2

    It worked! thank you so much! It really helped me a lot! God bless.:)

  • @ozziegarcia1
    @ozziegarcia1 9 ปีที่แล้ว

    Very nice tutorial.

  • @ajdgreat0707
    @ajdgreat0707 4 ปีที่แล้ว

    thank u so much it helped me 👍👍👍

  • @ShamsQaend
    @ShamsQaend 7 ปีที่แล้ว +2

    Now, what if you have 100 record, and you want the photo field link address to have a default value from the name field ?
    Like : ="\C:\Face Photo\FIRST NAME.jpg"
    Is there a way to make "first name" a default value taken from the first name field ?

  • @andybawn1
    @andybawn1 3 ปีที่แล้ว

    doing this for 10,000 employees would take a life time

  • @svergurd3873
    @svergurd3873 2 ปีที่แล้ว +1

    I need to do just this, but you didn't tell what I need to know. I need to make a relative path to the photos in the folder, so that the access file + image folder can be moved to other computers. Unfortunately you only showed it with the absolute path. How do you make a relative path?

    • @catepilarr
      @catepilarr ปีที่แล้ว

      I would love to do that too! Have you found out how to do it?

  • @haiderabdullah7244
    @haiderabdullah7244 5 ปีที่แล้ว

    what about adding button to control the inserting or deleting of the file or image from the image control box? Would you mind to show us how to do that.

  • @btappan1
    @btappan1 5 ปีที่แล้ว

    How can this be adapted for items that have a varying number of 1 to 5 pics?

  • @MattComptonLA
    @MattComptonLA 6 ปีที่แล้ว +3

    I will be using my database on two different computers, and the path where I will store my image files will not be the same. Do you know if instead of typing the entire path of the image file, I can indicate the path is a specific folder inside the "current path", meaning wherever the database lives on the particular computer I'm using?

    • @catepilarr
      @catepilarr ปีที่แล้ว

      I would love to do that too! Have you found out how to do it?

    • @MattComptonLA
      @MattComptonLA ปีที่แล้ว

      @@catepilarr I never did. I just ended up using the database on one computer only.

  • @oscarfilms9375
    @oscarfilms9375 4 ปีที่แล้ว

    How can I add multiple pictures to one line item? like receipts particular to one merchant?

  • @sergioivanpg
    @sergioivanpg 6 ปีที่แล้ว +1

    Very helpful thanks, some problems with the audio volume.

  • @Munky332
    @Munky332 5 ปีที่แล้ว

    Is it possible to lock the size, without having to edit the photos? for example, I have a database with employees, but a few admin using their phones to take pictures of new employees, and everyone uses different phones these days (android vs apple and such) which ends up causing different sizes and resolutions, but say I decide to use the image to print out paper ID cards using the database info and a form with certain certifications, but I need the pictures to be uniform in size (height/width). How would you lock it?

  • @user-ln6mv2qw7p
    @user-ln6mv2qw7p 4 หลายเดือนก่อน

    Hi, I have created links to images in my database but I can not get them to display when I generate a Form, Query or Report.

  • @markmeyer1268
    @markmeyer1268 8 ปีที่แล้ว +1

    Thanks for posting but it didnt work in my database - I am using a front / back end scenario and the coding doesnot appear to work

  • @danelavery7436
    @danelavery7436 8 ปีที่แล้ว +3

    Torzo Tehnology - The volume on this video is very low (at least on my lap top)...It would help immensely if you could re-post this useful presentation with a better sound track.

  • @AlexanderKachowski
    @AlexanderKachowski 7 ปีที่แล้ว

    Access 2007 Table with students with images (folder address&file names) of the classes.All what I need is: filter the table in any form (form, query, report or as table) to transform it into html file with images later. I've learned how to show the images in the form. I've learned how to filter the table. How to put it all together in one table of any form, query, report or table of some sort? Could you make such tutorial please or readdress me to somebody's already made video please?

  • @metras3
    @metras3 8 ปีที่แล้ว

    Easy1 Thanks

  • @sirrahphotography5930
    @sirrahphotography5930 8 ปีที่แล้ว

    I'm having trouble having the picture show up. All I get is the file name. I'm following exactly what you are doing, but still "blank". Is there something I'm missing?

    • @ShamsQaend
      @ShamsQaend 7 ปีที่แล้ว

      Maybe you forgot to add .jpg
      It happens with me a lot.

    • @christophernoble5757
      @christophernoble5757 7 ปีที่แล้ว

      I was also having the same problem...until I added the extension for the file type. Thanks!!!
      Your video (and reply to this issue) was VERY helpful.

  • @pawznclawzpetaccommodation3015
    @pawznclawzpetaccommodation3015 5 ปีที่แล้ว +1

    were you even talking?!? can't hear a thing

  • @froggert119
    @froggert119 10 หลายเดือนก่อน

    lot of effort for a single photo

  • @nikolaskierska2740
    @nikolaskierska2740 4 ปีที่แล้ว

    it did not work :(

  • @janicesilverstein5294
    @janicesilverstein5294 6 ปีที่แล้ว +1

    Difficult to hear you.

  • @buddesatva
    @buddesatva 8 ปีที่แล้ว +1

    The information is in the video if you can tolerate the annoying presentation. Very amateurish. An outline and a a modicum of forethought would have made a big difference.

    • @tbazzer
      @tbazzer 8 ปีที่แล้ว +1

      +buddesatva - You are right - it was an improv. It was one of my first and just for trying out the software mostly - posted anyway in case people found it useful. Thanks for the feedback; I'll try and improve.

  • @joseg.teaches7916
    @joseg.teaches7916 6 ปีที่แล้ว +1

    Horrible audio!!!