Open Image in Photoshop

[Geoffrey Pocock]

Hello

Sometime back I tried the follow Hyperlink method to open an image file from
Access 97 but could not make it work. I have recently come back to this
project and have tried various methods but with no joy.

I have a database of my digital photographs which displays the pictures as
bound images in a form.

The database has a Field which is the full path to the image eg
"d:\images\set-01\picture.jpg". How can I make a command button which when
clicked will open that image in PhotoShop?

Yours

Geoffrey Pocock

To reply please remove NOSPAM

 

[Warrio]

The command Shell can do that!
it has the same effect as Windows Start Menu, Run
the code you have to write is:

Shell """C:\Program Files\Adobe\Photoshop 7.0\Photoshop.exe""
d:\images\set-01\picture.jpg"

What ever works in the run dialogue box, you can do it with the shell
function

 

[Geoffrey Pocock]

Thank you

No problem with that but I want to replace the image file name with the
[source] field so that it will open whatever image I am looking at on the
form.

Basically I have a database with a single image on each "page" of the form
and various search fields to help me find the picture I am looking for. When
I have found it I want to click the command button and open the image.

Yours

Geoffrey Pocock

 

[Warrio]

so your form that displays the image(s) should also display the Image path
(the field linked to your table) underneath the image when you click on the
button

Shell """C:\Program Files\Adobe\Photoshop 7.0\Photoshop.exe"" " & ImagePath

I'm not sure if it answers exactly to what you're looking for, but just with
this command, you can open the selected picture in PS.

Thank you

No problem with that but I want to replace the image file name with the
[source] field so that it will open whatever image I am looking at on the
form.

Basically I have a database with a single image on each "page" of the form
and various search fields to help me find the picture I am looking for.
When I have found it I want to click the command button and open the
image.

Yours

Geoffrey Pocock

The command Shell can do that!
it has the same effect as Windows Start Menu, Run
the code you have to write is:

Shell """C:\Program Files\Adobe\Photoshop 7.0\Photoshop.exe""
d:\images\set-01\picture.jpg"

What ever works in the run dialogue box, you can do it with the shell
function


"Geoffrey Pocock" <[email protected]> a écrit dans le message
de

 

[Geoffrey Pocock]

Hello

That's it.

Thank you very much


Geoffrey Pocock

so your form that displays the image(s) should also display the Image path
(the field linked to your table) underneath the image when you click on
the
button

Shell """C:\Program Files\Adobe\Photoshop 7.0\Photoshop.exe"" " &
ImagePath

I'm not sure if it answers exactly to what you're looking for, but just
with
this command, you can open the selected picture in PS.

Thank you

No problem with that but I want to replace the image file name with the
[source] field so that it will open whatever image I am looking at on the
form.

Basically I have a database with a single image on each "page" of the
form and various search fields to help me find the picture I am looking
for. When I have found it I want to click the command button and open the
image.

Yours

Geoffrey Pocock

The command Shell can do that!
it has the same effect as Windows Start Menu, Run
the code you have to write is:

Shell """C:\Program Files\Adobe\Photoshop 7.0\Photoshop.exe""
d:\images\set-01\picture.jpg"

What ever works in the run dialogue box, you can do it with the shell
function


"Geoffrey Pocock" <[email protected]> a écrit dans le message
de
[email protected]...

Hello

Sometime back I tried the follow Hyperlink method to open an image file
from
Access 97 but could not make it work. I have recently come back to this
project and have tried various methods but with no joy.

I have a database of my digital photographs which displays the pictures
as
bound images in a form.

The database has a Field which is the full path to the image eg
"d:\images\set-01\picture.jpg". How can I make a command button which
when
clicked will open that image in PhotoShop?

Yours

Geoffrey Pocock

To reply please remove NOSPAM