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

Andy and Stuart,
thank's very much
it works fine

/kostas


----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, October 26, 2006 3:34 PM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>