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?

 

[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.

 

[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.

 

[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

 

[DanG]

Yeah, I view my salesman (350 of them) pictures on forms, but I also do mailings to their clients where I need to merge the salesman/client info(including pictures).
So, I would need to export salesman info into a mailing database to send to the print vendor.

I am not currently linking but want to change that but exporting the salesman is a must and must be addressed before I do convert.

Thank you

 

[rahulgty]

Yea DanG

you can print report of salesman info with picture and send the print to vendor.

 

[jalmari]

new image

I didn't realized how you can add new pictures. If you use new picture button it does only change the link of picture shown in subform. I tried to make new record by recordset.addnew but still it changes the picFile selected before add.

any idea?