name of app

[Guest]

Is there a way to read the name of the .mdb application? If I use
CurrentDb.Name I get the entire path and I would like just the name of the
app without the path.

Thanks!!

 

[Alex Dybenko]

You can use either:
mid(currentdb.name,InStrRev(currentdb.name,"\")+1)

or

CurrentProject.Name

 

[Tim Ferguson]

If I use
CurrentDb.Name I get the entire path and I would like just the name of
the app without the path.

Debug.Print Dir(CurrentDB.Name)


HTH


Tim F

 

[Joerg Ackermann]

Is there a way to read the name of the .mdb application? If I use
CurrentDb.Name I get the entire path and I would like just the name
of the app without the path.

SysCmd(acSysCmdAccessDir)

Acki