Filename & Path in Footer?

[Sapper]

Hi, Is there a way to put the Filename & Path in the footer of a report?
I know how to do this in Excel using =CELL("filename") , but obviously
it does not work in Access, is there such a thing in Access? TIA, CD.

 

[Douglas J. Steele]

Try =CurrentDb.Name

 

[Marshall Barton]

Hi, Is there a way to put the Filename & Path in the footer of a report?
I know how to do this in Excel using =CELL("filename") , but obviously
it does not work in Access, is there such a thing in Access?

Just use a text box with the expression:

=CurrentDb.Name

 

[Sapper]

Way to guys, Thx a bunch, CD.

: Sapper wrote:
:
: >Hi, Is there a way to put the Filename & Path in the footer of a report?
: >I know how to do this in Excel using =CELL("filename") , but
obviously
: >it does not work in Access, is there such a thing in Access?
:
:
: Just use a text box with the expression:
:
: =CurrentDb.Name
:
: --
: Marsh
: MVP [MS Access]