Adding pictures to my database ?

Hi there, I am a bit of a newboy to access I have a database which I wish to
have pictures.
for example: record one will have data and a picture, record two will have
different data and a diferent picture.
I am pretty sure that a picture bound frame is used, but are unable to make
it work.
Anybody able to help?
Chris

re: Adding pictures to my database ?

Chris,

You want to store your pictures in a separte file from the database. You want to
display your pictures with an image control and use the Picture property to
define the path to the picture.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"Chris Minchin" <minchin@ihug.co.nz> wrote in message
news:c7jjoa$2ub$1@lust.ihug.co.nz...[color=blue]
> Hi there, I am a bit of a newboy to access I have a database which I wish to
> have pictures.
> for example: record one will have data and a picture, record two will have
> different data and a diferent picture.
> I am pretty sure that a picture bound frame is used, but are unable to make
> it work.
> Anybody able to help?
> Chris
>
>[/color]

re: Adding pictures to my database ?

On Sun, 9 May 2004 09:33:59 +1200, "Chris Minchin"
<minchin@ihug.co.nz> wrote:

Take a look at the Employee form in the Northwind sample application.

By the way, it's impractical to store many pictures in the database.
That's a FAQ you should have no problem finding information about at
groups.google.com

-Tom.

[color=blue]
>Hi there, I am a bit of a newboy to access I have a database which I wish to
>have pictures.
>for example: record one will have data and a picture, record two will have
>different data and a diferent picture.
>I am pretty sure that a picture bound frame is used, but are unable to make
>it work.
>Anybody able to help?
>Chris
>[/color]

re: Adding pictures to my database ?

"Chris Minchin" <minchin@ihug.co.nz> wrote in message
news:c7jjoa$2ub$1@lust.ihug.co.nz...
[color=blue]
> . . . a database which I wish to
> have pictures.[/color]

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP