Can anyone... Help Me solve this??????

[bluenose76]

Hi all,

Firstly may I thank all of you in advance for looking at my thread and helping me if you can.

I have created a DB that has one table that is imported from a .CSV file with approximately 2000 records.

There are a few forms that are used to view the results of Query's because I am using the code to completely hide the access window.

Within some of my fields I have no images but in others I can have up to 8 different images.

Currently when I query a record it will give me the file name of all of the images for that record. However I would like to display the images that are associated with that record as thumbnails! ( my gold plated option would also give me the opportunity to click on the thumbnail to view the full image!! but that can come later one i can get the thumbnails showing)

I have seen many threads on here that use code to display the images but for the life of me I cant get it to work with a single image let a lone up to 8 different ones.

The file extention for my images are currently .JPG but I could change that to .BMP if required.

The Northwind traders DB supplied by Microsoft has some code in it on the Employee form and many DB on this site have used something similar.

I have not personally managed to get that to work for me but i also need it to work multiple times as i wish to display up to 8 different images on one form.

If there is anyone out there who would know the code I require to make this happen then I would be really really gratefull for your help.

Thank you again in advance for any help you can give.

Best Regards
Bev

 

[Bat17]

have a look at this thread and see if it gets you started

http://www.access-programmers.co.uk/forums/showthread.php?t=108698

Peter

 

[bluenose76]

I have previousely looked at this DB but it does not have the ability to show multiple images on one form from one record.

My form will have anything from one image up to Eight images all coming from one record! It is my hope that it is possible to show all 8 at the same time.

Bev

 

[KeithG]

I would create 8 command buttons and link the availabe images to the button to display the image on the forms open event. if there is no image for the button set its visibliity to false.

 

[Bat17]

assuming that the fields are in the record then you just need to create the number of frames for the pictures needed and use the code to add a different one to each frame. use isnull to check if there is a path in the field to use.

Me!Picture.Picture1 = Me!txtPicture1
Me!Picture.Picture2 = Me!txtPicture2
Me!Picture.Picture3 = Me!txtPicture3

Peter