Home All Groups Group Topic Archive Search About

Running external program from access

Author
21 Mar 2006 12:49 AM
Woodies_46
Ok,

I now u can do it i just don't know how.
What i have is a form in access with has a image in it, i would like to
be able to dblclick on that image and have an external program run eg
paint displaying the image.

Thanks

Author
21 Mar 2006 1:18 AM
Jeff Johnson [MVP: VB]
<Woodies***@hotmail.com> wrote in message
news:1142902177.219484.110100@i39g2000cwa.googlegroups.com...

> I now u can do it i just don't know how.
> What i have is a form in access with has a image in it, i would like to
> be able to dblclick on that image and have an external program run eg
> paint displaying the image.

I believe Access supports the Shell() function. Look it up in help.
Author
21 Mar 2006 2:06 PM
Paul Clement
On 20 Mar 2006 16:49:37 -0800, Woodies***@hotmail.com wrote:

¤ Ok,
¤
¤ I now u can do it i just don't know how.
¤ What i have is a form in access with has a image in it, i would like to
¤ be able to dblclick on that image and have an external program run eg
¤ paint displaying the image.

Are you using an OLE control or an Image control? Where is the image stored?


Paul
~~~~
Microsoft MVP (Visual Basic)
Author
21 Mar 2006 10:03 PM
Woodies_46
I'm using image control and the image is stored on the network and the
image frame just has a link to the image's path.

Cheers
Author
22 Mar 2006 2:11 PM
Paul Clement
On 21 Mar 2006 14:03:17 -0800, Woodies***@hotmail.com wrote:

¤ I'm using image control and the image is stored on the network and the
¤ image frame just has a link to the image's path.
¤
¤ Cheers

In that case you could use the Shell function, as Jeff suggested, if you want to open the image in a
specific application, or you can use the ShellExecute API function call if you want to open the
image in the application that is associated with this file type.

http://vbnet.mvps.org/code/shell/shellexecute.htm


Paul
~~~~
Microsoft MVP (Visual Basic)