How to Display Multiple Images on a Tabular Form

[Guest]

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

 

[Stephen Lebans]

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.

--

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

 

[Guest]

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).

--
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
this issue you will find several threads discussing a possible workaround
using multiple Image controls.

--

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
samples displayed image on a single form.

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

 

[Stephen Lebans]

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

--

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.

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).

--
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
this issue you will find several threads discussing a possible workaround
using multiple Image controls.

--

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
samples displayed image on a single form.

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

 

[Guest]

Hi Stephen,

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

--
Andrew C.

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

--

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.

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).

--
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
this issue you will find several threads discussing a possible workaround
using multiple Image controls.

--

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
samples displayed image on a single form.

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

 

[Guest]

Hi Stephen,

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

--
Andrew C.

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

--

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.

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).

--
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
this issue you will find several threads discussing a possible workaround
using multiple Image controls.

--

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
samples displayed image on a single form.

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