Determine Path/Directory of My Frontend

[Guest]

Hi:
I have an application that is split into a front-end and back-end
application. The backend will be installed on the LAN on a drive that
everyone can see; but the front-end app will be running on several different
desktops. What does the code look like to determine the path/directory for
the front end?

I would then want to use that path/directory and have my application export
data to, and open an excell spreadsheet where my desktop front-end is running.

 

[Duane Hookom]

Try:
Left(currentdb.Name, Len(Currentdb.Name)-Len(Dir(Currentdb.Name)))
This will return something like:
C:\Documents and Settings\hookomd\My Documents\Access\

Duane Hookom
MS Access MVP

 

[Dirk Goldgar]

Try:
Left(currentdb.Name, Len(Currentdb.Name)-Len(Dir(Currentdb.Name)))
This will return something like:
C:\Documents and Settings\hookomd\My Documents\Access\

Also, in Access 2000 or later you can use CurrentProject.Path to get
just the path, without having to strip out the filename.

 

[Douglas J. Steele]

Also, in Access 2000 or later you can use CurrentProject.Path to get
just the path, without having to strip out the filename.

Subtle difference, though. Duane's way includes the terminating slash, your
way doesn't. No biggie, but you can't just substitute one method for the
other.

 

[Dirk Goldgar]

Subtle difference, though. Duane's way includes the terminating
slash, your way doesn't. No biggie, but you can't just substitute one
method for the other.

Quite so.

 

[Guest]

Is there no vb constant that can be used for the value of the current user's
My Documents folder?

 

[Douglas J. Steele]

No.

You can use the API approach in http://www.mvps.org/access/api/api0054.htm
at "The Access Web".

 

[Guest]

Thanks Doug this helps out a ton - and there's a lot more useful constants
there that I can use too.