File & path Name in Footer

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

Sapper

O.K. I know it can be done in Excel (=CELL("filename"), but what is the
equivalent in Access?

I work on a network, so my files are kept there and keeping track is a pain,
being able to see on reports in the footer just where the files are would
make my life so easy.

TIA, Colin
 
Sapper said:
O.K. I know it can be done in Excel (=CELL("filename"), but what is the
equivalent in Access?

I work on a network, so my files are kept there and keeping track is a pain,
being able to see on reports in the footer just where the files are would
make my life so easy.
Click to expand...


Which files? Access can utilize many (back end) databases
and other files for the data tables.

The path of the (front end) database with the report object
can be retrieved using:
=CurrentDb.Name
 
Back
Top