|
 |
access thread: Application Path
Message #1 by "Maha Arupputhan Pappan" <mahap@p...> on Thu, 17 Jan 2002 04:34:46
|
|
Hi Contributors,
I need your assistance.
I need to get application path programmatically. At present I am doing
this:
strDB = "myDatabase"
strDBPath = "C:\myDBPath\"
AppPath = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE "
strCmd = AppPath & strDBPath & strDB
RetVal = Shell(strCmd, 1)
The application path (AppPath) that I need to get programmatically.
Thanks,
Maha
Message #2 by "John Ruff" <papparuff@c...> on Wed, 16 Jan 2002 23:21:32 -0800
|
|
Use Application.CurrentProject.Path
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Maha Arupputhan Pappan [mailto:mahap@p...]
Sent: Thursday, January 17, 2002 4:35 AM
To: Access
Subject: [access] Application Path
Hi Contributors,
I need your assistance.
I need to get application path programmatically. At present I am doing
this:
strDB = "myDatabase"
strDBPath = "C:\myDBPath\"
AppPath = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE "
strCmd = AppPath & strDBPath & strDB
RetVal = Shell(strCmd, 1)
The application path (AppPath) that I need to get programmatically.
Thanks,
Maha
Message #3 by "Maha Arupputhan Pappan" <mahap@p...> on Mon, 21 Jan 2002 03:41:55
|
|
> Use Application.CurrentProject.Path
>
> John Ruff - The Eternal Optimist J
>
>
>
>
>
>
> -----Original Message-----
> From: Maha Arupputhan Pappan [mailto:mahap@p...]
> Sent: Thursday, January 17, 2002 4:35 AM
> To: Access
> Subject: [access] Application Path
>
> Hi Contributors,
>
> I need your assistance.
>
> I need to get application path programmatically. At present I am doing
> this:
>
> strDB = "myDatabase"
> strDBPath = "C:\myDBPath\"
> AppPath = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE "
> strCmd = AppPath & strDBPath & strDB
> RetVal = Shell(strCmd, 1)
>
> The application path (AppPath) that I need to get programmatically.
>
> Thanks,
> Maha
>
>
>
Hi John,
I tried that but it gives me strDBPath (c:\myDBpath\). I need to get the
MSACCESS program path itself (C:\Program Files\Microsoft Office\Office10\)
and that is AppPath variable.
The filename MSACCESS.EXE is optional. This is always the same in MS
OFFICE.
Thanks,
Maha.
|
|
|
View Cart
