images on form og subform

  • Thread starter Thread starter Jesper F
  • Start date Start date
J

Jesper F

I'm making a client database where I need to attach a number of images to
each record.
If I use a subform with a continous form, the images in the subform will
only show when each form in the subform is active. That means that if say 10
images are attached to the main record, one can't get an overview of the 10
images without specifically clicking on each section of the continous
subform. I'm using unbound image frames for displaying the images.

Is there a good way to improve on this?
Or are there some good examples out there showing how to handle forms with
several images on them?
Thanks for any help.
 
Jesper F said:
I'm making a client database where I need to attach a number of
images to each record.
If I use a subform with a continous form, the images in the subform
will only show when each form in the subform is active. That means
that if say 10 images are attached to the main record, one can't get
an overview of the 10 images without specifically clicking on each
section of the continous subform. I'm using unbound image frames for
displaying the images.

Is there a good way to improve on this?
Or are there some good examples out there showing how to handle forms
with several images on them?
Thanks for any help.
Click to expand...

As long as you are using a continuous subform, the unbound image control
on that subform is only going to show the image for the current record,
even though it is repeated multiple times. If you stored the images in
the database and used a bound object frame to display them, then you
wouldn't have this problem -- but then you'd have to deal with the
massive bloating caused by storing images in an Access database. I
don't recommend that except in special circumstances.

One approach you might take is to have a set of 10 separate, numbered,
unbound image controls on your form -- named, for example, imgPic1,
imgPic2, ... imgPic10 -- and have your own logic to load up these
controls with the picture data to be displayed for the current main
record. Have your own buttons to page forward and backward through the
available pictures for the current main record, showing up to 10 at a
time in these controls. If there are fewer than 10 pictures for a given
"page", then hide the image controls you don't need.

I did something like this some time ago, just as a test, and it worked
pretty well.
 
Back
Top