how do I add photos to records?

S

shutterbugin

I need to have a different picture in each record in a single file can I do
this? How?
 
F

fredg

I need to have a different picture in each record in a single file can I do
this? How?
Click to expand...

Storing pictures in an Access database is very inefficient, and will
lead to database bloat.
I would strongly suggest you store your pictures in a folder on your
hard drive.
In the database, store just the name of the picture, i.e.
picturename.jpg, in a regular text datatype field.
To display the picture, use an Image Control.
Set it's Picture property to the field that stores the picture path.
[ImageName].Picture = "c:\foldername\" & [FieldName]
You can do that in a Form's Current event, or a Report's Detail Format
event.
 
S

shutterbugin

shutterbugin said:
I need to have a different picture in each record in a single file can I do
this? How?
Click to expand...

Thank you Rick B. and fredg, I will try those, tomorrow *yawn* I just got
access on Sunday, Im not sure I understand everything in fredg's answer, but
I'll try :eek:)
 
S

shutterbugin

Thank you fredg, but I am brand new to access and have no idea how to do what
you said. I don't plan on storing full sized photos in access, just 50 pixel
wide copies, will that cause bloat too?

fredg said:
I need to have a different picture in each record in a single file can I do
this? How?
Click to expand...

Storing pictures in an Access database is very inefficient, and will
lead to database bloat.
I would strongly suggest you store your pictures in a folder on your
hard drive.
In the database, store just the name of the picture, i.e.
picturename.jpg, in a regular text datatype field.
To display the picture, use an Image Control.
Set it's Picture property to the field that stores the picture path.
[ImageName].Picture = "c:\foldername\" & [FieldName]
You can do that in a Form's Current event, or a Report's Detail Format
event.
Click to expand...
 
Top