Filename of the current application

[Ron]

Hello,
For a Word mailmerge function in an Access application I
need the filename and directory name of the current Access
application, because the mailmerge is within that same
Access application.
I think this is simple, but could not find it,
please help . . .
Ron

 

[Allen Browne]

The full name and path are in:
CurrentDb().Name

The path is:
Left(dbEngine(0)(0).Name, InstrRev(dbEngine(0)(0).Name, "\")-1)

 

[Craig]

Use this:
Application.CurrentProject.Path & "\YourFileName.mdb"
--Craig