Correctly showing linked image in a continous form

[Guest]

Hi

I created a continous form to show a linked image for each recrod.
Unfortunately, the only image shown is the one from the first record. In
other word, records 2 - nn show the image of the first record.

Any help will be appreciated.

Thanks,

RT

 

[Arvin Meyer [MVP]]

The way you can do this in a continuous form is to use bound ole controls.
Unfortunately, this leads to bloat. I suggest using a single form view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin,

Thanks for the reply. I just converted the table from embedded picture to
linked picture to avoid the bloating problem. Since the continuous form is
imposible to use for my purpose, I created a report to show the linked image
for each record in continuous format.

RT

 

[Larry Linson]

Arvin,

Thanks for the reply. I just converted the table from embedded picture to
linked picture to avoid the bloating problem. Since the continuous form
is
imposible to use for my purpose, I created a report to show the linked
image
for each record in continuous format.

And, have you tested to see if using Linked actually did solve the bloating
problem? Chances are, it did not. The compressed picture file embedded in
the OLE Object is only a minor part of the storage picture -- Access uses
the imaging software registered for that image file type to create a
"thumbnail" in BITMAP format and stores it in the OLE field. The "link" that
you specified only applies to the image file you provided.

No, that was not a really smart way for them to implement OLE Objects; yes,
they have had a generous number of releases, Service Packs, and updates in
which to correct it. (The Boys and Girls in Redmond may not view that as a
_defect_, but I can assure them that a vast majority of the Access-using
public does.)

Download the appropriate imaging examples from http://accdevel.tripod.com
and read the included article.

Larry Linson
Microsoft Access MVP