Filename & Path in Footer?

  • Thread starter Thread starter Sapper
  • Start date Start date
S

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.
 
Sapper said:
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?
Click to expand...


Just use a text box with the expression:

=CurrentDb.Name
 
You may have to use a VBA Function to get the current filename. In a
General Module, insert the following:

Function MyFileName () As String

MyFileName = CurrentProject.Path

End Function

Then, in your Report, you can use "=MyFileName()" to pull in the name.

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.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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]
 
Back
Top