How to receive the current folder location as string

[Simon]

Dear Access friends,

How can I load a string with his own folder address.

The following code addressed to the system folder of MS programs.

Application.Sys Cmd(acSysCmdAcc essDir)

But now I need a string with the current location, the same location in
which I have started the application.

Thanks for any help,

Simon

[Larry Linson]

To obtain the path in which the current Access database resides (which may
not be the current folder): CurrentDB.Name.

The current folder (aka directory) is returned by CurDir. Here's the Access
2002 Help on CurDir:

CurDir Function
Returns a Variant (String) representing the current path.

Syntax

CurDir[(drive)]

The optional drive argument is a string expression that specifies an
existing drive. If no drive is specified or if drive is a zero-length string
(""), CurDir returns the path for the current drive. On the Macintosh,
CurDir ignores any drive specified and simply returns the path for the
current drive.

Larry Linson

Microsoft Access MVP

"Simon" <Sv********@Ver satel.nlwrote in message
news:45******** *************** @news.tele2.nl. ..

Dear Access friends,

How can I load a string with his own folder address.

The following code addressed to the system folder of MS programs.

Application.Sys Cmd(acSysCmdAcc essDir)

But now I need a string with the current location, the same location in
which I have started the application.

Thanks for any help,

Simon