Putting Picture in database

[adifa]

Hello,



I have a full database with workers name. But right now i don't how to insert picture in to row in my accesss. Can anybody help me.

[June7]

You want to display image on form or report?

Use an Image Control. Save the image in an attachment type field or the image file path and name in a text field of table and bind Image Control to the field.

[adifa]

You want to display image on form or report?

Use an Image Control. Save the image in an attachment type field or the image file path and name in a text field of table and bind Image Control to the field.

I wanna insert on the database. Which mean every row name of worker have picture. So that when i open the form, it will display each of worker picture by name.

[June7]

Use an attachment field to embed objects in the database. http://office.microsoft.com/en-us/ac...001213852.aspx

Beware, attachments make database grow very fast.

Regardess of whether you use attachment field or external reference to image files, use an Image Control to display the image.

[adifa]

Use an attachment field to embed objects in the database. http://office.microsoft.com/en-us/ac...001213852.aspx

Beware, attachments make database grow very fast.

Regardess of whether you use attachment field or external reference to image files, use an Image Control to display the image.

How to attach the picture? I cannot find the tool.

[June7]

You need to know how to get image into attachment field? It is described in the link I reference in the 'Attach files directly to tables' section.

[adifa]

Yes. But when i try using the sample contact. I go throught the database it has the attachment. I think it work with webbase. Right now maybe i tried to convert to webbase.

[June7]

You are using the Contacts template database?

I have no experience with web database. However, what I read indicates Attachment field is compatible but only one Attachment field in table.

[adifa]

Yes i use the contact template. But it so different to create. Im still thingking how to attach the picture on the database without use the webbase

[June7]

There are two Contacts templates, one is webbased and one is not. Why is the webbase an issue? What do you mean by 'so different to create'? It is already created. What exactly are you trying to do? The guidelines given for images and attachments are specific. What is the issue?

[adifa]

There are two Contacts templates, one is webbased and one is not. Why is the webbase an issue? What do you mean by 'so different to create'? It is already created. What exactly are you trying to do? The guidelines given for images and attachments are specific. What is the issue?

Ok below are the form that i wanna insert picture for each workers. The problem is is cannot do an attachment. Because it is not a webbase. and the extension file is mdb. If you don mind, can you make on simple attachment using extension .mdb

[June7]

When you view the mdb in Access 2007 or 2010 the Attachment type and Image Control with ControlSource property should be available. However, if you use those features the db will no longer be compatible with Access 2003. Dynamic display of images in 2003 requires code. Review http://office.microsoft.com/en-us/ac...001147204.aspx
Link buried in that article is http://support.microsoft.com/default...%2Dus%3B285820

Lots of examples already on the web. Not going to build for you.

Does db need to stay in mdb version? Your profile shows you are using 2010.

[adifa]

Ok i will searching and try n error. Thanks