pictures viewing in access

[buienxg]

Dear Friends,

We are traders of metal scrap. we have lots of material pictures on the basis of container numbers. We want make a user form where on entering the container number the relevant picture will be shown.

Guidance is needed.



Thanks and Regards

[Access_Blaster]

Dear Friends,

We are traders of metal scrap. we have lots of material pictures on the basis of container numbers. We want make a user form where on entering the container number the relevant picture will be shown.

Guidance is needed.

Thanks and Regards

I mocked up a sample database with pictures. I would suggest not embedding your pictures in the table like I did. It will grow very fast and bloat your database. I only embedded 5 pictures and after compact it was still 4.3 GBs. Look into using a path to a picture folder instead. You may have to unzip the sample before using.

[Max D]

You can put an regular image control, and use some VBA code to display image:

RegularImage.Picture = "c:\pics" + Num.Value + ".jpg"