inserting pictures in a form

[Guest]

hi to all.... I'm trying to insert a picture for each record of my database
(employees) so when I go to my record in the form, it shows my picture, and
when i go to someone else's record it shows his/her picture.

I was looking in this community the other day and I found something that
does that. someone put a link that shows a flower database and a picture of
the different flowers when you went to the next record.

I'm not sure what's going on but today I cannot find that "post" here... I
looked in the same way I looked before but I'm not able to find it anymore..

so, if anyone knows what I'm talking about, can you please post that link
again??? jjajaa... I don't know what's wrong with me today...

sorry for asking again something that's here already but I cannot find it.

thank you in advance for your help. I really appreciate it.

 

[Guest]

The way I have pictures on a form that change with the record is my
'employee' table has a field named 'picture' and the Data Type is OLE Object.
Put the OLE Object field on the form. To keep the database small, have the
pictures linked, as opposed to embedded, to the OLE Object field. When you
change records on the form, the picture will change. Linking the pictures,
I've found, makes it easier to update the photos as the employees age or have
a major appearance change.

You can add pictures to the form from the form quite easily. Right click in
the OLE Object field | Insert Object. . . |Create From File | .... then
follow on screen directions selecting the Link option after selecting the
photo.

 

[Guest]

thank you jim.... I have one more question... I did what you said and in the
ole object it appears the icon of the picture, and not the picture itself.
how can I make the picture appears there??? what am I doing wrong???

thank you again in advance....

 

[Guest]

In the Wizard dialog screen, uncheck the 'Display as Icon' check box. As long
as all your pictures are the same size, you can size your picture frame to
match so you can see the whole picture.

 

[Guest]

hi jim.... did what you said, and still have the same problem.... it shows
the icon... do you think that is a matter of picture size???

and when I try to change the picture, the display as Icon check box is
checked again... no ideas.....

 

[Guest]

I'll go step by step on how I import the pictures into the OLE object
control. (Picture frame/window). I use Accesss 2002.

Right-click in the OLE object control | Insert Object... | Select 'Create
from file' | Click on 'Browse...' | Select picture file from your photo
collection | OK | Check the 'Link' check box and uncheck the 'Display as
Icon' check box. | OK. Access will process the photo and display it. These
steps work in Form View.

If you are still having problems making that work, I would propose that you
try to compact and repair your database if you haven't already done so. Then
go back and try to import again.

To compact and repair: Tools | Database Utilities | Compact and Repair
Database...

 

[Guest]

jim.... I tried what you said and I think that it's a picture size problem,
because I tried with one that it's very small and it showed the picture..

thank you a lot for all your help.

 

[Guest]

Great Lula, I never thought that picture size would have much to do with it,
but apparently does. My pictures are around 500 x 400 pixels max. I learn
something new everyday.