Multiple Image Display

[rangersedge]

I want to make a form or report that acts similar to a "bookshelf" view showing around 4 or so images in each row. When an image is clicked on it takes you to that record. Any suggestions? I know a report can be used to make rows but how do I get the images to display? They are stored in a folder and not actually embedded into the database. I have a VB code that displays the image on my forms but this doesn't work when it's a continuous form or report. It shows the same image until I click on that record then the image changes.

 

[GinaWhipp]

You really don't want to store pictures in the database, it will cause bloating which will push your database to it's max size (2 gig) very quickly. Try this link which has MANY samples of how to insert/display images in forms and reports.
http://www.granite.ab.ca/access/imagehandling.htm

You will also find information on how to get a separate image per record.

 

[rangersedge]

I already ran into the problems of storing images in the DB itself and have now turned to a folder storage and using the location address to display the images. I even incorporated a code that searches the address for me so I can move the db and images around if needed. I looked at the DBPix thing but it's pretty useless since I'm using Access 2013. I will look more at the link you sent and see what I can find. Any suggestions to narrow my search?

 

[vbaInet]

I have a VB code that displays the image on my forms but this doesn't work when it's a continuous form or report. It shows the same image until I click on that record then the image changes.

Setting the visibility property on and off in a continuous form for any control won't work. You can bind the Image Control to a field. This field will hold the path to your image.

 

[rangersedge]

I'm not understanding your point.

 

[GinaWhipp]

Actually, all you need to do is store the path to the image in the control and point the image control to that path or are you saying that is not working?

 

[vbaInet]

If you have different images to display that differ per record then the path should be store in a field and bound to the control. If it's just a one off image then I don't see the point of pointing to the image path when you can embed the image.

 

[rangersedge]

Pointing to the path works fine. But the path isn't stored in a field like normal. It is calculated with a vb code then pushed to the image control. The code is put in the form's on current event. So it displays the correct image when each record is selected as current. The problem with a continuous form is every image is the same and they all change depending on which record is the current one. That and the no column problem. Maybe if I use and unbound text box who's data equals the vb code result?

 

[vbaInet]

So you want to display the image only for the current record?

 

[GinaWhipp]

Ah, I get it... will try using the UNBOUND Text Box, never did it that way so can't say if that will work.

 

[rangersedge]

I want to display the images for all records. I want to make a shelf like display like you see in a video store

 

[vbaInet]

I don't remember the last time I went to a video store anyway I still don't understand what you mean by a "bookshelf" or "shelf like" display. A bookshelf has tonnes of books ordered by category, author or title so I don't see how it relates to what you're trying to do.

Can you show us screenshot? Unless Gina understands your point now.

 

[rangersedge]

Have you ever used the app Adilko or a Kindle? How they have images of book covers in rows...

 

[rangersedge]

similar to this

 

[vbaInet]

I use neither but I think the attached is what you're talking about?

 

[rangersedge]

Yes. Like that

 

[vbaInet]

Ok, it still takes me back to my first post. For a continuous form the Control Source of the Image control needs to be bound to a field that holds the path to the image. If the Image control isn't bound to a field, it will repeat the same image throughout.

 

[rangersedge]

Then I need to find a way to get the results of the code into a field. I can get that part. But I can't figure out how to make the form show columns of images like that

 

[vbaInet]

Ah, I thought you said you had it working as a single form?

The only way I see it working is if you use 4 subforms, each one housing an image control. Then you need to do some math to return records 1, 5, 9...etc in the main continuous form, records 1, 5, 9... will be bound to the first subform, records 2, 6, 10... to the second subform, records 3, 7, 11... to the third and records 4, 8, 12... to the fourth.

 

[rangersedge]

I get the feeling this is going to be very tricky and difficult