Adding a JPG picture to a table...

[Ben]

Hi ,

I'm having a table with ~ 2000 records inside.

I want to add a picture to each record but I don't want to slow down the
DB or increase the size of it.

I want to show the picture on a for or a report.

I had try to add a OLE object field in the table but cannot see the
picture inside a form or inside a report. I see only the name of the JPG
file.

Should I use a hyperlink ?

Tks for your help....

 

[fredg]

Hi ,

I'm having a table with ~ 2000 records inside.

I want to add a picture to each record but I don't want to slow down the
DB or increase the size of it.

I want to show the picture on a for or a report.

I had try to add a OLE object field in the table but cannot see the
picture inside a form or inside a report. I see only the name of the JPG
file.

Should I use a hyperlink ?

Tks for your help....

Don't store pictures within the Access database.
Let's assume your hard drive is drive "C".
Create a folder on your hard drive, i.e. "MyPhotos".

In a regular text datatype field in your table, store the name of the
picture, i.e. "Lake Lucerne.jpg".
Name this field "ThePicture".

To display the pictures in your report's Detail section, add an Image
control to the report.
Code the Report Detail Format event:
Me.ImageName.Picture = "C:\MyPhotos\" & Me![ThePicture]

 

[Ben]

I was able to do it with OLE object but with BMP files only. JPG did not
work.

Is the OLE object part of the DB or it's getting the image from it's
location ?

Hi ,

I'm having a table with ~ 2000 records inside.

I want to add a picture to each record but I don't want to slow down
the
DB or increase the size of it.

I want to show the picture on a for or a report.

I had try to add a OLE object field in the table but cannot see the
picture inside a form or inside a report. I see only the name of the JPG
file.

Should I use a hyperlink ?

Tks for your help....

Don't store pictures within the Access database.
Let's assume your hard drive is drive "C".
Create a folder on your hard drive, i.e. "MyPhotos".

In a regular text datatype field in your table, store the name of the
picture, i.e. "Lake Lucerne.jpg".
Name this field "ThePicture".

To display the pictures in your report's Detail section, add an Image
control to the report.
Code the Report Detail Format event:
Me.ImageName.Picture = "C:\MyPhotos\" & Me![ThePicture]