Displaying photo files in a continuos form.

[Jose.M.Huerta]

I'm trying to display in a continuos form some *.jpg. I have a table
with the file path, (a photo of a person). Display these photos in a
single form is very easy, just using changing some properties at the
"current" event. But if I do it in the same way in a continous form
seems to be impossible, since all images of the form change at the same
time. I need a different image for each register. ¿How can I do it?

[David W. Fenton]

"John Marshall, MVP" <la******@stone henge.ca> wrote in
news:-d************** *************** *@magma.ca:

Very childish.

Physician, heal thyself!

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Jose.M.Huerta]

Thank you for your answer.

By reading your post i understand that i must find a control (like an
ocx one) that can display images and set its controlsource property to
the file location field. I try to find it using google, but.. i
couldn't find it. Do you know if exist such kind of control?

Thank you very much again.

[Jose.M.Huerta]

"I created an app that does this and the design I used was to avoid OLE
controls, putting
pictures in the database tables and the continuous form.

Instead I created a unbound form with an appropriate number of rows for
the form size,
created controls for each row and then populate them dynamically.
Provide the user with
"Page Down/Page Up" and "Row Down/Row Up" buttons to reload the unbound
controls. Hide
rows of controls as appropriate.

Then I stored all images in a folder under the application's installed
folder and stored
just the image file name in the database tables.

This involved a lot more coding but preventing database bloating
associated with storing
images, alleviated me from dealing with OCX controls and referenced
objects and allowed me
complete freedom in how I formatted each row.
"

I supoused that this is the only good solution, but i tryied to avoid
this hard-work :(. Seem that the only solution is to use a single form
with duplicated controls and programatically change them like if they
were registers of a continuos form.

Thank you very much for your answer.

[Mike Preston]

On 28 Nov 2005 04:08:56 -0800, Jo***********@g mail.com wrote:

Thank you for your answer.

By reading your post i understand that i must find a control (like an
ocx one) that can display images and set its controlsource property to
the file location field. I try to find it using google, but.. i
couldn't find it. Do you know if exist such kind of control?

You should be able to do it natively within Access. Try "OLE Object"
as DataType for a field in a table.

mike