Images in Database

[kojaks43]

This thread (way down at the bottom) goes back almost a month and I just
stumbled upon it. (I reposted it again, because my comments were lost).


Following instructions, I downloaded the Picture2K and it works a
treat. Just what I would like to be able to do within my Licensed Photo
Database.

I imported the table into my database. And that is where I am lost. I
have my own forms and reports, I want to delete the embedded images and
use your linked system.
I do not have the experience to do this. Any additional guidance would
be appreciated.
For example, do I just create a relationship between your Picture2K
table and my photo table? The unique id in the photo table is the same
as the image name in the Picture2K table (except it has the .jpg
extension) I guess I'll have to add the photo image name to the
Picture2K table, right?
Currently the Photo Table holds Unique number, vendor name, description
and embedded picture. The embedded picture is an OLE object. I could
deleted the picture object and add two more fields to the photo table
named filepath and file name (just like yours).
If that is correct, how do I make the report? I made a report from the
Picture2K table. It displayed the path and name. I tried using an
unbound and a bound box. No joy with either. The unbound version
displayed the same icon for each different image, the unbound displayed
nothing. I tried to change the unbound property from embedded to linked
and it said tilt! It was a read only file.

I am certain this is an easy fix. I will kick myself for doing
something foolish, but I just don't get it.
Need your help.
Thanks





quote:
--------------------------------------------------------------------------------
Originally posted by Arvin Meyer
Have a look at the PictureMgr sample database on the download section
of my
website. It does exactly what you want and you can import everything in
to
your own application, or just add the extra fields to one of the tables
you
can create. All the code is available for your use so you won't have
to
write very much of anything.

http://www.datastrat.com/Download/Picture2K.zip

Graham's suggestion of using a form is a good one. Never use a table
since
you can not write any code to control and validate anything you need
to. If
you insist on a datasheet view, do it in a form datasheet view, not a
table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Graham,

Many thamks for your reply regarding my question on how to
find and store the file & pathnames of images being
inserted into a bound OLE object.

I am relatively new to Access and perhaps I either didn't
articulate my request clearly enough or haven't really
understood how your comments address my need.

Let me try again.

I have a very simple table -

Photo Ref No : text
Photo Descr : text
Photo Image : OLE
City/Location: text
Photo File/Path : text

I have a very large library of photos (390mb and growing
every day)

Each image will have a record created describing its
content (description) and where it was taken and that
photo's image needs to be stored in that record - hence, I
insert that image into an OLE object-type field, and then
go onto create the next record, insert its image and so on.

BTW - I am not using a form for this nor do I have any
need to - unless you say differently - as a datasheet view
is quite adequate. If and when I need to view what a
particular record's image looks like - I click on the OLE
field and see its jpg or BMP content etc.

From my study of Access, I had formed the understanding
that to connect a specific image to a specific record - I
needed to use a Bound frame, if I go onto use a form for
record display.

Let me move onto the main issue - finding as in capturing
that image's file and path name. For example - if I have
one record into which I have inserted a 'Create From File -
linked' jpg and click on the record - in my case,
Internet Explorer opens in a window with my image and in
the Explorer window is the jpg's existing tile or file
description; if I right click the jpg - I can discover its
file and path names. This info is what I want to "lookup"
or capture in Access so that I can store this file and
path in a new field called Photo FilePath. (Here I would
use a form or a calculated field in a query (?))

Sorry for the long message but I am hoping that I have
somewhow more clearly conveyed what I am trying to achieve.

Regards

Matthew

You can call up the standard Windows File Open dialog
box. See
http://www.mvps.org/access/api/api0001.htm for some sample
code.

I suggest you store *only* the file path in a text field,
and don't use an
OLE field. That would cause your database to bloat very
quickly.

You can easily load a file into an image control on a form
by setting the
..Picture property.