print working directory

Thread View: comp.databases.ms-access

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Ini Mon, 01 Dec 2003 13:26

#210

Author: Ini
Date: Mon, 01 Dec 2003 13:26

11 lines
1399 bytes

Hi,

Is it possible in Access97 to display in a msgbox the name of the directory
I'm working in at that moment?

It's like the pwd-command in UNIX-shells.
pwd = print working directory

Thanks,

Ini

Re: print working directory

#211

Author: Allen Browne
Date: Mon, 01 Dec 2003 13:49

24 lines
1765 bytes

The current directory (as far as Windows is concerned), is:
    CurDir

The path of the executing database can be parsed from:
    dbEngine(0)(0).Name
or
    CodeProject.FullName

Use InstrRev() to find the last backslash.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ini" <ini@ini.myweb.nl> wrote in message
news:bqffij$3ra$1@news2.tilbu1.nb.home.nl...
>
> Is it possible in Access97 to display in a msgbox the name of the
directory
> I'm working in at that moment?
>
> It's like the pwd-command in UNIX-shells.
> pwd = print working directory

Re: print working directory

#212

Author: Peter Doering
Date: Mon, 01 Dec 2003 14:01

14 lines
1643 bytes

On Mon, 1 Dec 2003 14:26:40 +0100, Ini wrote:

> Is it possible in Access97 to display in a msgbox the name of the directory
> I'm working in at that moment?
> 
> It's like the pwd-command in UNIX-shells.
> pwd = print working directory

MsgBox CurDir

HTH - Peter

-- 
No mails please.

Re: print working directory

#213

Author: Ini
Date: Mon, 01 Dec 2003 15:00

30 lines
2275 bytes

thanks for the help!

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:3fcb46a1$0$1746$5a62ac22@freenews.iinet.net.au...
> The current directory (as far as Windows is concerned), is:
>     CurDir
>
> The path of the executing database can be parsed from:
>     dbEngine(0)(0).Name
> or
>     CodeProject.FullName
>
> Use InstrRev() to find the last backslash.
>
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Ini" <ini@ini.myweb.nl> wrote in message
> news:bqffij$3ra$1@news2.tilbu1.nb.home.nl...
> >
> > Is it possible in Access97 to display in a msgbox the name of the
> directory
> > I'm working in at that moment?
> >
> > It's like the pwd-command in UNIX-shells.
> > pwd = print working directory
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads