[AccessD] opening a specific file via double click...

Or you could store the path in a table. Suppose you have a table
tblSystemInfo, with a  field called Filepath. Stik the path (with trailing \
character) in there. Then

Dim strPath as string

strPath = Dlookup("FilePath","tblSystemInfo")
Call RunApp(strPath & Me.ActiveControl,1)

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] opening a specific file via double click...
Date: 26/10/06 09:22


On 26 Oct 2006 at 11:02, Kostas Konstantinidis wrote:

> Andy It works,
> but is it posible for access to remember the specific folder
> in which the files are stored ?
> say that cause the folder is always the same (e.g test) and may be its not
> necessary to keep that path in every record. Just only the file name
thank's


Call RunApp("C:Test" & Me.ActiveControl,1)

or

strPath = "C:Test"
Call RunApp(strTest & Me.ActiveControl,1)

or if the files are in the same directory as the Access application

strPath = CurrentProject.Path & ""
Call RunApp(strTest & Me.ActiveControl,1)



--
Stuart


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2