Pictures in Access Database

[Fred's]

Hello all,

I hope that someone will be able to help with the following. I have an
access 2000 database in which we treat orders. Sometimes we receive
wet and crushed goods. For this reason, my supervisor asks me to
develop something in our database, which enables us to see the images
of the wet and crushed cartons. I want to be able to click on a link
or a button on my access form and to see the images, but without
having the real images in the database. It appears that having several
images directly in the access database makes grow the size of the
database.


So my question is; how can do this? Any tips or website?

Thank you for all your free help!
Fred's

 

[Jeff Boyce]

First, set yourself up a folder into which you can store the images. Come
up with a naming convention for those images that makes them easy to 'spot'
from the filename.

Now add a text field to your table and store the filename (path & file name)
that points to the image.

Add a control on your form that points to the new text field.

Add a Double-Click event to the text control ... and in the procedure, open
the image itself.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Fred's]

First, set yourself up a folder into which you can store the images.  Come
up with a naming convention for those images that makes them easy to 'spot'
from the filename.

Now add a text field to your table and store the filename (path & file name)
that points to the image.

Add a control on your form that points to the new text field.

Add a Double-Click event to the text control ... and in the procedure, open
the image itself.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP









- Show quoted text -

Where do I store the filename (path & file name)?

Please advise.

 

[Larry Linson]

Imaging examples at http://accdevel.tripod.com illustrate three approaches
to handling images in Access... none are "finished" applications but can be
freely used as a starting point. The included document file gives
additional information.

The advertising displayed at that (free) site is selected by tripod and I do
not endorse any products that are so advertised. I have been advised that
some urge you to download screensavers or other programs and I suggest you
do not, as many such downloads collect and report information... usually not
as drastic as identity theft, but most of us do not want a screen saved
badly enough to have our surfing / shopping habits captured.

Larry Linson
Microsoft Office Access MVP