Listbox with Photos

Hi all-

As some background, I have an Access database with a nice interface for viewing the database records. I've designed it so that the form will display photos (stored out on the network) associated with each record. To print out the record, I've designed a report equivalent of the original interface which will also display up to 6 photos.

Now, all of this works just fine- I'm just looking to improve it and I don't know what object I need to use in order to do what I want to do. What I would like to incorporate is a listbox type object which will contain little image thumbnails of all of the available photos associated with the current record. Next to each photo is a little checkbox so that the user is able to quickly view & select which photos they would like to include in the report printout.

Specifically, I'm thinking of something that is part of the "Windows Picture and FAX Viewer" program that comes with Win XP. If you open up this program and click on the Print button, it brings up the Photo Printing Wizard. When you click next, it brings up the "Picture Selection" screen. This is EXACTLY what I'm looking for!

Does anyone know what this control is and how to use it?? Can I use it through VBA? I'm sure it's some sort of ActiveX control or something but I just don't know how to look for this..

THANKS!

Steve

scole:

It would be really helpful if you would tell us what language you used to create your application?

"I have an Access database with a nice interface for viewing the database records."

Did you create this in Access or Visual Basic 6 or ? ? ?

Quote:

---

Originally Posted by AIS4U

scole:

It would be really helpful if you would tell us what language you used to create your application?

"I have an Access database with a nice interface for viewing the database records."

Did you create this in Access or Visual Basic 6 or ? ? ?

---

I'm sorry, my mistake. It's all written in plain old VBA within Access.

scole:

Well, it doesn't appear that you are getting a lot of responses to your posting. Sorry about that. Perhaps no one really knows how to do what you want to do.

I am not very familiar with Access and VBA, most of my stuff I do is in VB6. However, I have been looking through my Access Books and Developer's Handbook and I can't seem to find any control that would allow you to do this. There might be some way that you could hook into the XP Photo or Fax object through the Window's API, but that is beyond me.

One thought I did have that might work is for you is to use the line tool in Access to draw a box on your form. Then you could put several Image controls inside this box and put a thumbnail image in each Image control. You could then write code in the Image control's click_event to put the image into your report when a user clicked or double clicked on the thumbnail.

I also read that you can display bitmap images on Command Buttons. It might make for an interesting interface if you used Command Buttons. with thumbnail images on them, inside the box.

Not sure this will be of any help to you, but ....

Good Luck