Results 1 to 7 of 7
  1. #1
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62

    add and show images in form

    hi



    i want to add images to a form in other way than i use today.

    today i use the regular image adding -i copy the address (where the image is) inside text box and i see it on my form (inside square).

    problem is when i want to remove the access file to different position - then i have to change the address of all images.

    is there a way to add an image (like attachment) so it will be built in inside the access file and also that ill be a bale to display it on the form?

    [Plus ... a little about the form ...It is a form with navigation buttons that I can flip through and see all the images displayed for all items]

    thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    There is an Attachment data type that would embed the image. Most of us don't use it since it can cause the database to exceed the 2GB limit.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,892
    If you move somewhere so can't load the images then presume you are also moving the image files?

    Changing saved path would be fairly simple with Find/Replace or UPDATE action SQL.

    Also, don't have to save entire path in text field. Save actual image name only then build full path with an expression.
    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.

  4. #4
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    thank you all

  5. #5
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    There is an Attachment data type that would embed the image. Most of us don't use it since it can cause the database to exceed the 2GB limit

    can you explain me how to do this?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,892
    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.

  7. #7
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    thank you very much

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

Similar Threads

  1. Show images on report?
    By Josha in forum Reports
    Replies: 4
    Last Post: 06-02-2020, 02:34 AM
  2. Replies: 7
    Last Post: 03-22-2020, 02:05 PM
  3. Replies: 1
    Last Post: 12-17-2012, 08:29 PM
  4. Access 2010, show images on form
    By s_hannah in forum Forms
    Replies: 2
    Last Post: 03-26-2012, 10:50 AM
  5. Replies: 17
    Last Post: 08-26-2009, 11:27 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