Set and use application path in Access VB

S

Sunny Okorie

How best can I set and maintain a string for Application
path to be used any where in a VBA for Access?
 
F

FrankFelder

Sunny said:
*How best can I set and maintain a string for Application
path to be used any where in a VBA for Access? *
Click to expand...

Try this one:

CurrentProject.Path will return the application path.

dim spath as string
dim sFile as string
sFile = "somefile.txt"
spath = currentproject.Path & "\" & sFil

FrankFelde
 
Top