Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Jray9242 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    14

    Display multiple photos on one form

    Is it possible to do the following

    Table 1 has links to several photos. I would like to loop through the table and have a forum that displays these on one forum.

    Something like this.

    Photo1 Photo2 Photo3
    Photo4 Photo5 Photo6

    Is this possible?

    Thank you

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    displays these
    Displays what - the location of the image file? The image itself? Assuming the latter, you'd need a field(s) in your table containing the path(s) to the image. Sounds like you have that already. When you navigate to a record, you refresh the image control(s) image path property by setting this property in the form Current event in code. If it's just the path you want, include that in the query that underlies your form and have textboxes linked to the fields containing the paths.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Have a look at the example database which I posted here https://www.access-programmers.co.uk...07&postcount=4
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    Jray9242 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    14
    Here is what my table looks like.

    What I want to do is loop through it and display 3 or 4 columns across and as many rows needed to run through the table.

    001 002 003 004
    005 006 007 008 and so on

    Click image for larger version. 

Name:	2018-04-19_19-29-30.jpg 
Views:	28 
Size:	142.0 KB 
ID:	33648

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    That's fine. Did you look at my example database?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Jray9242 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    14
    Yes, but I get the following error when I select Populate List.

    Still, when I clicked on it worked and thank you.

    What I want it to do is have them all display 3 or 4 wide without having to click on each one.

    I do have my program so it kind of works like yours.

    Not even sure if this is possible.
    Click image for larger version. 

Name:	2018-04-19_20-17-51.jpg 
Views:	26 
Size:	20.4 KB 
ID:	33649

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I expect the error may be due to a missing reference as you are using Access 2007.
    Open the VBE, go to Tools...References and note if any in the list are marked as MISSING.
    If so, it is probably due to being version specific.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	21 
Size:	11.8 KB 
ID:	33651

    There are 3 of those references (highlighted) - you will need the 12.0 version of each if marked as MISSING
    You need to browse for the equivalent version on your pc.
    Then it should be fine.
    However, JPG images don't display well in Access doe to their lossy format. PNG, GIF and BMP all work well
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    Jray9242 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    14
    Colin,

    I am using MS Office 14.0 Access database engine Object. I forgot to mention I am using Access 2010.

    I did notice on my list I had AVI files and when clicking View All, nothing happen which is correct. I deleted my videos from the table and the programmed worked.

    I see you created a report to place all the photos like i want them. Now, if I can do the same on a form, that would be excellent!

    Thanks for the help.

    Jim

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Your user info says 2007!
    It can also be done in a form.
    IIRC there should be three different forms in the example db.
    One of them does the same thing as the report.
    Not at my computer right now so can't tell you which one.

    How well did the jpg files work in Access?

    At some point I'll modify the app so it ignores file types which aren't images

    UPDATE:
    Also have a look at this link for 2 more examples written by other forum users: sneuberg & static
    https://www.access-programmers.co.uk...d.php?t=290674
    Last edited by isladogs; 04-20-2018 at 03:05 PM.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    Jray9242 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    14
    Thank you. The Jpgs were hard to see, but I am sure the ones on the form will look great. I modified my profile to reflect 2010. I guess I signed up when I had 2007.

    Here is a look what my program looks like. I'll also check out the other links as well.

    Thanks again!

    Click image for larger version. 

Name:	2018-04-20_19-55-06.jpg 
Views:	21 
Size:	174.6 KB 
ID:	33659

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Looks good. Suggest you post your database (minus the photos) for others to look at and learn from
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    Jray9242 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    14
    Here is a copy of my accdb that I am working on.

    The next thing I want to do is display the photos as a grid as some of the examples shown here. Please keep in mind that my coding sucks and created it for my own use, so I didn't follow naming convention like I would normally.


    Genealogy Cataloger.zip

  13. #13
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Doing this on form will be complicated and possibly a not editable form. Why not build multi-column report with Image control set to the 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.

  14. #14
    Jray9242 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    14
    I might look into doing it that way?

    Jim

  15. #15
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by Jray9242 View Post
    I might look into doing it that way?

    Jim
    Which takes you back to the example I provided at the start ....
    However the multi column form isn't that difficult if you follow the examples already provided
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Linking photos from data to a form
    By Monza2 in forum Access
    Replies: 6
    Last Post: 02-08-2017, 06:58 PM
  2. Replies: 11
    Last Post: 08-26-2016, 11:51 AM
  3. Display in a form multiple results
    By webisti in forum Access
    Replies: 27
    Last Post: 07-30-2014, 10:38 AM
  4. Replies: 6
    Last Post: 02-06-2013, 06:10 PM
  5. Multiple column display on form
    By RANCHLAW56 in forum Forms
    Replies: 1
    Last Post: 01-06-2011, 02:44 PM

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