inserting text box content as a path statement when opening application

[bozdog]

Hi
I am currently designing an addition to an access 2000 application that
refers to the path of a specific external file, after a search is
performed.. I would like to know how to insert the result of said search as
the path statement when opening an external application.

i.e stAppName = "C:\program files\Windows
NT\Accessories\ImageVue\kodaking.exe (content of text box or qry here as
path)

Any help appreciated .

TIA

 

[Douglas J. Steele]

You can either concatenate the path to what you already have (making sure to
put quotes around it, in case there are embedded spaces) and use the Shell
command, or, assuming the file extension is associated with the application
you want to launch, you can just use the ShellExecute API call.

To use Shell, assuming your file is in strFile, you'd use something like:

Dim lngReturn As Long

lngReturn = Shell(Chr$(34) & strAppName & Chr$(34) & _
" " & Chr$(34) & strFile & Chr$(34))

(Chr$(34) is ")

To use ShellExecute, take a look at
http://www.mvps.org/access/api/api0018.htm at "The Access Web"

 

[Guest]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting