By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

How to receive the current folder location as string

P: n/a
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.SysCmd(acSysCmdAccessDir)

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
Oct 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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********@Versatel.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.SysCmd(acSysCmdAccessDir)

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


Oct 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.