M
Matthew Therrien
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.
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.