Re: Simple one! Get path?

Article View: comp.databases.ms-access

Article #356

Back to comp.databases.ms-access Previous Next

#356

From: Nirmala Sekhar
Date: Fri, 09 Apr 1999 00:00

29 lines
1823 bytes

 Set Db = CurrentDb
 strtemp = Dir(Db.Name, vbDirectory)
 strdir = Left(Db.Name, InStr(1, Db.Name, strtemp) - 1)

'  db.name will give you complete path and file name
' strtemp  will give you only the file name
' strdir  will give you only the path

Nirmala Sekhar
-----------------------------------------------------
Monthly newsletter on Microsoft Access at
http://www.saicomsystems.com/index.asp?id=tips
Fortnightly newsletter on motivatioval quotes
http://www.saicomsystems.com/index.asp?id=mind
******************************************************

On Thu, 08 Apr 1999 15:41:42 GMT, "Yves"
<yvaillancourt@cegepsth.qc.ca> wrote:

>How can I get the path of my .mdb.  Like in Excel it's
>Workbooks("Application.xls").Path, but I don't know what's the same in
>Access
>
>Thanks!!!
>
>Yves
>
>

Technical Details

Message-ID: <370d743d.6632273@news.singnet.com.sg>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <W64P2.26284$Ib4.19208@news21.bellglobal.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,1d729218bc5d7f46
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,1d729218bc5d7f46
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,1d729218bc5d7f46
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fe218,1d729218bc5d7f46
X-Google-Attributes: gidfe218,public
X-Google-Thread: 1163bd,1d729218bc5d7f46
X-Google-Attributes: gid1163bd,public
X-Google-Thread: 102b1d,1d729218bc5d7f46
X-Google-Attributes: gid102b1d,public
From: nes@nowhere.com (Nirmala Sekhar)
Subject: Re: Simple one! Get path?
Date: 1999/04/09
Message-ID: <370d743d.6632273@news.singnet.com.sg>
X-Deja-AN: 464289084
References: <W64P2.26284$Ib4.19208@news21.bellglobal.com>
Organization: Singapore Telecommunications Ltd
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.formsprogramming

Reply to Parent Message