Can someone please help me how to display a picture in the continous form. PLEASE HELP

H

Hung.cao

I have a continuous form which display all the record in the image
table. I like to able to click on the record and it will display the
picture in the same form. How can i do that ? Anyone have any example
that i can get. Thank you in advance and I do appreciate for all the
helps.
 
C

Carl Rapson

I have a continuous form which display all the record in the image
table. I like to able to click on the record and it will display the
picture in the same form. How can i do that ? Anyone have any example
that i can get. Thank you in advance and I do appreciate for all the
helps.

Unless the actual image is stored in the table (which is not recommended), I
don't think it's possible to display the picture within a continuous form.
Could you maybe embed the continuous form as a subform in another form, and
add an Image control to the outer form? Then, in the continuous form's
Current event, set the Picture property of the Image control to the image
you want.

HTH,

Carl Rapson
 
H

Hung.cao

hello carl,
THat's what i did but the subform to display the image is not
display.

I have a continous form which display a list of employee. When i click
on the any row on the continous form i'm doing the requery on the
subform.
In the subform --- I'm displaying the personal data record for the
current employee. But it didn't display the employee image.

In addition, when i add the new record on the continous form
(Mainform) I like to able to add the picture of new employee on the
subform that is where i'm entering the add employee info.

If you or anyone have any code please send me the link. I do
appreciate for all the help and hope i can result this soon. Thanks.
 
K

kelly d via AccessMonster.com

try switching around the roles that your main and sub form are playing.
have your main form display the image of the employee and your subform be the
continuous form of employee records.
or, if you dont want to do the main form / sub form thing then you could put
the image control in the subforms header or footer.
idea is, your image table should include a field that is a path to the
location of a picture for that employee. you dont have to make that field
visible on form but it should be there. that way each record in the
continuous form has a field (hidden of visible) that has a unique path the
location of the picture of that employee, on the forms on current you do
something like:
Form_Current()
picture1.picture = me!Field_Where_Image_Path_Is_Stored
End Sub

this is for if image control is in continuous form in the header or the
footer. if its part of a main form and the continous form is in a sub then it
would be something like:

Form_Current()
parent!picture1.picture=me!Field_Where_Image_Path_Is_Stored
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top