File Path on a report

  • Thread starter Thread starter John.bb
  • Start date Start date
J

John.bb

I want to put the path details of the Access file from which a report was run
into the footer of a report. Is this possible and if so how?
 
You can just write those in the footer and it should print on each page of
the report. Use the Label command to write it in.
 
If your database is not split then just add a control to your report and set
its control source to

=CurrentDb().Name

If you database is split into a front end and a backend then you will need
to get the connection string for the backend database.

=CurrentDb().TableDefs("NameOfTableInBackend").Connect

That might return something like the following.
;DATABASE=K:\Info Sys\spencer\EPSDT\EPSDT_BE_M.mdb

Which you could edit to strip off the ";DATABASE="

Mid(CurrentDb().TableDefs("NameOfTable").Connect,11)
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Put a text box with
=[CurrentDb]
in the footer

(Works for Acc2000 but may be different for later versions)
Evi
 
Back
Top