Photographs in Access 2002

[Hoop]

I am trying to set up a database in Access 2002 of Family and want to include
photographs in it. Can someone explain how to get the photographs in the
database?

 

[Todd]

There are 2 ways to go. Either you can just store the filename of the photo
and load it as the form opens. Or, you can import the photo into a record
(this will create a massive database.)

The tricky part is importing/displaying the picture. Displaying the picture
is quite easy using the built-in Image element found in the form toolbox.
Displaying a picture when you only have the filename is a bit different.
The easiest way is to use the "Microsoft Web Browser" control. This allows
you to pass a filename to it and it takes care of displaying/printing the
jpeg/gif/etc. image type.

If you want some sort of interface that lets users paste pictures into an
area on the form, you're in for some hard work. The simplest way is to just
put up a file open dialog box and save the filename of the picture.

 

[Hoop]

Todd, I am sorry but I am new to Access and I cannot understand all that you
are telling me and I cannot find the built-in Image element that you are
talking about in the form toolbox. I don't know where to find the toolbox.
Sorry for not being able to understand it.

 

[Neil]

Hoop,

It's not too difficult, even for a beginner, if you can import some code and
forms into your database then everything you want is easy to achieve.

On my website I have a tutorial that explains how to link pictures to your
database, go to www.nwarwick.co.uk and check out the Access pages, there's a
tutorial that will tell you everything you need to know

HTH

Neil
www.nwarwick.co.uk

 

[Hoop]

Neil,

Thank you very much

Hoop,

It's not too difficult, even for a beginner, if you can import some code and
forms into your database then everything you want is easy to achieve.

On my website I have a tutorial that explains how to link pictures to your
database, go to www.nwarwick.co.uk and check out the Access pages, there's a
tutorial that will tell you everything you need to know

HTH

Neil
www.nwarwick.co.uk