[MS_AccessPros] Re: best way to use an implicit folder location of SAME PLACE DB is located ?

 

Terence

VBA has a built-in property to get the directory of the database.
CurrentProject.Path

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
> I madde a mistake, in one of my systems, I hard coded C:\Tapestry\blah blah....
>
> There are a couple a places within the code where files are referd to.
> My code always refres to "C:\TAPESTRY\FileABC", etc.
>
> Customer is moving to a shared drive and therefore C:\TAPESTRY will not be applicable. I do not want to Hard code a folder address. I prefer to use an implicit indicating The Same Folder that the Database is located".
>
> What is the prefered way to do this ?
>
> terence
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 8
• New Files 1

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___