How to Display Multiple Images on a Tabular Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew C. - 22 Dec 2005 06:46 GMT

I would greatly appreciate if any one can tell me how to display multiple
images on a tabular form. I tried to find some samples and only found the
samples displayed image on a single form.

Code:
Private Sub Form_Current()
Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
End Sub

Signature

Thanks,
Andrew C.

Reply to this Message

Stephen Lebans - 28 Dec 2005 04:31 GMT

You would have to insert the Images into an OLE object field. In general,
this is not practical for more a few dozen images. If you GoogleGroups on
this issue you will find several threads discussing a possible workaround
using multiple Image controls.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

>I would greatly appreciate if any one can tell me how to display multiple
> images on a tabular form. I tried to find some samples and only found the
[quoted text clipped - 4 lines]
> Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
> End Sub

Reply to this Message

Andrew C. - 28 Dec 2005 20:46 GMT

First of all, thanks for your reply.

My table has over 10,000 images and I display the image by using object link
instead of storing actual image on table by OLE object field. I follow the
example of employees from Northwind and it works fine as a "single form".

Private Sub Form_Current()
Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
End Sub

However, the same approach doesn't work for "Continuous Fomrs" as the image
doesn't display correctly for the remaining records (they all show with the
image
from the first record instead of each specific image for each record).

Signature

Andrew C.

> You would have to insert the Images into an OLE object field. In general,
> this is not practical for more a few dozen images. If you GoogleGroups on
[quoted text clipped - 9 lines]
> > Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
> > End Sub

Reply to this Message

Stephen Lebans - 29 Dec 2005 04:03 GMT

Andrew please read me initial reply to your inquiry. The answer(s) stay the
same.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> First of all, thanks for your reply.
>
[quoted text clipped - 30 lines]
>> > Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
>> > End Sub

Reply to this Message

Andrew C. - 29 Dec 2005 17:26 GMT

Hi Stephen,

Thanks for your clarification and sorry to misread your initial post.

Signature

Andrew C.

> Andrew please read me initial reply to your inquiry. The answer(s) stay the
> same.
[quoted text clipped - 33 lines]
> >> > Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
> >> > End Sub

Reply to this Message

Andrew C. - 29 Dec 2005 17:26 GMT

Hi Stephen,

Thanks for your clarification and sorry to misread your initial post.

Signature

Andrew C.

> Andrew please read me initial reply to your inquiry. The answer(s) stay the
> same.
[quoted text clipped - 33 lines]
> >> > Me![ImageFrame].Picture = Me![FilePath] & Me![FileName]
> >> > End Sub

Reply to this Message