Display Picture for each Record in Access DB

[noob23]

I have an Access 2000 database. Each record represents a product and has an associated picture. All of the pictures are located in one central folder. I need to be able to display each picture on each record's form display.

How do I do this?

 

[Pat Hartman]

Add a column to your product table and define it as a hyperlink data type.

 

[noob23]

can you be a little more specific? what do i do after I create the column? how do I associate it with each records pic? please explain. i'm new to this stuff. thank you.

 

[Pat Hartman]

If you simply put the path of an image in the hyperlink, you can click on it to open the picture. If you want the image to be visible on the form as you scroll from item to item, use a normal text field to hold the path. Add an image control to your form and in the form's current event, set the picture property of the image control to be the path to the picture you want to show.

Me.MyImageControl.Picture = Me.ImagePath

In my case the value of ImagePath for the first record of my test table is c:\kuwaitandcairophotosEdited2\A010Towers2.JPG

 

[noob23]

ok, this is a little clearer. but what is an image control? do you mean create and image box from the toolbox?

also, can i display JPEG of GIF images in the form? or only bitmapp images?

thanks.

 

[Pat Hartman]

Yes, take the image control from the toolbox and place it on a form. Give it a nice name. Then in the Current event of the form, set the picture property.

Me.NiceNameImageControl.Picture = Me.SomeTextFieldInTheRecordsource

 

[Oldsoftboss]

Maybe go down this track...

 

[Cosmos75]

Oldsoftboss,

Pretty cool!!

 

[zzteam]

picture in access database?

I create simple database, but i have problem with browse button.
In table I create OLE object (for picture) but how I can import picture in database (not linked picture) with browse button?
Thank you in advance

Sorry for my English
please see database on http://www.geocities.com/zozobgd
mail: zozobgd@yahoo.com

 

[Oldsoftboss]

ZZteam
Use the sample I posted above, but in the properties of the image, change the picture type to embedded. I would not recommend this but, as the Db size will bloat.

Dave

 

[zzteam]

I try, but without effect
Is it big job to create browse button in DB?
If is quick process (5 min) can you please, programming for me browse button in database because I am total amateur for programming?
If you can please download from http://www.geocities.com/zozobgd
e-mail:zozobgd@yahoo.com
Thank you in advance
sorry for my English.

 

[rahulgty]

Hey I have resolved your problem. I am sending back your application on your mail. Now you can use brows button to select any picture from any folder for each record. If you wanna code, reply me............

rahulgty

 

[zzteam]

Thanks, but I need picture in database (Not linked).
pls see database on http://www.geocities.com/zozobgd
if you have any idea or solutions.

Thank you

 

[rahulgty]

zo-zo Team
I have been told you, you cant store pictures in access database. You have to keep images in seperate folder, but you can display desired picture with each record. I have been mailed you a smple...

rahulgty

 

[samy]

Hi I am interested in that too
Oldsoftboss thanks for the DB but I tried to implement the code to my video rental project but I couldn’t so if there is an explanation for adding a picture to a folder located in the root or if there any better example nice explained that’s will be heaven

 

[zzteam]

rahulgty,
You resolved my problem, but you create password in database.
How I can open database in design mode now?

Regards
zzteam

 

[rahulgty]

I am sorry,

I have emailed you again that application, without password....

rahugty

 

[bonekrusher]

Can I get a copy too?

Thanks

 

[DanG]

On the same note, If you store pictures in a folder and link to them by using the path to the picture in a text field in the table, how can you export the entire record along with the picture file?

 

[rahulgty]

Hi bonekrusner,

I have uploaded the sample.


Hi DanG,
I could not get ur question about exporting. I am just talking about displaying image on form with each record. Like with record of employee you can see his/her picture on form, thats all.

rahulgty