Forms & Pictures (1 Viewer)

[Hydra427]

What is the best way to store pictures on a form. I have close to 5,000 pictures that I want to store in my database. On the form that I am using I show a main picture, front, left, rear, right, base, & box. I would like the pictures to display as soon as I open the form. Right now I have to wait for them to load on each screen. I have these set up as a link to another area of my hard drive. Is this a matter of the way they are set up or just that my computer is older and a bit slower? Let me know your thoughts.

Thanks, John

 

[Simon_MT]

To begin:

Your imagres should be low-resolution aiming for about a 50KB file and about 500 pixels height or length. If the images are slow to load is generally to do with the size of the image.

don't store the images in the database but use the image referentially. But that does mean that you will need to specify the explicit (full) file name of the image, generally in a query that underpins the Form or Report.

Simon