[AccessD] Can Access 2007 discern which folder it lives in?

Dan,

Thanks!

I appreciate the help.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, May 07, 2010 1:35 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Can Access 2007 discern which folder it lives in?

Hi Brad,

To determine which folder the currently running access project lives in
you
can use:

    stg = CurrentProject.Path

Also, if you are running code in a referenced access file, look at:

    stg = CodeProject.Path

HTH,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, May 07, 2010 12:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Can Access 2007 discern which folder it lives in?

All,

In order to simplify our "TEST to PROD" change control we would like to
be able to programmatically (in VBA) determine which folder an ACCDB
lives in.  Is this possible?

Thanks,
Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.