Photos on Continuous Form

[DrummerDude]

I have searched everywhere for a solution to this problem.
I have a database of products that we sell that functions like an electronic
catalog. The database allows the user to drilldown into our inventory until
they find the product they're looking for. On a typical continuous form, the
database displays 4-5 product records at a time. Each record (product) has
an associated picture that must be displayed. (think about any e-commerce web
site [like Amazon.com] or [BestBuy.com] etc.) Currently, the form shows the
photo associated with the "CurrentRecord" on all displayed records. As the
CurrentRecord changes, the displayed photo changes for ALL records being
displayed.

Private Sub Form_Current()

On Error Resume Next

Me![ImageFrame].Picture = Me![OLEPath]

End Sub


Is there a way to have the form display the proper photo for all displayed
records at the same time (like on an e-commerce web site)??

I do not want to store the actual photos in the database using an OLE object
because it takes up too much real estate. The photos are stored in a
directory and the data source for the image is simply the path to where the
file is stored.

 

[Mark]

I highly doubt it. From everything I've been reading and from my own
experience, it's the way continuous forms work.

 

[Dirk Goldgar]

I have searched everywhere for a solution to this problem.
I have a database of products that we sell that functions like an
electronic catalog. The database allows the user to drilldown into
our inventory until they find the product they're looking for. On a
typical continuous form, the database displays 4-5 product records at
a time. Each record (product) has an associated picture that must be
displayed. (think about any e-commerce web site [like Amazon.com] or
[BestBuy.com] etc.) Currently, the form shows the photo associated
with the "CurrentRecord" on all displayed records. As the
CurrentRecord changes, the displayed photo changes for ALL records
being displayed.

Private Sub Form_Current()

On Error Resume Next

Me![ImageFrame].Picture = Me![OLEPath]

End Sub


Is there a way to have the form display the proper photo for all
displayed records at the same time (like on an e-commerce web site)??

I do not want to store the actual photos in the database using an OLE
object because it takes up too much real estate. The photos are
stored in a directory and the data source for the image is simply the
path to where the file is stored.

You can't do that on a continuous form using an unbound control. I can
think of two workarounds:

(1) Use an unbound form in Single Form view, with an array of controls
on it that represent one "page" of records. You would need to load and
unload these controls yourself, and handle all the paging logic.

(2) Put the image control in the form's Form Footer or Form Header
section, and make it clear to users that the image is always that of the
current record.

 

[DrummerDude]

Thanks for the response. Your answers are consistent with everything I've
read and researched . . . it's just hard to believe that, " . . . you can't
there from here . . ." I keep putting this same question out (on various
sites) and always get the same answer. One of these days I'll have to just
accept the fact that Access / VBA can't do what I'm trying to do!!

Anybody else out there have any ideas on this . . .

The "Un" believer

 

[Dirk Goldgar]

Thanks for the response. Your answers are consistent with everything
I've read and researched . . . it's just hard to believe that, " . .
. you can't there from here . . ." I keep putting this same question
out (on various sites) and always get the same answer. One of these
days I'll have to just accept the fact that Access / VBA can't do
what I'm trying to do!!

Anybody else out there have any ideas on this . . .

The "Un" believer

There may be a third-party control that will work on a continuous form;
I don't know. You may want to investigate this one:

http://www.ammara.com/index.html

I don't endorse it, haven't used it, and don't know if it works on a
continuous form or not.

 

[Dirk Goldgar]

There may be a third-party control that will work on a continuous
form; I don't know. You may want to investigate this one:

http://www.ammara.com/index.html

I don't endorse it, haven't used it, and don't know if it works on a
continuous form or not.

Nope, but they do have a paging example here, showing how to simulate
one:

http://www.ammara.com/support/samples/showsam084d.html

 

[DrummerDude]

Thanks Dirk, I'll check it out and see if I can get it to work for my
application.

Dave